Sync local and Remote MySQL databases with php

[emexrevolarter]

I have a web app for managing Camping Program.

I need to allow users to register, obtain registration numbers, and upload their bio before the camp begins. They will do all these online which will be stored on the remote server hosted on the internet.

 

When the camp eventually begins, the local server will take in same data as above from those present in the camp. Changes are also made on it by the users.

 

I am confused on how to synchronise both servers to effect the latest changes on both, so that the user viewing the app locally within the camp without internet will have same data as the one who is outside the camp accessing the hosted app through the internet.

 

Thank you.

[requinix]

If there's no internet in the camp then you can't possibly keep the two versions up to date with each other...

[Psycho]

 

 

When the camp eventually begins . . . 

 

If that means that when camp begins there *should* not be any more updates to the data, then you could export that data and take it to the camp. Restore it there and work with it as needed. Then when camp is complete, export it there and restore it to the web server. Note: Even thought he records on the internet server would be overwritten, a change should probably be made to prevent edits anyway.

 

That a 'simple' explanation. But, if the two system have a different data schema or purpose you may have to build a process to export/import the data both ways that takes into account those schemas and business rules. Just not enough information to really provide clear advice.