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" <ldivinag@xxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Thursday, June 10, 2004 11:39 AM
Subject: 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
