Steve, Hopefully I am correctly interpreting what you want to do.
While I don't have anything of this kind in operation, I did come close to implementing it as a solution to a problem that I eventually found another way around. My proposed solution was to have a script set up on the web server that, when browsed to, would output a list of records from a MySQL database. This would be a 'hidden' script not linked to by any other pages so that a casual browser of the site would not accidentally come across it. A script on the internal intranet could then be cron'd to browse to that page, slurp up the output of the remote page and store it in MySQL locally. The local script could be triggered manually each time an update is done, or there could be, perhaps, a database entry on the remote server that is set to '1' whenever data is changed. The '0'/'1' is output first and the local script could then test that first and either proceed with data capture or break the connection if nothing has changed. Hope this is useful! Peter Monk IT Department United Water International Adelaide, Australia -----Original Message----- From: Steve Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 March 2003 5:59 PM To: MySQL General Mailing list Cc: PHP General Subject: Passing data between the web to an Intranet Has anyone ever simply tried to pass information direct from the web into a secure Intranet mysql DB rather than to a web DB? I am thinking down one of three lines. 1) I use PHP to send an email with the data in it and update our internal DB manually (the worst case) 2) I use PHP which takes data, sends it as an email, puts it into a form which then automatically updates our internal network (interesting idea but I have no clue if it can be done ;o) 3) I use some sort of synchronisation so every time the web DB is updated our internal one is also updated (ideal). I would welcome any other ideas or solutions. Does mysql have any replication or synchronisation functions? I am told Oracle has but haven't seen this or heard of this with mysql. Cheers, Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
