|
|
Posted by John Murtari on 04/09/07 16:30
"Joe Gazda" <email@1on1cc.com> writes:
> 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.
I assume you know the 2 Meg limit is a configurable one? If you
have a hosting provider they may raise it for you temporarily. Another
simple option is just use the mysql command line client and load the
data that way, perhaps after ftp'ing your data to the server? There
is even other option since MySQL supports ODBC access, you can download
a special driver to your PC, put the data in uSoft Access, and then store
the table to your MySQL server.
Again, not sure of your exact setup, but one of these may help.
--
John
___________________________________________________________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/
Navigation:
[Reply to this message]
|