Home > Bookmarks, Linux > Linux – backup ALL MySQL databases

Linux – backup ALL MySQL databases

September 22nd, 2007 Leave a comment Go to comments

mysqldump -u root -h localhost -pMyPassword -A | gzip -9 > allmy-db.sql.gz

backup all database from srv to allmy-db.sql.gz file!

———-

To restore compressed backup files you can do the following:

gunzip < allmy-db.sql.gz | mysql -u root -pMyPassword

or uncompress gz file: gunzip allmy-db.sql.gz

and use:
mysql -u root -pMyPassword -h localhost -A < /path/allmy-db.sql
or
mysql
-u root -pMyPassword -h localhost -e “source /path/allmy-db.sql” -A

Categories: Bookmarks, Linux Tags: , , ,
  1. No comments yet.
  1. No trackbacks yet.
GoCache - ByREV-Cache v1.0 - live served in : 0.229135 sec (gzip)