Importing huge CSV files into mysql tables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
steedvlx
Forum Contributor
Posts: 122
Joined: Wed Jun 11, 2003 10:54 pm
Location: Osaka, Japan

Importing huge CSV files into mysql tables

Post 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:
AGISB
Forum Contributor
Posts: 422
Joined: Fri Jul 09, 2004 1:23 am

Post by AGISB »

Phpmyadmin can insert csv files as big as 2048 KB
User avatar
steedvlx
Forum Contributor
Posts: 122
Joined: Wed Jun 11, 2003 10:54 pm
Location: Osaka, Japan

Post 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!
Post Reply