by (11.1k points)
0 like 0 dislike
64 views

How I can to dump all databases of DBMS MySQL? Me need backup more than one database.

mysql dump all databases

1 Answer

0 like 0 dislike
by (11.1k points)

You can backup more than one database so:

mysqldump -u [user] -p –databases [database_name_1] [database_name_2] [database_name_n] > [filename].sql

Backup of whole all databases:

mysqldump -u [user] -p –all-databases > [file_name].sql

This will dump all databases to a single file, and you can use that file to restore all databases at once.

Your answer

Try to answer the question as detailed as possible.
Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.