On Thursday, May 9, 2002, at 07:53 PM, nellA hciR wrote: > starting w 3.23.49 of mySQL, how do i via perl/DBI make a dB connection > with load data infile enabled
There's nothing special about the "load data infile" statement - you prepare and execute it exactly as you would any other SQL statement. Note, however, that MySQL permissions are a bit tricky on this point. Granting a user access with "grant all privileges" does *not* give that user the "file" privilege needed to read external files. An addtional "grant file on * to..." is needed to do that. Also, the "file" privilege is global; that is, it's applied on a per-user basis, not on a per-database or per-table basis. The normal access restrictions still apply, however - a user who has been granted "file" privilege is only able to load a file into a database or table to which (s?)he has write access. sherm-- Never put off until tomorrow what you can do today. There might be a law against it by that time.
