Topic: Cron issue

[Steve]

Go figure i busted obes balls now I have an issue. I wrote a cron php file to backup one of my mysql db's. I am testing it at the command line using php myfile.php. It is executing, but is not saving the entire DB. This DB is close to 65MB, yet the file size after running the script is only 203k.

Any ideas as to why?

Code minus sensitive data.

Code: [Select]

<?php
$u = 'XXXXXX';
$p = 'XXXXXX';
$d = 'XXXXXX';
$x= 'mysqldump --no-create-db=true -S /*****/tmp/mysql5.sock -u $u -p $p $d > ******.sql';
system($x);
?>

[Mike]

Well, what is in the file it dumps?

[Steve]

Didnt look. I will check it and report back

[Steve]

Sorry long day. Contents are

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

[Mike]

Well there's your problem.

As a reference, here is our backup's command:

Code: [Select]

/usr/local/bin/mysqldump --password=<PASSWORD> --allow-keywords --quote-names --opt --master-data=1 --database <DATABASE> -S /tmp/mysql.sock ><DUMPFILE>

[Steve]

Yea but this is the backup line that works perfectly right in the shell. In fact on my host it is the only command that will dump the DB. So it's the command I need to execute in cron, and i checked and it is working outside of the php file.

[ober]

Why are you using the php file at all?  Just put the command directly in the cron.  What you're doing is overkill.

[Steve]

Just what I was taught I guess. Every cron I have ever set is in a php file. So I can actully just do:

00 4 * * 0 mysqldump --no-create-db=true -S /*****/tmp/mysql5.sock -u user -p password dbname > savename.sql

And it will run correctly every sunday at 4am?

[Mike]

It is generally a good idea to give the full path to commands.

[Steve]

in this case it is, I'm just editing it since this is public view

[ober]

Not sure about the way you set it up directly from command line.  I always do mine through cpanel.  But yeah, you just put all the details in the actual cron line.

[Steve]

Thanks ober, will give it a try

[webwhy]

how does this work with a single quoted PHP string ($x)?  Your variables will not interpolate.