[tazzarkin]

Thank you for this. I don't understand why no one ever posted a thank you. Well, anyways, this will help a lot.

[kp^]

Yes, thank you!

[Markowitch]

How do you close your board during the backup?

[jkcerda]

coooooool

[Jasem]

Excellent, thank you!

[sheppardzwc]

Just to bump, THANKS! This is exactly what I was looking for.

Just a question -- how can I fix this?:

will@rodan:/tth/cron$ php backup.php

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 474195519 bytes) in /tth/cron/backup.php on line 20

[dbembibre]

Originally Posted by sheppardzwc

Just to bump, THANKS! This is exactly what I was looking for.

Just a question -- how can I fix this?:

will@rodan:/tth/cron$ php backup.php

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 474195519 bytes) in /tth/cron/backup.php on line 20

Increase memory_limit in php.ini

[ubcforums]

thanks..this saves lot of time

[squishi]

Thanks for the code.
Though, a mysql backup by email? I rather not receive 1GB of email attachments. :-)

[geckoz]

Doesn't work for me ... I think you must have SAFE MODE ON but I don't want to turn it off.

[Old-Git]

The tech support guy at my hosting gave me the following info to use Cron, via Cpanel, to do a backup of my database every Sunday night at midnight.

In order to do a backup of your database through a cron job, you can set this up in cpanel. Click on Cron Job, then select Standard or Advanced. You can select the backup frequency that you need then enter the command to backup. Here is a sample cron job:

0 0 * * 0

date=`date -I`; /usr/bin/mysqldump -uDBUSERNAME -pPASSWORD dbname > /home/CPANELUSERNAME/FILE_NAME_HOME_DIRECTORY$date.sql

This cron job will do a backup of the database every Sunday at midnight. Then it will save the backup with the current date appended to the file name.

A few notes:

-uDBUSERNAME – there should be no space between -u and DBUSERNAME, DBUSERNAME is the username of the database you are trying to backup.

-pPASSWORD – there should be no space between -p and PASSWORD, PASSWORD is the password of the database user.

dbname – this is the name of your database.

/home/CPANEL_USERNAME/BACKUP_NAME$date.sql – cpanelusername is your username to log into cpanel, and this will save the backup in your home directory (you can change it to whatever directory you want). You can call the backup whatever you wish but adding $date at the end will append the date to that backup.

I haven't tried this yet (just received it) but thought I'd offer it here for comment!

Rgds