title: how to sync two mysql databases, when both of them have new entries
body: <p>I have mysql database installed on localhost for our local area network (a php application) and another copy of the same application and database for remote users is install on my online server.</p>
  
  <p>There are several entries which have primary keys problem:  <strong>scenario</strong> if a user enters new record with primary key #4 on online server and on local server there is already a different record with primary key #4, so the application will run into problems. </p>
  
  <p><strong>Note: I cannot put my local sever online due to limited bandwidth. So its out of question that I should use online server both for local and remote</strong> </p>
  
  <p>So can anyone tell me that how to sync both of my databases without getting into problem? </p>