RE: Query to emulate what mysqldump does

2003-12-04 Thread Wouter van Vliet
> Which will put the file on the same server 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

RE: Query to emulate what mysqldump does

2003-12-03 Thread Andrew Braithwaite
al 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: > [snip] > I thought about that Jay, but the mysql server is not o

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 last

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 availa

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

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

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:http:/