http://www.webcheatsheet.com/sql/mysql_backup_restore.php

我主要是找big database's backup
這篇文章找到了,還說明的蠻詳細的

Back up your MySQL Database with Compress

If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.
$ mysqldump -u [uname] -p[pass] --flush-logs --opt [dbname] | gzip -9 > [backupfile.sql.gz]
創作者介紹

創造心理的感動

gisanfu 發表在 痞客邦 PIXNET 留言(0) 人氣()