CSV data to MySQL table (MyPHPAdmin)

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

Re: CSV data to MySQL table (MyPHPAdmin)

On 9 Apr, 16:09, "Joe Gazda" 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

Re: CSV data to MySQL table (MyPHPAdmin)

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/Import ing_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" wrote in message
news:1176216021.349176.270290@n76g2000hsh.googlegroups.com.. .
> On 9 Apr, 16:09, "Joe Gazda" 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
>