navicat - mySQL Table Sync -

navicat - mySQL Table Sync -

I suggest the best way to sync mySQL tables (myISAM) from 2 different databases.

Currently we use Navicat to sync tables from our production servers to our test servers, but we are running into many problems, about everyday we run into a sync failure on the table. Are there.

We sometimes get the error below, not to mention our email to successful and unsuccessful synchronized spam, just to get unsuccessful synchrot anyway?). I also know that changing the table anyway is a failure to synchronize. So by changing the table in any way, the master should be done (this is understandable, but is there any posture?).

- [synchronization] expired - unsuccessful synchronization: out of index index limit (0)

Is there any reason to not use Navicat sync? Instead my boss suggested to use my SQL replication, but my first concern is that why do we have so many problems because it seems that we are misusing sinks in such a way that we can all these problems Are giving up.

Thank you. <

Sync table to our test server from our production server
This sounds like You are trying to replicate the environment of your production in your test environment, right?
To follow in this situation, a similar pattern is to back up the whole database, later importing the backup into the test environment. By backing up and restoring a full , you are not only ensuring that you have at least one backup method that is known to work, you are also ensuring that the test is in the database There may not be any changes that a sync device might remember (usually requires a primary or unique key on each table to handle the sync tool effectively. A.)
The process of backup and re-import should automatically easy for you. At my workplace, we dump a mysqldump database based on each night, and import optional into the personal copy of the developer of the following development which starts the following morning

03:22 Get link Facebook X Pinterest Email Other Apps

Comments Post a Comment

Popular Posts r - Plot correlation matrix into a graph - I have a matrix with some correlation values. I now want to plot in that graphic which is more like this or Looks less: Library (Latis) # Horizontal and vertical axis information please take- c (div class = "post-text" itemprop = "text"> "214", "215", "216", "224", "211", "212", "213", "223", "226", "225") & lt; - Paste ("DM1- ", Hor, sep =" ") # counterfeit co Relation matrix narokol & lt; (I 1: nrowcol) for core [i] - length (var) core & lt; - matrix (runif (nrowcol * nrowcol, min = 0.4), nrow = nrowcol, ncol = nrowcol (Color, "blue", "yellow"), space = "RGB"), levelplates (core, main = "dimnames = list (hor, ver)), I] = 1 # plot rgb. Stage 12-14 array correlation matrix ") Xlab =" ", ylab =" ", col.regions = rgb.palette (120), cut = 100, at = seq (0,1,0.01)) ... asp.net - RegisterUser: CreateUserWizardStep - When using CreateUserWizardStep to register a new user I'm having a problem. Help me solve this problem.I have tried to configure in the web. Provider tag for configuration & lt; Required question and answer = "wrong" & gt; Although it still does not work ... I'm using the MySQL database RegisterUser :. An IEditableTextControl is not included with the CreateUserWizardStep.ContentTemplate ID question for the security question, it is necessary that your membership provider needs a question and answer. Source error: An unrestricted exception occurred during the execution of existing web requests. Information about the origin and location of the exception can be identified using the exception stack trace below. Stack trace:. [HttpException (0x80004005): RegisterUser: CreateUserWizardStep.ContentTemplate does not include questions IEditableTextControl security question with the ID, it is necessary to require a question and answer your subscri... Integrate flash games in android app? - 3 is a flash game that I want to integrate into a menu / list in the Android app. So when the user selects the game from the list, the game starts with the help of the Android Flash Player. Is it better or better with webwave? Is there any good tutorial? Thank you! Adobe Flash provides a good way: you can create a breeze for the Android app. Use this to create your menu and compile three games in your air app. Here are some tutorial links about how to publish AiI for Android applications and: PART1: AIR for Android, PART2: Publication for Android apps: Ai: I do not believe that the Android Flash Player can be launched with a single intention so far, so using Java Android will not solve it (now ) And and a third approach Whatever you mentioned, it should work - using the webwave.

Powered by Blogger