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]
我主要是找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]
文章標籤
全站熱搜
電腦技術 (22)