0 like 0 dislike
15 views
asked by (5.3k points)

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

mysql dump all databases

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.

1 Answer

0 like 0 dislike
answered by (5.3k 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.

Related questions

0 like 0 dislike
1 answer 9 views
0 like 0 dislike
1 answer 29 views
0 like 0 dislike
1 answer 10 views
0 like 0 dislike
1 answer 23 views
0 like 0 dislike
1 answer 33 views
0 like 0 dislike
1 answer 25 views
0 like 0 dislike
1 answer 16 views
0 like 0 dislike
1 answer 3 views
...