PDA

View Full Version : Synchronization



Peter Brooks
29-Jun-2005, 06:51 PM
Just wondering what tools people use to Synchronise a live database with a
local database. For example I have a mySQL database sitting on a Server and
need to close it down and have it copied to a local PC, then back to the
Server again. I need to automate this process from a Menu somewhere.

I have downloaded a tool called 'SQLyog' which I will test out next week
(they have a freeware version) http://www.webyog.com/

Peter Brooks

Matt Smith
29-Jun-2005, 07:01 PM
Hi Peter,

Can't you just use the standard import export tools with MySQL to do
this. I've sure I can export and import data quite easily on mine
without having to use other tools.

Matt

Peter Brooks wrote:
> Just wondering what tools people use to Synchronise a live database with a
> local database. For example I have a mySQL database sitting on a Server and
> need to close it down and have it copied to a local PC, then back to the
> Server again. I need to automate this process from a Menu somewhere.
>
> I have downloaded a tool called 'SQLyog' which I will test out next week
> (they have a freeware version) http://www.webyog.com/
>
> Peter Brooks
>
>

Peter Brooks
29-Jun-2005, 07:21 PM
I have just been looking at the webyog tool and it is brilliant.
Matt take a look. I want to make this procedure idiot proof (if possible
<g>)

merchantr
30-Jun-2005, 10:15 AM
Peter,

SQLYog is pretty good and the paid version is also quite cheap. For simple
synchronization, this is a good tool. The people doing this are very
dedicated.

You might also want to look at native synchronization support in MySQL.

--
Riaz Merchant / [ riazm@mertechdata.com ]
Mertech Data Systems, Inc. / [ www.mertechdata.com ]
ISAM to SQL Database Connectivity Drivers (ISDBC)