| For those looking to get a regular backup of your MySQL database, the command to add as a cron.job ...
/usr/bin/mysqldump -u{mysql_username} -p{mysql_password} {mysql_db_name} |gzip |uuencode {mysql_db_name}backup.sql.gz |mail -s "database backup" {emailaddress}
replace :
{mysql_username} with the database owner username
{mysql_password} with the database password
{mysql_db_name} with the database name
{emailaddress} with your email address.
Please only add the backups as jobs *after* midnight to keep load down on the server duriung peak hours, and be warned it wll use up your bandwidth/data-transfer allocation quickly, so weekly backups are recommended over daily ones if your DB is relatively static |
