On Thu, Aug 16, 2001 at 03:01:20AM -0700, Jose de Leon wrote:
> This is what I did:
>
> load data local infile '/var/lib/mysql/mysql/user.MYD' into table data;
^^^^^
>
> At first I did it without the 'local' keyword. But with 'local' keyword it works.
>
When you ad the local keyword the client not the server reads the
file, and reads it with the filesystem permishions that it was run under. If
you login as an ordinary user instead of the superuser, the percieved problem
goes away.
-----
DISCLAIMER: Anyone sending me unsolicited commercial electronic mail
automatically agrees to be held to the following legal terms:
US Code Title 47, Sec.227(a)(2)(B), a computer/modem/printer meets the
definition of a telephone fax machine. By Sec.227(b)(1)(C), it is
unlawful to send any unsolicited advertisement to such equipment. By
Sec.227(b)(3)(C), a violation of the aforementioned Section is punishable
by action to recover actual monetary loss, or $500, whichever is greater,
for each violation.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
