ylpnvq
Last Updated: February 25, 2016
·
2.081K
· elboletaire

mysqldump | gzip, best combo

Manage gzipped mysql dumps, without the need to extract them.

Backup:

mysqldump -u username -p your_db_name | gzip -9 > your_db_name.sql.gz

Restore:

zcat your_db_name.sql.gz | mysql -u username -p your_db_name

3 Responses
Add your response

7107

Add --opt --routines and your DUMP will be the best.

over 1 year ago ·
7108

This is also nice, if you have many databases and to support backup rotations: http://sourceforge.net/projects/automysqlbackup/

over 1 year ago ·
7336

You may also use --triggers but it's a user decission to use options or not.

over 1 year ago ·