Automatic MySQL backup using automysqlbackup

Sooner more than later, you will regret not having proper backups of your MySQL databases. Fortunately, there is a simple script that can automate this task for you. It's called automysqlbackup. Here's a quick howto to get you started:

  1. Download automysqlbackup
  2. Extract the file
  3. Run installation script (
  4. Edit configuration file (/etc/automysqlbackup/automysqlbackup.conf)
  5. Update at least CONFIG_mysql_dump_username, CONFIG_backup_dir (make sure that this folder exists and is writable by the user who will be running the script), CONFIG_mysql_dump_password, your rotation settings, CONFIG_mailcontent, CONFIG_mail_address
  6. Add a cron job to run the script automatically (i.e. 00 1 * * * root automysqlbackup)
  7. Test your installation by first running automysqlbackup manually and then by keeping an eye out to test your cronjob too.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

HOWTO install Gnome and VNC on your Linux VPS

Install Gnome Desktop, VNC Server and Xterm: yum groupinstall gnome-desktop yum install...

SSH without passwords

If you need quick access from your linux desktop to the VPS there is an easy solution that won't...

How to move a website without downtime

You have a website you need to move to a new web server on a new IP address. You intend to keep...

Plesk, Qmail and Spamdyke

Spamdyke installation is quick and easy. It seamlessly installs between Plesk and Qmail. Below we...

Download all files and folders from remote FTP server

This is a useful command that will download all files and folders from a remote FTP server:wget...