[UPHPU] FW: Importing large csv file into MySQL

[TJ Hunter]

I would guess that phpMyAdmin runs out of allowed execution time. What kind of 
error do you get? At any rate, I would do what the others suggest and import it 
from the command line.

Ashley Oviatt wrote:
> I sent this accidentally to just Mac, and now here it is again for all of
> you:
> 
> 
>>Hello all,
>>
>>I have a large csv file (1 million records) that I need to 
>>import into a mysql database. I have tried phpMyAdmin's 
>>import utility but it always errors out after a couple 
>>minutes of processing. It works if I take 10,000 records out 
>>of the csv as a test import, so I know my syntax is correct. 
>>
>>I'm guessing the csv is corrupted down the line somewhere, so 
>>I tried to import it into MS Access. Low and behold it 
>>worked. So now I have the csv DB in Access and can connect to 
>>the MySQL DB via an odbc connection.
>>
>>So I just need to know how to copy the csv table into the 
>>mysql table. It will only let me copy about 30,000 records at 
>>once without saying memory is all used up.
> 
> 
> Mac suggested that I import it directly from the command line mysql. Do any
> of you have the syntax for that?
> 
> Ashley
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: list-unsubscribe at uphpu.org
> For additional commands, e-mail: list-help at uphpu.org
> 
> 
> 
>