1

Restore Multiple Mysql Databases from a single dump using command line

I exported all my databases as a single File using phpMyAdmin.
Now I wants to restore to a Mysql db which doesn't have a working phpMyAdmin How should I restore all of them at once using command line?

MySQL Dump Add a comment
lincoln
asked Jan 17 2019

Answer

1

You can concat all the files into one single file and import/restore using the Following commands

mysql -u username -p < dump.sql

Create one file using

mysqldump -u username -p --all-databases > dump.sql

Add a comment
linuxhelp
asked Jan 25 2019
Post your Answer