Knowledgebase

How to Backup your MySQL DB databases

Backup command for mysql databases

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* 2am to keep load down on the server duriung peak hours, and be warned it will use up your bandwidth/data-transfer allocation quickly, so weekly backups are recommended over daily ones if your DB is relatively static.

Add to Favourites    Print this Article

How do I repair a damaged MySQL table, rebuild index or prepare for backup ? (Views: 2851)

Cron Cheat Sheet (Views: 2883)

How do I add an E-mail Account to Webmin (in Virtualmin) ? (Views: 8451)

How do I use a Microsoft Access database on Windows Plesk Hosting. (Views: 8877)

How do I access the Ensim control panel ? (Views: 8329)