List:Community« Previous MessageNext Message »
From:Weydson Lima Date:April 6 2014 8:03pm
Subject:RE: Database synchronization
View as plain text  
I’m aware of replication and mysqldump but I don’t think they work well for
what I want. The tool I’m looking for would compare two databases and output a list
of changes needed to have those databases in sync. This way, one could share those changes
among other developers so they also can have their databases in sync. Note that the data
remain unchanged, allowing every developer to have its own dataset.


I found a tool called dbv ( which does what I need, but I was
looking for a native tool from MySQL that would do that.


From: shayne.alone@stripped [mailto:shayne.alone@stripped] 
Sent: Saturday, April 5, 2014 2:11 AM
To: Weydson Lima
Cc: community
Subject: Re: Database synchronization


if you are thinking about a real time (or near real time) solution, actuality
"Replication" is all.

but if you are looking for a one  time backup-restore simplest on is mysqldump


--no-data, -d           #backup schema

--no-create-info, -t   #just to backup row data as I remember

but you can find more and man pages... 

Ali R. Taleghani
+1(424) 279-4548
@linkedIn <> 


On Thu, Apr 3, 2014 at 11:29 PM, Weydson Lima <weyseal@stripped
<mailto:weyseal@stripped> > wrote:


I am looking for a tool that would allow me to synchronize a database scheme
and/or data from one server to another. I have used Navicat for these needs
before but was looking for a more affordable solution.

Thank you.


Database synchronizationWeydson Lima3 Apr
  • Re: Database synchronizationshayne.alone@gmail.com5 Apr
    • RE: Database synchronizationWeydson Lima6 Apr
RE: Database synchronizationArjen Lentz6 Apr