title: sync databases Mysql SQLite
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6511402/how-to-sync-sqlite-database-on-android-phone-with-mysql-database-on-server">how to sync SQLite database on android phone with MySQL database on server?</a>  </p>
  </blockquote>
  
  
  
  <p>I am wondering what is the best approach to updating a database on an Application.</p>
  
  <p>We have a mysql database that handles everything on the main server, but I want to replicate this on my app. I would like to copy the database (mysql) on the android device so that both stay up-to-date. this would not have to happen in real time, but could be scheduled once every week, or when a change is made to the SQL database.</p>
  
  <p>How would i do such a thing?</p>
  
  <p>As in should I send this out as an update to the application and create the changed database, or should I use some way of getting the database to be changed on the server, and the SQLite data base be copied across to the android app.</p>
  
  <p>Or ... is there some nice clever way of doing this??</p>
  
  <p>Thanks
  Pat</p>