There's an FAQ on this topic:
https://www.zen-cart.com/tutorials/i...hp?article=103
Pay attention to the "NOTE" in step 3 ... if you haven't already selected your database before exporting, the create-database stuff will be inserted into your export ... which can cause confusion and permissions problems when importing later.



