Load a large text file into MySQL?

[frigidman]

Whats the command/tool for linux mysql to take a text file (1k-4gig) that has setup data and load it into a mysql table.

ex:
Text file names.txt has a name per line, seperated by newline etc, and it needs to be loaded into a table with only one cell. One name line per row.

Whats that command/tool to do this? I seem to be glazing over it or something, as I havn't found it yet.

Any help, or pointed direction to a doc page about the command/tool would be helpful.

Thanks.

[djangodane]

You should be able to use:

LOAD DATA INFILE \"data.txt\" INTO TABLE table;

Do a lookup to make sure your .txt file is formatted properly.

[techek]

Have you had a look at mysqladmin or perhaps even mysqlimport?

http://www.mysql.com/doc/m/y/mysqlimport.html might help you get started.

/Techek