8 reputation
3
bio website
location
age
visits member for 1 year, 2 months
seen Mar 29 '13 at 15:53

Jan
28
awarded  Scholar
Jan
28
accepted Using Mysql Replicate to replicate at a particular time
Jan
28
comment Using Mysql Replicate to replicate at a particular time
I see. I did some research and it appears as long as I don't specify to drop the existing tables in my dump, mysql will just append whatever new data to the existing table. which is ultimately what I want. I might just go ahead and utilize the dump instead. And probably use diff to compare.
Jan
28
awarded  Student
Jan
28
comment Using Mysql Replicate to replicate at a particular time
If possible, I would like to migrate only the differences in data or schema for performances purposes
Jan
28
comment Using Mysql Replicate to replicate at a particular time
So your saying if I simply just do a sqldump and send the sql file over to the production server. mysql will know how to sync up data without completely overwriting everything ?
Jan
28
awarded  Editor
Jan
28
revised Using Mysql Replicate to replicate at a particular time
added 33 characters in body
Jan
28
asked Using Mysql Replicate to replicate at a particular time