Posted by Fabian Hore on 02/28/06 17:38

"Simon" <spambucket@example.com> wrote in message
news:46ivd4FbbpndU1@individual.net...
> >
>> 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

[Back to original message]