Simple mysqldump cron script

[Lodius2000]

Hi guys... im trying to make a db backup script and I got this code from the intarwebs, and wouldnt you know, its not working

 

in produces a .gz file that when uncompressed is a blank file

 

whats wrong, i am betting its in the $command line but i dont really know what all that stuff means, other than the variables in there

 

<?php
//config.php contains all variables used in $command line, all of which are copy pasted from db_login.php
include ('../../dbbackups/config.php');
require ('../install/PEAR/DB.php');
require ('../../dbfiles/db_login.php');

$backupFile = '../../dbbackups/' . date("Y-m-d") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);

?> 

 

thanks for your help

[phparray]

When calling and external command from php you need to use the full path to the command.

 

If you have ssh access to your server login and run

 

which mysqldump 

 

to find the path. If you don't have ssh access contact your server provider. Edit the command to include the full path.

 

A common path is /usr/bin/mysqldump

 

Also I doubt you need the PEAR/DB.php file unless you put it there for a reason. 

[Lodius2000]

yeah i need the pear because my dblogin is written using peardb

 

edit: im on the horn with my tech support now and they didnt tell me to use a file path to mysqldump...weird

[Lodius2000]

do i even need to connect to my db, or does mysqldump do that for me? i mean it seems odd that i am putting in the same usn pw and hostspecs twice?

[phparray]

do i even need to connect to my db, or does mysqldump do that for me? i mean it seems odd that i am putting in the same usn pw and hostspecs twice?

 

You do not. But what you do need is the full path to mysqldump and the apache or whatever user php runs as needs write permissions on the destination folder.

 

The apache error logs file should tell you what the problem is.