I've got a general question about DB synchronisation.

So, I am creating a website in your area (PHP + MySQL) and I must have the ability to synchronise a minimum of the dwelling (and perhaps the contents) of these two DB when among the two is transformed (normally I'd alter the local copy).

At this time what I am doing is by using mysqldump to dump the modified tables after which import them within the remote DB or get it done manually when the changes are minimal. However find this tiresome and error-prone.

For that PHP I am presently using Quanta+ that has the handy feature of finding files which have transformed and merely upload individuals. Can there be such like for MySQL?

Otherwise how can you keep the DBs synchronised?

Thanks nico

PS: I apologize if the had been requested, I saw other questions that cope with similar subjects, but could not really locate an answer.

If you wish to continuously keep the DB instances synced - you need to use an effective master-slave configuration as the DB landscape.

Take a look at http://dev.mysql.com/doc/refman/5.5/en/replication.html for more information on replication.

If replication isn't available, you should use the binary logs (which record all operationso n the database) on a single machine and run them around the second machine without notice to sync the events.

Take a look at http://dev.mysql.com/doc/refman/5.5/en/binary-log.html

Again, you may be requiring use of certain configuration files. If the choice is irrelevant, then you will need to fall to other techniques that are a smaller amount reliable.

Try that one: MySQL Compare