Restoring MULTIPLE MySQL databases from one file at the command line?
Why don't you concat all the files into one single file and import/restore using
mysql -u username -p < dump.sql
Create one file using
mysqldump -u username -p --all-databases > dump.sql
If you backed up many database to 1 file, I suppose you backed up the create database
statements in the same file. If not you only need to add the create database
and use database
statements to your file at the proper places.
After that, the command to load the file to mysql is:
mysql -p < sqlfile.sql
-p
is to ask for your password.
You can use -u username
if you need to use another user.