Synchronising local and remote DB
- by nico
Hi everyone, I have a general question about DB synchronisation.
So, I'm developing a website locally (PHP + MySQL) and I would like to be able to synchronise at least the structure (and maybe the contents) of the two DB when one of the two is changed (normally I would change the local copy).
Right now what I'm doing is to use mysqldump to dump the modified tables and then import them in the remote DB or do it by hand if the changes are minimal. However I find this tedious and error-prone.
For the PHP I'm currently using Quanta+ which has the handy feature of finding files that have changed and just upload those. Is there something similar for MySQL?
Otherwise how do you keep your DBs synchronised?
Thanks
nico
PS: I'm sorry if this was already asked, I saw other questions that deal with similar topics, but couldn't really find an answer.