[LUG] loading a txt file into a mysql database

[Luke Hinds <luke@xxxxxxxxxxxxxxxxxxxxxxx>]

Hi All,

Just trying to teach myself 'mysql' by reading through the
documentation. What i wish to do is to load some data from a txt file
into a table.

In the doc it suggests:

load data local infile "file.txt" into table tablename;

Anyone know what syntax to use when you need to specify a directory
path? I just figured out it uses the users home directory (or is it the
pwd that the server was called from?) 

Need to know what to do if the file resides elsewhere, like another host
even (local is enough for now).


Thanks in advance,
Luke

Attachment: signature.asc
Description: This is a digitally signed message part