title: to sync local database and web server database in MySql
body: <p>I am using PHP and Mysql for developing an application. we have two copies of database, one at local server(i.e our end) and one at web server. we want to sync both the database so that if any change made in local database should also reflect on the webserver database. is that possible??
  Currently we are using PHP scripts to do so..which is taking too much of time and aswell as not reliable. 
  What can be done so that MySQL will internally fire the whole update and logic??</p>
  
  <p>NOTE:- Our Local server run's on Windows, and web server is Unix based, and we are not using command line to access both the machines, actually at both the sides we use PHP application to update and maintain data(i.e to add new or update data)</p>