my plan is to store data in my local mysql database and after a time intervel it will update my live mysql database remotely. Is it possible?
i'm planing a inventory management script in php mysql. but the real problem is in our country net connection suddenly dropped. So i want first it will update local mysql database then it will update real server. so that in any situation like internet connection dropped the script will work locally to gather data and retrieve data. when the internet connection came back it will update the data to the real server. i want to fight against internet connection.
nothing will update real server in the mean time. cause the users are only in the office where the internet connection will drop. no one from the outside will able to update database. only the information can be retrieved from the live server to the shop's owner.