asked by (8.9k points)
0 like 0 dislike
44 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
answered by (8.9k 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.

Related questions

0 like 0 dislike
1 answer 4 views
0 like 0 dislike
1 answer 22 views
0 like 0 dislike
1 answer 42 views
0 like 0 dislike
1 answer 32 views
0 like 0 dislike
1 answer 36 views
0 like 0 dislike
1 answer 20 views
0 like 0 dislike
1 answer 45 views
0 like 0 dislike
1 answer 53 views
0 like 0 dislike
1 answer 32 views
...