Skip to main content
Database Administrators

Return to Question

Question Protected by CommunityBot
Capitalisation, a few articles.
Source Link
Michael Green
Michael Green
  • 25.1k
  • 13
  • 53
  • 98

myMy plan is to store data in my local mysqlMySQL database and after a time intervelinterval it will update my live mysqlMySQL database remotely. Is it possible? i'm

I'm planing a inventory management script in php mysqlPHP MySQL. but the The real problem is in our country net connection drops suddenly dropped. So iI want to first it will updatewrite to the local mysqlMySQL database and then it will update the real server. so that in In any situation like internet connection dropped the script will work locally to gather data and retrieve data. whenWhen the internet connection camecomes back it will update the data to the real server. iI want to fightprotect against internet connection failures. nothing

Nothing will update the real server in the mean time. cause because the users are only in the office where the internet connection will drop. no No one from the outside will able to update the database. onlyOnly the information can be retrieved from the live server to the shop's owner.

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.

My plan is to store data in my local MySQL database and after a time interval it will update my live MySQL database remotely. Is it possible?

I'm planing a inventory management script in PHP MySQL. The real problem is in our country net connection drops suddenly. So I want to first write to the local MySQL database and then it will update the real server. In any situation like internet connection dropped the script will work locally to gather data and retrieve data. When the internet connection comes back it will update the data to the real server. I want to protect against internet connection failures.

Nothing will update the real server in the mean time because the users are only in the office where the internet connection will drop. No one from the outside will able to update the database. Only the information can be retrieved from the live server to the shop's owner.

Source Link
Shobdo
Shobdo
  • 21
  • 1
  • 1
  • 2

how to sync local mysql database and live server database?

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.