Posted by Fabian Hore on 02/28/06 18:56

>> SELECT INTO OUTFILE '/tmp/whatever' ...
>> see http://dev.mysql.com/doc/refman/4.1/en/select.html
>> - and -
>> LOAD DATA INFILE ....
>> see http://dev.mysql.com/doc/refman/4.1/en/load-data.html
>>
>>
>
> Yes, but then it will timeout after 30 sec, (I think).


trust me its fast! you can dump thousands of rows in milliseconds.
and even if it did timeout, you can extend the PHP execution time with
set_time_limit()
see http://uk2.php.net/manual/en/function.set-time-limit.php

[Back to original message]