Posted by Captain Paralytic on 04/10/07 14:40

On 9 Apr, 16:09, "Joe Gazda" <e...@1on1cc.com> wrote:
> I have a large data file (9 Meg) that I want to upload to a MySQL table. It
> contains the key, model year, maker, model, and engine type for about the
> past 50 years. The limitation of my MyPHPAdmin transfer is 2 Meg. So, I;m
> looking for a simple PHP script to take 7 fiedls of data and transfer it to
> an already existing (blank) MySQL table. I've done an Internet search and
> the "free" code that I have found either lacks enough comments to work with
> and just doesn't work at all.
>
> I've seen programs that can be ourchased like from Sobolsoft, but don't have
> any experience with the company. If it will work for this application, then
> I'm willing to purchase it. If someone can lead me to a "functional",
> commented script, al the better. But, if any one has successfully used any
> commerical software and can lead me in the right direction, your input would
> be greatly appreciated.
>
> Joe G.
> Dearborn, MI

Do it using mysqlimport http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

[Back to original message]