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

Apple Mail leaves messages on server, MAC downloads multiple copies of the same email (Views: 4232)

What is the server path to my files ? (Views: 2297)

What are Aconix Hosting\'s primary and secondary nameservers? (Views: 238)

'80004005' Could not use ''; file already in use (Views: 2076)

What are desigbRweb's primary and secondary nameservers? (Views: 70)