Automatically Backup your MySQL Database

From TomSchaefer.org Wiki

Jump to: navigation, search

Automatically Backup your MySQL Database on Debian or Ubuntu

http://sourceforge.net/projects/automysqlbackup/

Loosing a database is one of the worst things that could happen to you, trust me I know. You want to make sure that its being backed up regularly but always exporting it in phpmyadmin is such a pain in the ass. You want it automatic. Well thanks to wipe_out [at] lycos.co.uk you can with a script called MySQL Backup Script

Download the script and copy it into your cron.daily which is located in 

 /etc/cron.daily/

Edit the USERNAME, PASSWORD, BDNAMES, and BACKUPDIR. That's it, it will work now. Optionally you can edit the other variables but they are not required for the script to work.

Retrieved from "http://www.tomschaefer.org/wiki/index.php/Automatically_Backup_your_MySQL_Database"
Personal tools