Re: How to sync data between two DBs

2012-10-17 Thread m1chael
http://dev.mysql.com/doc/refman/5.0/en/replication.html does this work? On Wed, Oct 17, 2012 at 8:00 AM, Alexander Todorov wrote: > On Tuesday, October 16, 2012 6:54:52 PM UTC+3, Nikolas Stevenson-Molnar > wrote: >> >> Do you already have data on the new database which you need to preserve? >> I

Re: How to sync data between two DBs

2012-10-17 Thread Alexander Todorov
On Tuesday, October 16, 2012 6:54:52 PM UTC+3, Nikolas Stevenson-Molnar wrote: > > Do you already have data on the new database which you need to preserve? > If not, would a simple SQL dump work? > > It will work but this is not the best solution I can think of (I'm not MySQL guru). The bigg

Re: How to sync data between two DBs

2012-10-16 Thread Nikolas Stevenson-Molnar
Do you already have data on the new database which you need to preserve? If not, would a simple SQL dump work? _Nik On 10/16/2012 2:15 AM, Alexander Todorov wrote: > Hello guys, > I'm in the process of migrating from self managed MySQL DB to Xeround > cloud database and would like to synchronize

How to sync data between two DBs

2012-10-16 Thread Alexander Todorov
Hello guys, I'm in the process of migrating from self managed MySQL DB to Xeround cloud database and would like to synchronize my objects. The sync is only in one direction: OLD DB -> NEW DB, then switch to the new DB entirely. South mentions data migrations which are in fact data transformatio