ylpnvq
Last Updated: February 25, 2016
·
1.16K
· elboletaire
8d0b1790c5980834ecbb537eafa1a385

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
Say Thanks
Respond

3 Responses
Add your response

7107
Profilemac

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

over 1 year ago ·
7108
Avatar ika

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

over 1 year ago ·
7336
8d0b1790c5980834ecbb537eafa1a385

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

over 1 year ago ·