Page 1 of 1

tool to update/synchronize local and remote DB

PostPosted: 26. July 2006 12:01
by hugohiram
Hello

Is there a tool to synchronize data and/or update structure of my remote DB, with the one of my localhost.

explain myself: I am changing the structure of my DB on localhost and want to apply those changes to the DB on a remote server, can it be done? is there a tool to do it? (to work with XAMPP/PHPmyAdmin or standalone).

Thanks and regards.

PostPosted: 26. July 2006 12:42
by Izzy
Is this just a one off sync after you have restructered or is this an ongoing sync when data changes on the remote or on the local database?

If its just a one off then this can be carried out after you have restructured your local database by using phpMyAdmin in XAMPP, dumping (Exporting) your database to an sql file then Exporting that file to say your desktop. Then you would use phpMyAdmin on the remote server to Import the sql dump from your desktop into your remote database. Assuming you are using a control panel with phpMyAdmin incorporated like cPanel or Plesk etc.

The other scenario of continuous sync of the 2 databases is more complex and would require a third party piece of software. Of which I am not familiar but after doing a Google I spotted some results that may do the job, I would be surprised if there was not an open source project somewhere on the web that would also do the job.