Re: [PHP] mysqldump problem from PHP

2006-10-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100: It appears that it could be because the user that runs the scripts is not allowed to. When I run them on the commandline, I run them as the root user. that's very simple to check (man su) yes I know of CRONtabs but wont this still

Re: [PHP] mysqldump problem from PHP

2006-10-24 Thread Chris
Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100: It appears that it could be because the user that runs the scripts is not allowed to. When I run them on the commandline, I run them as the root user. that's very simple to check (man su) yes I know of CRONtabs but

Re: [PHP] mysqldump problem from PHP

2006-10-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-10-24 17:58:45 +1000: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100: It looks to me as if you are trying to use web scripting (PHP) to do the sysadmin on your server, for which other methods are more suitable. Those would be? What

[PHP] mysqldump problem from PHP

2006-10-23 Thread Angelo Zanetti
hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same command (with appropriate values) in the command line it creates the dump file. What could be the reason for

Re: [PHP] mysqldump problem from PHP

2006-10-23 Thread clive
write rights for apache/php user to the $backup_path? also is apache/php user allowed to run mysqldump? hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same

Re: [PHP] mysqldump problem from PHP

2006-10-23 Thread Angelo Zanetti
Angelo Zanetti wrote: hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same command (with appropriate values) in the command line it creates the dump file.

RE: [PHP] mysqldump problem from PHP

2006-10-23 Thread Edward Kay
hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same command (with appropriate values) in the command line it creates the dump file. What could be the

Re: [PHP] mysqldump problem from PHP

2006-10-23 Thread Brad Bonkoski
Edward Kay wrote: hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same command (with appropriate values) in the command line it creates the dump file. What could be

Re: [PHP] mysqldump problem from PHP

2006-10-23 Thread Angelo Zanetti
Edward Kay wrote: Angelo Zanetti wrote: hi all, Im doing the following dump through PHP: $output = shell_exec('mysqldump '. $db_database .' '. $backup_path.$filename); It doesnt seem to work but when I run the exact same command (with appropriate values) in the command line it

Re: [PHP] mysqldump problem from PHP

2006-10-23 Thread David Giragosian
Angelo, as Brad says, you can pass user and password args to mysqldump from an include file. I run a php backup script via cron every night, then tar and compress and store in various dirs out of the web tree. I have the script if you'd like. It came from someone on the php-db list years ago,