How to create a MySQL backup of all the database

Post Reply
a24uall
Site Admin
Posts: 166
Joined: Sun Jul 01, 2012 9:07 am

How to create a MySQL backup of all the database

Post by a24uall »

Create a folder where you have to store the backup
mkdir /var/lib/mysqlbackup
You should be in that folder before the backup script is run
cd /var/lib/mysqlbackup
Now run

Code: Select all

for db in `echo 'show databases;' | mysql -u root --password='H00AOoE' | grep -v ^Database ` ; do mysqldump --opt $db | gzip > $db.sql.gz ; done
OR

Code: Select all

for db in `echo 'show databases;' | mysql | grep -v ^Database ` ; do mysqldump --opt $db | gzip > $db.sql.gz ; done
Arun
WebhostingDevelopment.com
Post Reply

Return to “Backup”