Thanks for this :) Great Job!!

When I am trying to run this i get an error Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.
Can you explain me what i am doing wrong ?

Did you chmod the folder that the backup is being written into to 777?

Are you using an absolute path to the backup folder (i.e. /home/user/public_html/backup/) or wherever it is?

Also, if you are running it again on the same date, make sure that there is not a file in the backup folder with that date already... :) hth

The script auto removes a file of the same name before the backup process.

-------

But yes, cyber is right, make sure you are chmodding the directory you are wanting to save the dump to, 777.

Also make sure the path is valid. Either use a full path, or a path relative to the main forum directory.

For example I use:

$backup['DUMP_PATH'] = 'admincp/backups';

Which saves the dump to the backups folder inside my admincp folder.

When I ran the database backup via cron -- it worked perfectly -- but it did not compress the FILE -- and it left my forums closed with the default "backing up the database" message.

Any suggestions?

Run the cron manually, and make sure you don't get any error messages.

------

What compression settings are you using, Mysqldump or PHPdump etc..

I ran the cron manually -- and it works perfectly. I didn't get any error messages on the screen.

These are the compression settings from the config file:

$backup['COMPRESS'] = 1;
$backup['BUFFER'] = 1048576;
$backup['COMPRESSION']= 'gz';
$backup['COMPRESSORS']= array(
'gzip' => 'gzip',
'bzip2' => 'bzip2',
'tar' => 'tar',
'zip' => 'zip'
);

$backup['COMPRESSION']= 'gz';

to zip, or tgz..

As for the script not setting your forum back up.. that really doesnt make sense, unless for some reason something is causing premature termination of the script, sometimes calls to functions that don't exist will do that..

What php, mysql version are you using?

Mysql = 4.0.22

Php = 4.3.10

I figured out what i was doing wrong :) Thanks great script.