Backup

Using a cron job

 mysqldump -u db_username -pdb_password db_name > backup_name.sql