Home > cPanel Help > Cpanel Cron Job for taking mysql database backup

Cpanel Cron Job for taking mysql database backup

November 27th, 2008

Command for taking backup of your database..
you can take the database backup through the following cron job

0 0 * * * mysqldump -hlocalhost -uusername --password=password --opt yourdbname >
/home/username/public_html/dbdump.sql

Repalce username and passwd with your mysql database_user and passwd

The above cron job would take the backup of your database
daily at 12:00

cPanel Help

  1. No comments yet.
  1. No trackbacks yet.