|
|
Posted by Michael Vilain on 08/17/05 23:11
In article <1124304584.029695.183220@f14g2000cwb.googlegroups.com>,
"julian_m" <julianmaisano@gmail.com> wrote:
> Excuseme if it isn't a strictly PHP related post...
> I've a local database (ms access) wich has all the stock information
> (nearly 10000 daily-changing records), and I want to keep this info on
> line as well (I've an PHP-mySql on-line catalog of the same products).
> What would be the best aproach to achieve this? I mean, this can't be
> done with a php form-window which updates the article's quantity one by
> one... (it would takes 100 years:)
>
> Any kind of tips, advices, links,... would be apreciated
>
> Note that I can't upload the access db and work directly with it,
> beacause there is no permanent internet connection where it is placed.
> The update proccess should/will be performed once a day, maybe twice...
>
> regards - julian
The only way I can think of is to perform a "export" to a Tab or comma
separated file for each table and use phpMyAdmin to read the files in as
often as you need to do this. I see no way to automate this which make
this a process highly prone to errors. I'd look at changing the Access
database (put it on a network and develop some way to update the MySQL
database) or just drop the on-line MySQL altogether and rethink what
business solution you're trying to solve with it.
--
DeeDee, don't press that button! DeeDee! NO! Dee...
Navigation:
[Reply to this message]
|