Sometimes you want to keep a backup of all MySQL databases, this can be a problem if you have more than 100 MySQL databases! There is an easy way to export all of them at the same time and again import the all of them into MySQL server at one time. You must use Mysqldump command.

Export:

mysqldump -u root -p --all-databases > alldb.sql

Import:

mysql -u root -p < alldb.sql