RE: Query to emulate what mysqldump does

2003-12-04 Thread Wouter van Vliet
as the MySQL client is running on... Cheers, Andrew -Original Message- From: Matt Babineau [mailto:[EMAIL PROTECTED] Sent: Wednesday 03 December 2003 17:37 To: [EMAIL PROTECTED] Subject: RE: Query to emulate what mysqldump does On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote

Query to emulate what mysqldump does

2003-12-03 Thread Matt Babineau
Hey All- Are there any query equivalencies to mysqldump? I am looking for a way to get a complete database dump via php and I don't have access to the system CLI to run mysql dump. TIA- Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Query to emulate what mysqldump does

2003-12-03 Thread Jay Blanchard
[snip] Are there any query equivalencies to mysqldump? I am looking for a way to get a complete database dump via php and I don't have access to the system CLI to run mysql dump. [/snip] Run mysqldupmp in a php file using exec...see http://www.php.net/exec http://www.mysql.com/mysqldump looks

RE: Query to emulate what mysqldump does

2003-12-03 Thread Matt Babineau
On Wed, 2003-12-03 at 15:13, Jay Blanchard wrote: [snip] Are there any query equivalencies to mysqldump? I am looking for a way to get a complete database dump via php and I don't have access to the system CLI to run mysql dump. [/snip] Run mysqldupmp in a php file using exec...see

RE: Query to emulate what mysqldump does

2003-12-03 Thread Jay Blanchard
[snip] I thought about that Jay, but the mysql server is not on the webserver machine. Any other suggestions? [/snip] phpmyadmin will allow you to connect to the remote MySQL server and do dumps -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Query to emulate what mysqldump does

2003-12-03 Thread Matt Babineau
On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote: [snip] I thought about that Jay, but the mysql server is not on the webserver machine. Any other suggestions? [/snip] phpmyadmin will allow you to connect to the remote MySQL server and do dumps What if I don't have phpmyadmin available?

RE: Query to emulate what mysqldump does

2003-12-03 Thread Jay Blanchard
[snip] What if I don't have phpmyadmin available? :) What I am trying to do, it setup a simple script to pull down essentially a backup of their database and write it to a file on my development machine so when they mess up their data (..and I said WHEN) I can be a hero and revert them to the

RE: Query to emulate what mysqldump does

2003-12-03 Thread Andrew Braithwaite
: Matt Babineau [mailto:[EMAIL PROTECTED] Sent: Wednesday 03 December 2003 17:37 To: [EMAIL PROTECTED] Subject: RE: Query to emulate what mysqldump does On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote: [snip] I thought about that Jay, but the mysql server is not on the webserver machine. Any