Posted by halbenca on 09/23/06 16:53

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?

[Back to original message]