0 like 0 dislike
1 view
asked ago by (4.5k points)

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

mysql dump all databases

Your answer

pre, code

Preview

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 ago by (4.5k 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 7 views
0 like 0 dislike
1 answer 22 views
0 like 0 dislike
1 answer 9 views
0 like 0 dislike
1 answer 16 views
0 like 0 dislike
1 answer 23 views
0 like 0 dislike
1 answer 18 views
0 like 0 dislike
1 answer 8 views
0 like 0 dislike
1 answer 21 views
...