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]> Sent: Thursday, June 10, 2004 11:39 AM Subject: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file... > project i'm working with, his host died or something. > > but, the phpMyadmin (on that host) can NOT do a backup of 200mb table > without running out of memory or something weird. > > so what is the best way to text dump the table? > > i thought i would (pseudo-code): > > > open DB > do while not EOF > grab 1000 rows from DB > write to a file on host www path > filename = filename000 + 1 > until EOF > > user would then FTP down the files to his machine. > > > but i figured i could use the HEADER to send it to the user. > > i grabbed this from the HEADER help section: > > > <?php > $output_file = 'something.txt'; > $content_len = 666; > > @ob_end_clean(); > @ini_set('zlib.output_compression', 'Off'); > header('Pragma: public'); > header('Content-Transfer-Encoding: none'); > header('Content-Type: application/octetstream; name="' . $output_file . > '"'); > header('Content-Disposition: inline; filename="' . $output_file . '"'); > header("Content-length: $content_len"); > > >? > > is that the best way to send the txt file to the user? > > thanks... > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php