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 b

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 w

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 th

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, an

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 crea

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 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

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. Wha

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 comm