By drfuzetto on
I have separate database for development and my live site and want to know how to keep the databases in sync without rebuilding the whole database.
What are the tables that should update? Should the cache tables be updated?
How do most people approach this?
Any suggestions are appreciated.
Thanks.
Comments
Replication?
MySQL has replication controls - if you can set it up correctly, that would probably be the easiest low-maintenance solution. Instructions on master>slave replication at http://www.howtoforge.com/mysql_database_replication