RE: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread tech.evisionmgr.com
I agree to use mysqldump to export the data to a text file. If you want to save time, you could write a php script to ftp the text file from the dead host to the new host. Then load the data back into the new database. I guess if you have broadband connection, then you might not be saving to

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Leo G. Divinagracia III
would be nice... but since this is a hosted site and no shell access or anything, i thought i would write the php script to dump the file to my web path... Ignatius Reilly wrote: Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE "c:/..." th

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Ignatius Reilly
Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE "c:/..." this (AFAI) does not cause memory issues Ignatius _ - Original Message - From: "Leo G. Divinagracia III" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S