Re: [PHP-DB] mysqldump via php

2006-06-30 Thread Jeffrey
Thanks all for the help! exec() seems the best option. Jeffrey Miguel Guirao wrote: You could use exec() within PHP! -Original Message- From: Adrian Bruce [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Junio de 2006 06:31 a.m. To: Jeffrey Cc: PHP DB Subject: Re: [PHP-DB] mysqldump

[PHP-DB] mysqldump via php

2006-06-29 Thread Jeffrey
I would like to do a backup of an entire MySQL database via php. My thought was to use mysqldump, write the data to a file and save the file. However... $query=mysqldump $dbase; $result=mysql_query($query) or die(mysql_error()); ...immediately results in an error in your SQL

Re: [PHP-DB] mysqldump via php

2006-06-29 Thread Adrian Bruce
mysqldump is a .exe, and therefore it will not work within mysql_query(); You may be able to use mysqldump from PHP using the system function check out http://uk.php.net/system Ade Jeffrey wrote: I would like to do a backup of an entire MySQL database via php. My thought was to use

RE: [PHP-DB] mysqldump via php

2006-06-29 Thread Bastien Koert
why no use phpmyadmin to admin the db? Bastien From: Jeffrey [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Subject: [PHP-DB] mysqldump via php Date: Thu, 29 Jun 2006 12:38:51 +0200 I would like to do a backup of an entire MySQL database via php. My thought was to use mysqldump, write

RE: [PHP-DB] mysqldump via php

2006-06-29 Thread Miguel Guirao
You could use exec() within PHP! -Original Message- From: Adrian Bruce [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Junio de 2006 06:31 a.m. To: Jeffrey Cc: PHP DB Subject: Re: [PHP-DB] mysqldump via php mysqldump is a .exe, and therefore it will not work within mysql_query(); You