Posted by Ian Pawson on 09/23/06 17:01

halbenca@gmail.com wrote:
> Dano wrote:
>> Pretty easy to do with CSV and PHPMyAdmin.
>>
>> If your file is in CSV, just go to the "Import" tab in PHPMyAdmin. It's
>> pretty standard across different PHPMyAdmin versions.
>>
>> There, just browse for the file location, check the appropriate boxes,
>> and click "Go." Depending on your connection speed, it could take a
>> while. I used to load an 84-column, 12,000-row CSV file over a DSL
>> connection, and it would usually take 30-40 minutes, on average.
>>
>> Hope that helps!
>>
>> halbenca@gmail.com wrote:
>>> I have a CSV file with 5 columns and about 20000 lines. Is there a
>>> simple utility out there that will convert this file into a conforming
>>> text file I can then proceed to import into my database via Web
>>> interface phpMyAdmin? These are the confines I have to work within as
>>> I have to import it from the Web access of phpMyAdmin, any solutions or
>>> ideas? BEST REGARDS, Danny
>
> Thank you! I do get 300 second timeouts. I read somewhere that #
> could be extended --- but this is a public Web server. It sounds like
> I need to split this down to very small parts or find some way to
> transform the excel lines into proper mysql queries. This seems to be
> a grey area.... if I had a direct non-web connection into the MySQL
> database, there are a ton of apps to syphon these CSV's up :) Any
> other ideas out there?
>
'load data infile xxx' should do what you want if you have shell access.

[Back to original message]