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 的頭像
gisanfu

創造心理的感動

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