Setting up a Cron Job from cPanel for Database backup with php script

[tejasluvs]

I want a PHP cron script to be set up with cPanel cron jobs that would take backup of MySQL database.

Regards,

[pritaeas]

Is there a specific reason you want to do it with PHP ? If you use a shell script it can be as small as this:

#!/bin/sh
DATE=`/bin/date +"%G%m%d"` ;
mysqldump --host=localhost --user=YOURUSER --password=YOURPASSWORD --all-databases --single-transaction --quick | gzip > ./YOURFILEPATH/backup-$DATE.sql.gz ;

[tejasluvs]

Is there a specific reason you want to do it with PHP ? If you use a shell script it can be as small as this:

#!/bin/sh
DATE=`/bin/date +"%G%m%d"` ;
mysqldump --host=localhost --user=YOURUSER --password=YOURPASSWORD --all-databases --single-transaction --quick | gzip > ./YOURFILEPATH/backup-$DATE.sql.gz ;

Can you please guide me how to get the shell script do the job for me? I have not used shell scripts before.

[pritaeas]

You can save these 3 lines as 'backup.sh' and use it when setting up your cron job. For help on setting up your cronjob, see the cpanel documentation.

[tejasluvs]

You can save these 3 lines as 'backup.sh' and use it when setting up your cron job. For help on setting up your cronjob, see the cpanel documentation.

Thanks for the hint and guidance.

[tejasluvs]

Thanks for the hint and guidance.

Thanks,

The command works for me. Could you please help me little bit more? what will be the parameter for backing up a single or multiple table?

[pritaeas]

You can find all parameters here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

[tejasluvs]

You can find all parameters here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

I have referred to the document above but not able to provide the options correctly. Could you please place the options in your given command?

[pritaeas]

The first example on the page ...

mysqldump --host=localhost --user=YOURUSER --password=YOURPASSWORD YOURDATABASE YOURTABLE

[tejasluvs]

The first example on the page ...

mysqldump --host=localhost --user=YOURUSER --password=YOURPASSWORD YOURDATABASE YOURTABLE

Thanks, I really appreciate your efforts to help me out.