Mysqldump backup into a compressed package

You can directly apply mysqldump directly to backup the tables in the MySQL database or the entire database into a compressed format package

No more nonsense, just go to the code.

[SQL]View PlainCopyprint?

1. Mysqldump-h localhost-uroot-phb118114 DB_NDC Prod_customer | gzip >/home/prod_customer_${daystring}.sql.gz
2. Mysqldump-h localhost-uroot-phb118114 DB_NDC prod_customer_20141209 | gzip >/home/prod_customer_bdc_${daystring}.sql.gz

Let's try it.

Backup strategies for other mysqldump

For details, see: http://blog.csdn.net/zfszhangyuan/article/details/52459921

Mysqldump backup into a compressed package