Importing large CSV into mysql

[dougmcc1]

Whats the best way to import large CSV text files (50MB or more) into a mysql table?

Thanks.

[SFDonovan]

Bigdump

http://www.ozerov.de/bigdump.php

[dougmcc1]

BigDump is used for importing files containing SQL queries. I need to import CSV files containing text values separated by commas.

[NogDog]

Have you looked at LOAD DATA INFILE?

[djjjozsi]

Or use phpmyadmin, it has a large csv OR dump handler.