Daily Backup of All MySQL Databases !
By Kernel 7 On June 2nd, 2009As you already know, “mysqldump” is nifty command. The following examle script should be scheduled to run daily via “cron” to backup all your MySQL Databases in a SQL file like “MySQL-Dump—v2009-06-02.sql” and compress it to save on space:
mysqldump –host=YOUR_MYSQL_HOST –port=YOUR_MYSQL_PORT –user=root \
–password=YOUR_ROOT_PASSWORD –add-drop-database –add-drop-table –comments –force \
–all-databases > /YOUR_BACKUP_LOCATION/MySQL-Dump—v`date +”%Y-%m-%d”`.sql ; \
gzip /YOUR_BACKUP_LOCATION/MySQL-Dump—v`date +”%Y-%m-%d”`.sql