Page 1 of 1

Importing huge CSV files into mysql tables

Posted: Tue Aug 03, 2004 10:07 am
by steedvlx
I've searched for 'importing' and 'importing text', and I cannot find a post specific to 'HOW' to import CSV text into MySQL.

Can anyone point me to a definitive resource? :?:

Also, and this may be a problem, the CSV files (Unicoded) contain japanese text which must remain intact. These files are HUGE (27 files at least 1MB each) so there is no way I can enter the data. This is evolving into a serious problem.

Any help at all is deeply appreciated. :wink:

Posted: Tue Aug 03, 2004 10:11 am
by AGISB
Phpmyadmin can insert csv files as big as 2048 KB

Posted: Tue Aug 03, 2004 12:49 pm
by steedvlx
OK, I found that function of phpmyadmin. I swear I have never seen that link before. Perhaps because it's buried at the bottom of the page and I just never scrolled down there.

Anyway, I did find it in the documentation after I read your post, and it works great. Only that "DATA LOCAL" option is not very friendly. It gives a 'command not allowed in MySQL version" error. :?: But, the "DATA" option works beautifully!

Problem solved.

THANX!