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:/..."

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





-- Leo G. Divinagracia III [EMAIL PROTECTED]

zzzzz

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to