Hi there,
I'm trying to synchronize two different databases, one the client's db in an offline environment (Win98,PHP4,MySQL,Apache), the other one the remote MySQL db on the web, hosted with one of those mass hosters where one can't get to the db directory.
The problem seems trivial: I store all sql statements performed offline into a table, then connect to the net any time later, and have a button that says 'update'. That one is starting my (local) script, reading the the sql lines from the offline db, and then perform all statements on the online remote db. At least, I try to... because the script (remember: local!) can't connect to the remote db on the internet, despite using username, passwd etc., as required in 'mysql_connect'. The message is something like 'can't connect to host db.server.com'. Strange enough, I can connect to the remote db from any other online domain I run... only the local script seems to have those problems. Where is the difference here? The virtual IP of my dial-in-provider? Guess it's never that easy, huh? ;-)
Hope anyone can help. How would you synchronize 2 dbs???
Thanks, Joerg
I'm trying to synchronize two different databases, one the client's db in an offline environment (Win98,PHP4,MySQL,Apache), the other one the remote MySQL db on the web, hosted with one of those mass hosters where one can't get to the db directory.
The problem seems trivial: I store all sql statements performed offline into a table, then connect to the net any time later, and have a button that says 'update'. That one is starting my (local) script, reading the the sql lines from the offline db, and then perform all statements on the online remote db. At least, I try to... because the script (remember: local!) can't connect to the remote db on the internet, despite using username, passwd etc., as required in 'mysql_connect'. The message is something like 'can't connect to host db.server.com'. Strange enough, I can connect to the remote db from any other online domain I run... only the local script seems to have those problems. Where is the difference here? The virtual IP of my dial-in-provider? Guess it's never that easy, huh? ;-)
Hope anyone can help. How would you synchronize 2 dbs???
Thanks, Joerg