Posted by Joe G. on 04/11/07 18:07

I found the most helpful information in a
post from "Software Engineer". She directed me to a web site that offers
"detailed" solutions to PHP programming issues.

http://tutorial.fyicenter.com/824/MySQL/PHP/Tutorials/Importing_CSV_data_into_MySQL_with_a_PHP.html

With a few modifications, I was able to use the code to load my data on to
the web MySQL server. The code works and there are detailed instructions
that I was able to paste into the code as comments (as all good programmers
should).


"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1176216021.349176.270290@n76g2000hsh.googlegroups.com...
> 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]