import .txt to mysql

Question

I have a 20000 by 1000 table in .txt file. Each column is separated by a tab. I need to import this huge table (2GB) to mysql. My sql table should have 1000 attributes and 20000 records. How can I do that ? Can I import a tab delimited file to sql?

Answer 1

You can load this data with Data Import tool (CSV or TEXT format + command line) in dbForge Studio for MySQL. The CSV format in express edition is fully supported.

Answer 2

You can use the mysqlimport program to import data from your text file which:

Provides a command-line interface to the LOAD DATA INFILE SQL statement

Here is a link to four examples of mysqlimport usage.