Page 1 of 1

How to create a MySQL backup of all the database

Posted: Sun Jul 01, 2012 3:08 pm
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