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

• Next in forum: Re: my Script Dies during fgetcsv
• Prev in forum: Re: Weird: Slashes getting added
• Thread view: Re: Any GUI to import/export MySQL?

[Reply to this message]