tim's journal

Load data infile

I recently tried to load a csv file I generated using C++ via 'cout', commas, and 'endl' into MySQL. Man, I wasted so much time. Here's what was wrong. First, I needed to use LOAD DATA INFILE instead of LOAD DATA LOCAL INFILE. The default is DATA LOCAL. Second, because my file was very large (>15MB), I would click on send and it would put me back on the same page because my php.ini was set for a maximum upload of 2MB. It's hard to diagnose what the problem is if there is no error messaging. Finally the 'endl' corresponds to '\n', rather than '\r\n'.