使用 AutoMySQLBackup 進行自動 mysql 備份

Share This Post

安裝 automysqlbackup

sudo apt-get install automysqlbackup

安裝完之後,系統每天會執行一次 mysql 備份,檔案將儲存於

/var/lib/automysqlbackup

驗證運作是否正常

可以透過

sudo automysqlbackup

來進行,執行之後可以檢查下備份的內容

ls -R /var/lib/automysqlbackup/
/var/lib/automysqlbackup/:
daily  monthly  weekly
/var/lib/automysqlbackup/daily:
picklete_agricloud
/var/lib/automysqlbackup/daily/picklete_agricloud:
picklete_agricloud_2015-11-10_07h24m.Tuesday.sql.gz
/var/lib/automysqlbackup/monthly:
/var/lib/automysqlbackup/weekly:
picklete_agricloud
/var/lib/automysqlbackup/weekly/picklete_agricloud:

完成

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Do You Want To Boost Your Business?

drop us a line and keep in touch