[robmann]

Does anybody know how or where I can find out how to setup the primary to be unique for three databases like with each having the following always before the auto inc number S1_ , S2_ , S3_ so that each will be unique and none will be overwritten on a sync? like JasonPotter posted

[robmann]

I understand that sync but here is the condition I am working with so what I want to do is to be able to enter data locally and online then sync the two but will have many records with the same primary but different information, is there a way to sync this sitation?

source:

=========

1 SQLyog

2 Ritesh

3 type

target:

========

1 SQLyog Agent

2 MySQL

3 work

would like to end up with onboth the source and target

1 SQLyog

2 Ritesh

3 type

4 SQLyog Agent

5 MySQL

6 work

[robmann]

So can you sync the online data and the local data even though you are entering new data all the time both online and locally? I read something about if primary keys are the same the target gets overwritten? is there a way to sync if you have the same primary keys in each table?

[Author]

Posts