mySQL Local and online data synchronization or replication

01 Feb 2016, 17:46

#1

New Zenner

Join Date:: Dec 2010
Posts:: 32
Plugin Contributions:: 0

mySQL Local and online data synchronization or replication

Hi,
Did any body have knowledge to do mySQL Local and online data synchronization or replication.
I tried workbench but unable to do.
I am unable to make any change in my.ini of online database.

Regards

01 Feb 2016, 18:04

#2

mc12345678

Totally Zenned

Join Date:: Jul 2012
Posts:: 16,907
Plugin Contributions:: 1

Re: mySQL Local and online data synchronization or replication

mandeepmavi:
Hi,
Did any body have knowledge to do mySQL Local and online data synchronization or replication.
I tried workbench but unable to do.
I am unable to make any change in my.ini of online database.

Regards

To focus the assistance needed to resolve your issue, it would be benefical to identify more about what is meant by "unable to do" and what assistance is needed. There are plenty that have been able to properly setup their host account and local (not on network) account to communicate/modify the database data. While each such setup comes with it's own issues, knowing more about the situation only helps and it is always best to provide as much as possible up front rather than having to be asked for it.

01 Feb 2016, 18:16

#3

mandeepmavi

New Zenner

Join Date:: Dec 2010
Posts:: 32
Plugin Contributions:: 0

Re: mySQL Local and online data synchronization or replication

I tried mySQL workbench to do synchronization.

01 Feb 2016, 21:17

#4

torvista

Totally Zenned

Join Date:: Aug 2007
Posts:: 2,850
Plugin Contributions:: 3

Re: mySQL Local and online data synchronization or replication

I tried mySQL workbench to do synchronization.

Why do you want to synchronize them...as opposed to downloading a copy of the db and importing it to the local copy when you need to test db-related things?

01 Feb 2016, 22:11

#5

mandeepmavi

New Zenner

Join Date:: Dec 2010
Posts:: 32
Plugin Contributions:: 0

Re: mySQL Local and online data synchronization or replication

I have to database. local and online. I will use local database with POS. So want to replicate or synchronize local with online database. to keep online database updated.

02 Feb 2016, 08:40

#6

rodg

Deceased

Join Date:: Jan 2007
Posts:: 6,263
Plugin Contributions:: 3

Re: mySQL Local and online data synchronization or replication

mandeepmavi:
I have to database. local and online. I will use local database with POS. So want to replicate or synchronize local with online database. to keep online database updated.

Not easy.

See https://www.zen-cart.com/showthread.php?219432 - the initial request (and therefore the replies) will be very similar.

Cheers
RodG

02 Feb 2016, 19:09

#7

mandeepmavi

New Zenner

Join Date:: Dec 2010
Posts:: 32
Plugin Contributions:: 0

Re: mySQL Local and online data synchronization or replication

Then any Idea, how replicate everyday changes in Local DB to online DB. Import Export will change whole database.
Can I make a local log of all changes done in local DB and post them to online DB.

03 Feb 2016, 06:44

#8