The feature you are looking for is replication, I have used that in MySQL many times to do the exact thing you are talking about, works great. Example - http:/

The feature you are looking for is replication, I have used that in MySQL many times to do the exact thing you are talking about, works great. Example - http://blog.onetechnical.com/2012/05/29/quick-mysql-replication-to-move-a-database/ http://blog.onetechnical.com/2012/05/29/quick-mysql-replicat...