database restore from sql file

[riches85]

I have several databases that I would like to save to a sql file and then transfer them to another system. I used the command &quot;mysqldump databasename > databasename.sql&quot; to back it up and then &quot;mysql databasename < databasename.sql&quot; to restore it just fine. Now there are alot of databases that need to be transfered and instead of backing up each database one by one, i used the --all-databases option when i used mysqldump. Everything went fine, but I'm not sure how to restore it. Every command I have seen requires a database name. Any help would be greatly appreciated. Thanks

 

[sleipnir214]

Use the database &quot;mysql&quot;. The scripts mysqldump produces will create all the other databases as needed and use them as appropriate. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!