How to import txtfiles into mysql database

Hi all:

How to import txtfiles into mysql databases. I know the command.
But i do not know where I should put this file.
Anyone gives me a hint

Cheers
Andy

A good example is to take your web server's raw access log and import it into mysql with a command such as this:

C:\temp\>mysqlimport --local -d -r -h <host>
-u <user> -p<password> --fields-terminated-by="-" <dbname> <textfile>


This assumes the textfile is in the c:\temp directory which is your current working directory.

It is very imporant you use the command line switch --local as if you do not, the mysql server will attempt to look on it's hard drive for the textfile you specified. Most likely it will not find it.

You can also use a query with

LOAD DATA INFILE 'file.txt' INTO TABLE table (fields);

ok, so how would i do this in OS X? what's the default path?

There is no default path... you need to cd to whatever directory you have the file in or reference the full path to the file you are importing.

yeah, well, i tried that but i must have missed the path. anyway, i just got a GUI to mysql so i dont need it right now. i'm sure in the future, importing a text file will be quicker than typing it all in. thanks for replying, though, i really appreciate it.