Forum Moderators: open

Message Too Old, No Replies

Best format for importing large text files into mysql

Is the best format CSV, XML, or something else?

         

dougmcc1

2:56 am on Oct 6, 2008 (gmt 0)

10+ Year Member



Is there anyone who's signed up to the CJ product catalog datafeed who gets text files up to 600MB to 1.5GB?

How do you get these imported into your mysql database? What's the best format to recieve these in, CSV, XML, or what?

Thanks.

imstillatwork

4:24 am on Oct 25, 2008 (gmt 0)

10+ Year Member



most mysql management apps like CSV. I use heidiSQL and it handles very large csv's very well.