HELP: best way to TEXT dump a MySQL table to a local file...
| From: | Leo G. Divinagracia III | Date: | Thu, 10 Jun 2004 09:39:25 +0000 |
| Subject: | HELP: best way to TEXT dump a MySQL table to a local file... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34700@lists.php.net to get a copy of this message | ||
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...