Mysqldump --xml Option And Cron

[mriffey]

Im trying to mysqldump --xml a table out of a mysql database and while I can make it work when the script is in public_html, I cant seem to get it to work via cron.

 

I get no error messages and I get no output file. I have tried several scripts, including a barely modified version of dbsender (modifications to use --xml instead of --quick etc).

 

the mysql call from the modified dbsender goes like this:

 

passthru("mysqldump --xml -h$dbhost -u$dbuser -p$dbpass $dbname mos_core_log_searches >$filename");

 

Ive also tried it via system(). No dice, either way.

 

Ive tried outputting to /home/username/xml and making that folder 777. Didnt work. Ive tried to /home/username. Same deal.

 

Any suggestions? I know this isnt much info. Note that I have numerous successful dbsenders working that use -add-drop -quick etc (the standard dbsender dump).

 

Mark

[TCH-Bruce]

Can you provide a snippet of your code showing what you are trying to do? And your cron command line? Be sure to exclude any of your confidential info, like your cpanel name.