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.
Samritha -3
Newbie Poster
Recommended Answers
Jump to PostYou may be looking at replication: http://dev.mysql.com/doc/refman/5.0/en/replication.html
Is there any reason why you need to do this? Can't you update the remote DB direcctly?
All 3 Replies
diafol
You may be looking at replication: http://dev.mysql.com/doc/refman/5.0/en/replication.html
Is there any reason why you need to do this? Can't you update the remote DB direcctly?
Samritha -3
Newbie Poster
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.
diafol
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?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.