MySQL periodic backup with PHP

[psalzmann]

Great tool, easy to use and understand

I was investigating the script to ensure it could support both Windows and Linux. As it seems, the current script is ready for linux or compatible.

Would there be any issue by changing:

if ($remove_sql_file== "yes") { 
      exec("rm -r -f $filename"); 
} 

To this:

if ($remove_sql_file== "yes") { 
      //exec("rm -r -f $filename"); 
      if (file_exists($filename)) {
           unlink($filename);
      }
} 

AND:

if($remove_gzip_file=="yes") { 
exec("rm -r -f $filename2"); 
} 

To this:

if ($remove_gzip_file == "yes") { 
      //exec("rm -r -f $filename2"); 
      if (file_exists($filename2)) {
    unlink($filename2);
      }
} 

To support both Windows/Linux? Would this be the best way? For this tool I'd only be interested in obtaining the .gz of the DB dump sent to my email address and never leave the archives on the server (at all). For this, I'd want to ensure the backup tool could handle both Windows/Linux in terms of removing the file(s) or dumps after the email (with attachment) has been sent.

Any suggestions would be appreciated

Thanks

[Toly]

Lance,

As posted in another post, the 127 error means that the command was not found. Are you using the full path to the file?

Remember to use the full path (IE '/usr/local/bin/foo' instead of 'foo') when using passthru, otherwise you'll get an exit code of 127 (command not found).

Remember, you'll also get this error if your file does not have executable permission.

[Toly]

To support both Windows/Linux? Would this be the best way? For this tool I'd only be interested in obtaining the .gz of the DB dump sent to my email address and never leave the archives on the server (at all). For this, I'd want to ensure the backup tool could handle both Windows/Linux in terms of removing the file(s) or dumps after the email (with attachment) has been sent.

I don't think there should be any problems using file_exists and unlink in any OS as long as you provide the full path to the respective directory.

[random_X]

how i can make it work in Safe_Mode ?

bouth , Dumb and restore ?

[Toly]

Sorry but I can't think of anything to make this work in Safe Mode since pretty much every function that is able to execute commands is disabled or restricted.

[holmescreek]

As others have mentioned you can set up a cron job to run a script. I would suggest having the cron job to :

1) run mysqldump --- to dump the database into a file

2) run zip with recursion to compress the mysqldump file and the entire site into one zip file that is stored in an .htaccess protected folder.

3) Run a PHP script that notifies your client that the backup file has been created and create a link where they can http download the file, from a folder that is password protected (.htaccess) . Of course, give your client the user id and password and the download will start automatically.


I know this is an old thread, but thought I would throw in m two pence worth.