Re: PHP and mySQL startup

[Douglas Handy <dhandy@xxxxxxxxx>]

Jeff,

A nightly update will be sufficient.  I already have mySQL running on the i.
> My intention is to:
>
> 1) Have mySQL on the i use the DB2 storage engine.
> 2) Each night, an RPG program refreshes the contents of a mySQL table on
> the
> i.
> 3) After that table is updated, FTP it to the website.


I am not sure that you want to just FTP a table from your MySQL database to
one on the other website.  I assume there could be file contention issues if
a user is active on the website, and I don't know how all the opens / closes
work with MySQL.

Instead, what I've done in the past is just create a delimted text file in
the IFS (from my RPG code) and FTP it to the server.  Then I call a PHP page
I place on the server which causes it to open the text file and use SQL
statements to update the MySQL copy of the data (all done via PHP
scripting).  That way I can perform an update without any concerns over
concurrency with other users.

But maybe I am being overly cautious and you can just replace a table in
your remote database.  I don't pretend to be a MySQL expert.

Doug