|
Posted by Simon on 02/28/06 17:45
>> >
>>> 1.
>>> You can always dump an OUTFILE and insert elsewere as an INFILE
>>> very fast. but both mysql users will require FILE privileges.
>>
>> hum, how do you do that?
>
> 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).
Simon
Navigation:
[Reply to this message]
|