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

What are Astutium's primary and secondary nameservers? (Views: 30603)

How do I REPAIR all MySQL databases on my virtual / dedicated server? (Views: 2129)

Microsoft JET Database Engine error '80040e14', Syntax error in... (Views: 4883)

How do I create a MySQL database in DNP ? (Views: 2205)

How do I change my hosts file? Or, how can I see my domain before DNS changes propagate? (Views: 3333)