asked by (6.6k points)
0 like 0 dislike
26 views

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 (6.6k 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 11 views
0 like 0 dislike
1 answer 32 views
0 like 0 dislike
1 answer 18 views
0 like 0 dislike
1 answer 27 views
0 like 0 dislike
1 answer 19 views
0 like 0 dislike
1 answer 41 views
0 like 0 dislike
1 answer 27 views
0 like 0 dislike
1 answer 23 views
0 like 0 dislike
1 answer 15 views
...