How to restore multiple databases or all databases dumped by mysqldump?

Suppose if we dumped multiple databases or all databases and now want to restore it then we can do it using the following example-

C:\mysql\bin>mysql -u root < tutorials_query1.sql

With the help of the above query, we are restoring multiple databases named "tutorials" and "query1" dumped in a file named "tutorials_query1.sql". In this case we don't need to write the name of the database.

Similarly, with the help of the following query, we can restore all the databases dumped by mysqldump -

C:\mysql\bin>mysql -u root < alldatabases.sql

With the help of the above query, we are restoring all the databases dumped, which were dumped in in a file named "alldatabases.sql". In this case we don't need to write the name of the database.

The above is the detailed content of How to restore multiple databases or all databases dumped by mysqldump?. For more information, please follow other related articles on the PHP Chinese website!