Automated database backup

[mooneyn]

Hi,

I am using the mod "Backup MYSQL Plugin" for the database backups that was made by DrByte.

This is a create mod, however it would be even better if it was something that could be automated.

So i am trying to make it into a script that i can cron it to run each night/week.

Here is my code so far, however when i run it does nothing. Can anyone look and see what i've done wrong?

<?php

require('includes/application_top.php');

$toolfilename = '/usr/local/bin/mysqldump';
$output = DIR_FS_ADMIN . 'backup.log';
$dump_results = DIR_FS_ADMIN . 'backup-dump.log';
$backup_file = 'db_' . DB_DATABASE . '-' . date('YmdHis') . '.sql';
$dump_params .= ' "--host=' . DB_SERVER . '"';
$dump_params .= ' "--user=' . DB_SERVER_USERNAME . '"';
$dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';
$dump_params .= ' --opt';  
$dump_params .= ' --complete-insert';  
$dump_params .= ' "--result-file=' . DIR_FS_BACKUP . $backup_file . '"';
$dump_params .= ' ' . DB_DATABASE;
$dump_params .= " 2>&1";

$resultcodes = @exec(OS_DELIM . $toolfilename . $dump_params , $output, $dump_results );
@exec("exit(0)");
        
require('includes/application_bottom.php');

?>

Thanks in advance!!!

[kobra]

PM me for a cron script for this

[mooneyn]

Hi,

More of less worked it out myself. Here is my code, everyone free to use / reuse / comment as they feel fit.

Most of it is inspiried by DrByte, so cheers to him.

<?php

// Change these to suit your location
$location = '/usr/home/XXXXXX/www/htdocs/XXXXadmin/';
$toolfilename = '/usr/local/bin/mysqldump';
$gzipfilename = '/usr/bin/gzip';

require($location . 'includes/configure.php');

$output = DIR_FS_ADMIN . 'backup.log';
$dump_results = DIR_FS_ADMIN . 'backup-dump.log';
$backup_file = 'db_' . DB_DATABASE . '-' . date('YmdHis') . '.sql';
$dump_params = ' "--host=' . DB_SERVER . '"';
$dump_params .= ' "--user=' . DB_SERVER_USERNAME . '"';
$dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';
$dump_params .= ' --opt';
$dump_params .= ' --complete-insert';
$dump_params .= ' "--result-file=' . DIR_FS_BACKUP . $backup_file . '"';
$dump_params .= ' ' . DB_DATABASE;
$dump_params .= " 2>&1";

exec($toolfilename . $dump_params , $output);
exec($gzipfilename . ' ' . DIR_FS_BACKUP . $backup_file, $output);

?>

[yellow1912]

Nice, thank you for sharing this. Maybe you should post this in the Free Add On section so everyone can easily find it?
Regards

[xman888]

Hello Mooneyn,

Could you provide the steps in how you use your code to create a cron?

1. Ie. What do we save your code as?
2. What do we enter in the cron in cpanel?

Kind regards,
Anthony