I have 4 local database and 1 server. How to synchronize that 4 local database to server automatically in perticular time interval.

Is there any code please update me..

Advance thanks for any suggessions/code.

2 Years
Discussion Span
Last Post by diafol

I have web application running on 4 client systems (users with login -password )and administered at one server (apache based server ,XAMP), when server is up web application will run normally . If for any reason (no internet connectivity etc) the client is unable to access the network , client should be able to use applcation without loss of data , so when the network is up , no loss synchronization should happen.

Edited by Samritha


Depends on how complicated the update is. You can try INSERT IGNORE. Are you updating more than one table for each DB? Perhaps if you show the schemas. Are the PKs and FKs the same in remote and local versions?

Edited by diafol

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.