How to backup MySQL database

Use mysqldump in a Cron Job

You can use a simple cron job to regularly backup the MySQL database used by Watch My Domains SED. Here is a simple bash script to backup the database to a date stamped file in /home/wmdsed/backup/ folder.

mysqldump -u xxxxxx -pyyyyyy --skip-lock-tables database_name > /home/wmdsed/backup/wmdsed_`date +%Y%m%d`.sql

Replace the xxxxxx with your database user name, yyyyyy with the database password and database_name with your database name. Remember to set the backup path also.