Jump to content
emexrevolarter

Sync local and Remote MySQL databases with php

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

 

 

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.