📋Steps in this guide1/1

Backup multiple mysql databases

-- Backup multiple databases

mysql configurationintermediate

by MYSQL

13 views

Backup multiple mysql databases

-- Backup multiple databases -- Backup all databases:

Code/Command (click line numbers to comment):

For example, if you want to take backup of both sampledb and newdb database, execute the mysqldump as shown below:
[root@localhost]#
mysqldump –u root –p --databases sampled newdb > /tmp/dbdump.sql
We cannot take backup of information_schema and performance_schema databases as these are metadata databases.
root#
mysqldump -u root -p --all-databases > all-database.sql

Comments (0)

Please to add comments

No comments yet. Be the first to comment!