MySQL Forums - Workbench - Schema Compare, Diff, Synch

Database schema design for a discussion forum (no replies)

Akshay Sharma — Sat, 23 Feb 2013 18:03:21 +0000

I am new to the database design, but i have develop a discussion forum website using php and mysql. I am looking for a sample database schema so that I can start with it. Later, I will modify it according to my requirement.
Specific problem I am facing in designing it is, every question and topic can have followers so how do I store that data ?

potential bug in MySQL and proposed work-around for MWB (1 reply)

Rasmus Schultz — Thu, 14 Feb 2013 08:12:28 +0000

Today, I ran into a very strange issue while attempting to synchronize changes in the model to the database. Some changes were being applied, but others were simply being ignored - I finally took out the generated SQL statement and starting slicing and modifying it, until I narrowed it down to this:

https://gist.github.com/mindplay-dk/4945767

I have posted enough information to enable you to easily repeat this problem.

To avoid this problem for the time being (though this is likely a bug in MySQL) MWB should quote the single quote character in strings and comments as two single quotes, rather than as a backslash and single quote.

I am using MWB 5.2.46 CE and MySQL 5.5.27 on Windows 8.

MySQL WB Utilities: Diff / Alter generation by dump (1 reply)

Sebastian Lange — Thu, 14 Feb 2013 13:46:16 +0000

Hi there,

i was working quite a time now with the WB itself and a bit with the python scripts included. I now got the problem of automating the "Reverse Engineer ALTER Script" Function from the WB with the python scripts.

I have a active DB in a unknown (version-)state, but i do have ALTER and CREATE scripts for all versions. I now simply want to check by comparing the running DB (or the dump of that DB) with a CREATE script generated within the WB (by ModelView: Reverse Engineer CREATE Script).

So easiest would be to just compare the dump (only Structure) and my CREATE script, but none of the MySQL-WB Utilities nor the py-scripts in MySQLWB/python does take files or streams as arguments.

Wouldn't there be a close py-function already?
Has someone made this already and can give me some hints or even solve this?
Does the WB itself not resort on the py-scripts?

Thanks for your time and help
Sebastian

Edited:
OS is Windows XP with MySQL Server; all scripts and a Portable Python are located on USB, no WB on the Production Machine this has to be executed on

The WB is only on Developers machine, so just check for diffs in WB is out of question.

Edit2:
Topic set more specific

Synchronization in Mac version (1 reply)

Joe K — Thu, 03 Jan 2013 08:54:11 +0000

Is synchronization possible in the mac version, if so, how? The instructions on the web indicate the windows version - the dialog windows don't match. Thanks!

Same EER Digram to update multiple schematas (no replies)

Anton Z — Sun, 04 Nov 2012 07:19:34 +0000

Hi,

I have a an EER diagram for my CMS system that I want to use to update all websites running on my local server that are the installations of my CMS. Is there a way to have a master EER Diagram and then synchronise the updates in this EER Diagram with multiple schematas in Mysql Workbench and multiple physical databases. Basically I want to select what database to push changes to after I update EER Diagram.

Thank you,
Anton

Compare live database to workbench model. (no replies)

Michael Reed — Tue, 16 Oct 2012 17:04:22 +0000

I am using MySQL Workbench 5.2.42 CE on my Windows 7 PC, and have a saved database model. I am running MySQL on a Linux server. Using MySQL Workbench's "Manage DB Connections", I am able to connect to MySQL running on the Linux server.

How do I compare the MySQL Workbench model schema to the MySQL live database schema?

I have experimented with "Generate Category Diff Report" (AKA "Compare and Report Differences in Catalog") but am not sure if I am doing it correctly. I get the following... I attempt to manually compare them, and I can't figure out what was changed. Thank you!

+--------------------------------------------+
| Catalog Diff Report |
+--------------------------------------------+
Table `mySchema`.`users` was modified
indices:
__
Table `mySchema`.`ranking` was modified
columns:
- modified column date
- modified column rank
__
----------------------------------------------
End of MySQL Workbench Report

Database version Control (1 reply)

Tom Suter — Mon, 29 Oct 2012 09:16:11 +0000

Hello everyone, i wonder if someone has a smart solution for this challenge.

Here is the case:

You got site A live. Then the customer wants some massive changes, so you make a copy of Site A and its database in a test environment.

After doing all the modifications (new add-ons, new custom stuff, etc) you want to update site A again. The problem is we use a CMS which stores metadata as records in some tables.

How can you manage this in a way the client can keep his site live and that upgrading to the new version doesn’t give to much headaches.

Some solutions we thought of:
- A diff tool like Navicat (problem with that is that it drops and inserts a table, when you only renamed it).
- A tool which records all queries on the test database in a file (or table), so you can run those queries as soon as you update the live environment. We haven’t found a good tool yet. Liquibase (http://www.liquibase.org/) is a step in the right direction, only the script with queries should populate itself.

Suggestions are more then welcome.

Thanks for any suggestion in the right direction.

Model sync and definers of proedures (no replies)

Ian Wood — Wed, 12 Sep 2012 15:37:37 +0000

Hi people,

wondering if there is any workround for this scenario...

I have a bunch of procedures in my model with no definer.
when ever I do a sync, the model and schema always differ on a procedure where the schema has the definer while the model does not.

I work in a team and for some pretty lazy reasons would like to skip over the definer difference detection in any sych operation.

If there is a method to achieve this please advise; alternatively what we as a team could do to allow our models to be used across environments (production migration scripts too!) to remove the task of addressing this in our work.

many thanks in advance

need help with data sync (no replies)

satyaprakash dixit — Tue, 05 Jun 2012 06:45:58 +0000

Hi
Need help urgently.

I tried to generate the diff sql script between two databases but what i see is the script file contains only the create statements even if the table exits in the other db and there is a schema diff.

i want a create statement only when the table is absent
and want a statement such as..
"alter table a.t1 add column c1 int(1)"
where t1 exists in database b but just misses the column c1

i need it so that just by looking i shld understand that there is a diff at that level..

Schema synchronization in command line (no replies)

Petr Hubík — Thu, 29 Mar 2012 18:21:37 +0000

Hello,
database synchronization in Workbench is really cool, but is there any way how generate diff script without GUI? I red about MySQL utilities and I generated diffs of two schemas in mysqldbcompare. Is there any way to get SQL diff scripts like in GUI version? (You know,

Hello,
database synchronization in Wokbench is really cool tool. It's generating very nice sql diff scripts of two schemas. I need to generate this delta scripts in with command line. I was playing with mysqldbcompare from MySQL Utilities, but this tool gave me only diffs of CREATE TABLE SQL.
Is there any other way to generate SQL scripts like GUI can? (I mean ALTER TABLE `blahblah` ADD COLUMN ...)?

Thanks for any advice

MySQL Workbench 5.2 (1 reply)

gloria lozinski — Wed, 14 Dec 2011 09:00:20 +0000

If you were to go to Community and then Faqs about workbench and scroll until MySql Essentials Webinar Series you will SQL Editor if you were to view screen shot on windows you will see that I would like my layout to look like that but currently it is reversed so that the object and connection info is on the right hand side and the sql query and bottom section is on the left hand side. If I click on view and only get Home and Output...where can i restore to original layout. Thank you in advance.

Feature request: bypass triggers/sps/functions when synching schemas (1 reply)

Ricardo Oliveira — Tue, 08 Nov 2011 08:33:26 +0000

Im sure this is not the first time this comes up, but would be really nice if workbench had an option to bypass touching sps, functions or triggers when synching different databases. Specially because for large number of triggers, querying mysql for existing triggers take a lllong time. cheers

Schema Compare And Synch Data (3 replies)

Dominic Bregante — Fri, 11 Nov 2011 12:50:11 +0000

Hello,
I am new to Workbench and have a question on Schema Compare and Sync. I am able to compare sql files and or database and output sql file to update the new database. Is there also a way at the sametime when creating the sql update file that it includes the data from the original database? So when I run the new sql file to update the new database it also imports the data?

Thanks JR

MySQL slave can't be synced with master when table/schema is edited with Workbench (1 reply)

Huiting Yang — Wed, 02 Nov 2011 12:12:55 +0000

I am using Workbench 5.2.34 and my MySQL servers run as master-slave mode -- one machine is master and another one is slave.

When I modify schema/table on master machine with command line, slave can be always synced timely and correctly. However, whenever I use Workbench to perform any database operations, slave is always out of synced then. Is it designed intentionally?

Synchronization problems! (2 replies)

Greg Ellis — Thu, 21 Jul 2011 17:17:23 +0000

I am having problems using the Synchronize Model feature of MySQL WorkBench v5.2.34 CE Revision 7780. I am using XAMPP for my local mysql server instance.

I am having the same problems that this fellow posted about in this thread http://forums.mysql.com/read.php?159,382585,382585#msg-382585

I created a model using MySQL workbench and forward engineered it to my local mysql instance. All the tables appear as they should and everything works correctly. I then immediately try to use the Synchronize Model feature and I expect that it should tell me that the model and local database instance are the same and that there is nothing to synch. However, it for some reason deletes my views and see changes in columns that do not exist. It's not working at all. It's almost as if it's seeing a totally different database schema on my local server, but I have double and triple checked and the workbench model and database instance are identical.

The weird thing is that if I try doing this exact same procedure with my shared hosting environment at lunarpages hosting the Synchronize Model features acts as expected and works perfectly! So it looks like the my local mysql server configuration may be causing me problems. Has anyone else experienced this weirdness? I really love mysql workbench and if the synchronize model feature would work it would make life so much easier.

Thanks,
Greg

WB does not "find" database with dame name on server (no replies)

Ralf Jahr — Sun, 17 Jul 2011 21:08:02 +0000

Hi!

Well, I switched from DB Designer to WB a few month ago. Now I really need to use the synchronization, which does not seem to the best piece of work, and ran into big trouble:

On localhost:3306 I have the "live" version of the DB running. It has name "access_cope". In my ERD I renamed the schema accordingly. But when i run synchronization, I get the window with the objects to change, the content looks like this:

access_cope ===> N/A
N/A ===> access_cope

It basically wants to create new tables in both DB and model. This seems foolish. How can this be? I am using version 5.2.34 CE Revision 7780.

Thanks for any help!

Ralf

MySQL Utilities: mysqldbcompare (Python script) (no replies)

Edwin DeSouza — Thu, 14 Jul 2011 23:11:32 +0000

MySQL Utilities: mysqldbcompare (Python script)
- checking master and slave for consistency
- checking production and development databases for consistency
- generating a difference report for expected differences among new and old data
- comparing backups for differences

http://drcharlesbell.blogspot.com/2011/06/comparing-databases-with-mysqldbcompare.html

WB can't find DB/Schema on the server. (1 reply)

Matt JustMatt — Wed, 13 Jul 2011 16:51:11 +0000

Hi there!
When trying to synch model with my DB on remote server WB cannot find proper schema to synch with. The provider enforces naming convention: myUserName_mySchemaName and for some reason when WB (after successfully connecting with server) gives me a schema choice it lists only the "mySchemaName" part omitting the "myUserName" prefix. So it makes it impossible to synch. Using myUserName_mySchemaName as my default schema also does not help :(

Interestingly when using "query database" feature, WB has no problems finding the full schema name (including the prefix).

How can I fix this?

Cheers!
Matt

Workbench, Gnome crashes when Synchronizing (2 replies)

Jim Murphy — Thu, 16 Jun 2011 11:06:30 +0000

Hello,

Has anybody experienced this? While synchronizing model to source on remote server over SSH Workbench crashes fatally, gnome crashes and becomes unstable. This is done through the synchronizing wizard. I have synchronized this schema before with tables just as large without issue. Also crashes instantly when selecting “Synchronize with Any Source”. I checked for reported bugs but did not see anything like this. But I could have missed it. The server is running Ubuntu Server 10.10 and the client is running Ubuntu 10.10. The SSH is local.

Could the size of the sql be the issue

Thanks for the help

See sql below

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

ALTER TABLE `Test`.`actrec` CHANGE COLUMN `RECNUM,N,10,0` `RECNUM,N,10,0` INT(10) NOT NULL DEFAULT NULL , CHANGE COLUMN `CLNNUM,N,10,0` `CLNNUM,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `CONTCT,C,30` `CONTCT,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `ADDRS1,C,30` `ADDRS1,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `ADDRS2,C,30` `ADDRS2,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `CTYNME,C,25` `CTYNME,C,25` VARCHAR(25) NULL DEFAULT NULL , CHANGE COLUMN `ZIPCDE,C,10` `ZIPCDE,C,10` VARCHAR(10) NULL DEFAULT NULL , CHANGE COLUMN `PHNNUM,C,14` `PHNNUM,C,14` VARCHAR(14) NULL DEFAULT NULL , CHANGE COLUMN `ACHTCT,N,10,0` `ACHTCT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `LENDER,N,10,0` `LENDER,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `SPRVSR,N,10,0` `SPRVSR,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `SLSEMP,N,10,0` `SLSEMP,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `ESTEMP,N,10,0` `ESTEMP,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `USRDF1,C,30` `USRDF1,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `USRDF2,C,30` `USRDF2,C,30` VARCHAR(30) NULL DEFAULT NULL , CHANGE COLUMN `LCLTAX,N,6,0` `LCLTAX,N,6,0` INT(6) NULL DEFAULT NULL , CHANGE COLUMN `SLSTAX,N,6,0` `SLSTAX,N,6,0` INT(6) NULL DEFAULT NULL , CHANGE COLUMN `LGRACT,N,10,0` `LGRACT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `DPTMNT,N,10,0` `DPTMNT,N,10,0` INT(10) NULL DEFAULT NULL , CHANGE COLUMN `DSCDTE,C,6` `DSCDTE,C,6` VARCHAR(6) NULL DEFAULT NULL , CHANGE COLUMN `DUEDTE,C,6` `DUEDTE,C,6` VARCHAR(6) NULL DEFAULT NULL , CHANGE COLUMN `DSCCNT,N,5,2` `DSCCNT,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `FINCHG,N,5,2` `FINCHG,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `RETAIN,N,5,2` `RETAIN,N,5,2` DECIMAL(5,2) NULL DEFAULT NULL , CHANGE COLUMN `CNTRCT,N,12,2` `CNTRCT,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `BEGBAL,N,12,2` `BEGBAL,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ENDBAL,N,12,2` `ENDBAL,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `BIDDTE,D` `BIDDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `PLNRCV,D` `PLNRCV,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `ACTBID,D` `ACTBID,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `CTCDTE,D` `CTCDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `PRELEN,D` `PRELEN,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `STTDTE,D` `STTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `CMPDTE,D` `CMPDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `LENFLD,D` `LENFLD,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `LENRLS,D` `LENRLS,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `JOBTYP,N,3,0` `JOBTYP,N,3,0` INT(3) NULL DEFAULT NULL , CHANGE COLUMN `STATUS,N,2,0` `STATUS,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `PSTWIP,N,2,0` `PSTWIP,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `CRTFID,N,2,0` `CRTFID,N,2,0` INT(2) NULL DEFAULT NULL , CHANGE COLUMN `CONNUM,C,15` `CONNUM,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `PCHORD,C,15` `PCHORD,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `IMGFLE,M` `IMGFLE,M` MEDIUMBLOB NULL DEFAULT NULL , CHANGE COLUMN `CSTTYM,C,1` `CSTTYM,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYL,C,1` `CSTTYL,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYE,C,1` `CSTTYE,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYS,C,1` `CSTTYS,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `CSTTYO,C,1` `CSTTYO,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS6,C,1` `USRCS6,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS7,C,1` `USRCS7,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS8,C,1` `USRCS8,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `USRCS9,C,1` `USRCS9,C,1` VARCHAR(1) NULL DEFAULT NULL , CHANGE COLUMN `NTETXT,M` `NTETXT,M` MEDIUMTEXT NULL DEFAULT NULL , CHANGE COLUMN `EXPORT,M` `EXPORT,M` MEDIUMTEXT NULL DEFAULT NULL , CHANGE COLUMN `LOTCLR,C,15` `LOTCLR,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `LOTPRM,N,12,2` `LOTPRM,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `PLNPRC,N,12,2` `PLNPRC,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ACTPRC,N,12,2` `ACTPRC,N,12,2` DECIMAL(12,2) NULL DEFAULT NULL , CHANGE COLUMN `ESTDTE,D` `ESTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `ACTDTE,D` `ACTDTE,D` DATE NULL DEFAULT NULL , CHANGE COLUMN `MODNME,C,15` `MODNME,C,15` VARCHAR(15) NULL DEFAULT NULL , CHANGE COLUMN `SQARFT,N,10,0` `SQARFT,N,10,0` INT(10) NULL DEFAULT NULL

, ADD PRIMARY KEY (`RECNUM,N,10,0`)

, ADD UNIQUE INDEX `RECNUM,N,10,0_UNIQUE` (`RECNUM,N,10,0` ASC) ;

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Problem comparing dates with Variable containing date (no replies)

Bill Clemens — Thu, 26 May 2011 01:24:10 +0000

Have a problem using varaible to hold input date and comparing it to date in database.

This works:

SELECT count(DISTINCT t.usrid) FROM ABANA_Users u, ABANA_Memberships m LEFT JOIN ABANA_Transactions t ON m.tranid = t.tranid WHERE u.usrid = m.usrid AND t.paydate <= '{{date}}' AND m.expdate >= '{{date}}' AND t.deposited IS NOT NULL AND u.valid ='Y'

But requires entering the same date twice, once for each "{{date}}' in the query

Am trying to replace it with one date entry held in a variable @xdate and using the variable twice to do the comparisons:

SELECT @xdate := '{{DATE}}', count(DISTINCT t.usrid) FROM ABANA_Users u, ABANA_Memberships m LEFT JOIN ABANA_Transactions t ON m.tranid = t.tranid WHERE u.usrid = m.usrid AND t.paydate <= @xdate AND m.expdate >= @xdate AND t.deposited IS NOT NULL AND u.valid ='Y'

Get no results but if I replace the variable @xdate with its contents '2011-05-01' for instance the query runs and produces the expected results.

Having the @xdate := '{{date}}' in the SELECT statement results in the entered date being output and it looks exactly as expected so I'm at a loss as to why the comparison with the variable @xdate doesn't work

SELECT @xdate := '{{DATE}}', count(DISTINCT t.usrid) FROM ABANA_Users u, ABANA_Memberships m LEFT JOIN ABANA_Transactions t ON m.tranid = t.tranid WHERE u.usrid = m.usrid AND t.paydate <= '2011-05-01' AND m.expdate >= '2011-05-01' AND t.deposited IS NOT NULL AND u.valid ='Y'

Can someone help me out?

Need to restore to original layout (1 reply)

gloria lozinski — Fri, 05 Aug 2011 19:23:02 +0000

Object browser has been placed on right hand side of screen. Need to put it back to the left hand side of screen. How does one go about doing this? Thank you in advance.

Rename database schema makes synchronisation impossible (4 replies)

Maxime MARAIS — Wed, 18 May 2011 06:55:28 +0000

Hi !

I am facing a strange behavior in MySQL Workbench. I am working in a shared environment with other developers. In my project I have to make important changes on a database structure and its associated objects (on php code side). In order not to interfere with other developers' jobs in progress, I created a working copy of the schema (both structure and data) on the same server, just the time I make all I have to do and publish code changes to other developers. I also edited my MySQL Workbench Model renaming the Physical Schemata to the name of the copy of my database schema to reflect changes in database server, applying these changes to all tables as suggested. Now, when I try to synchronize the model with the database, MySQL Workbench does not behave like I would expect it to behave. Instead of simply syncing, MySQL Workbench try to apply changes from Model "project_copy" to a source named "N/A" and to synchronize a model 'N/A' to a source named "project_copy", in fact my working copy of the database schema.

And of course, MySQL workbench tries to drop all and recreate all tables, even if they are named the same and are identical in both model and source.

I cannot figure out how to make MySQL Workbench to simply synchronize model and source like if schema was just renamed. If someone faced the same issue and found a solution, could you please tell me how to do ?

Thanks.

Database Sync ignores one table (1 reply)

Kai Renz — Sat, 02 Apr 2011 10:08:06 +0000

Hi there,

i just designed my first database using msql workbench but now i got a small problem - the "districts"-table isn't synchronised with my database. Since describing my model would take too long, i just uploaded a screenshot: http://img146.imageshack.us/i/dbmodel.jpg/

Hope you can help me...

regards,
writemecas

Command line tool to do database synch and compare (1 reply)

Ricardo Oliveira — Thu, 10 Mar 2011 04:55:11 +0000

Hello,

First off, thanks for the great work on mysql workbench. The reverse engineer db and synch schemas is one of the features i use a lot. I was wondering if there's a command line tool that does this, so i can script it in a semi-automated way? thanks

Applying EER-Model to different database (2 replies)

Jo Kilian — Fri, 25 Mar 2011 21:51:21 +0000

Hi,

probably a simple question - but cannot figure it out yet ...

I made a clone of my productive database and did some model adaptions on my database clone (Data Modeling -> EER model)

I synchronized the model with my clone - and checked the validity of my changes.

Now I want to synchronize my model with the original database - to get my development bach to production ...

Opening my stored EER-Model, I get only my clone database offered for synchronization.

How can I selct a different database for synchronization with my EER-Model?

Any help welcome
Jo

Synchronize data in 2 databases (1 reply)

N/A N/A — Mon, 14 Feb 2011 08:47:13 +0000

Here's my problem.

I have a website hosted on server A which uses database A for content storage. I want to have a backup server B which will kick in and provide content for visitors if for any reason server A goes down.

So what I need to do is to synchronize the databases on the 2 servers but with a few things in mind:
1. Whenever something is modified in database A (via INSERT UPDATE DELETE etc) push the modifications to the database B on server B
2. If server A goes down and site runs on server B, if there's any new modifications on server B (INSERT UPDATE DELETE) push data back to server A as soon as it comes back online

What I want to do is have the two databases in perfect sync without a lot of delay between syncs.

Any pointers to how I could do this?

Thanks

Compare Pligg and Wordpress database and synchro (1 reply)

Tan Andrew — Sat, 05 Feb 2011 07:45:28 +0000

Hi,
I will like to map Pligg to Wordpress, create a sql file that will transfer the Pligg tables to wordpress.

Please advise on how to do this?.

Thanks,
Andrew

Mysql GUI to sync tables (2 replies)

Jan Jezek — Thu, 11 Nov 2010 13:04:04 +0000

Hi guys,

my first post here! ;-)

I am searching (since housrs) to find a GRAPHICAL TOOL FOR MAC, which can SYNC, MERGE or ADD data from one table to another.

I have a table with addresses and wanna add these addresses to another database with addresses. The field names and tables are called different. For ex. in one its called "addr" in the other its called "addresses".

I didnt found a solution right now, so maybe a "MYSQL GEEK" could help me.

Here is a tool who has this function, but it only works with CSV and MYSQL -> http://www.dbtube.org/cms/

Forward Engineer with ALTER doesn't include all indexes (2 replies)

Mark Mandel — Wed, 03 Nov 2010 09:49:16 +0000

I've got 2 databases - local and public dev.

I've been doing some indexing work locally to get some queries up to speed.

Stupid me, I haven't kept track of what indexes I have done locally and what I haven't added across to public dev.

So I fire up mySQL workbench, and set it up to do a Forward Engineer with ALTER... and it creates a lovely SQL script to create new tables that I have locally, recreate some differently named foreign key constraints.... and do everything except for actually give me the SQL for the missing indexes.

Please tell me that I'm not going crazy here, and this is just a bug that has yet to be resolved, that mySQL Workbench doesn't yet know how to synchronise indexes?

Or am I doing something totally wrong (would be happy to know that as well).

Happy to provide an example if need be.

Help?!

Invalid default value for (1 reply)

www vvv — Mon, 18 Oct 2010 08:11:50 +0000

I try to make synchronization. Gives out such error, tried instead of NULL to put ' 0000-00-00 0:00:00 AM ' or 0 all the same one and too, at an insert of the same code through PhpMyAdmin all perfectly works, prompt in what there can be a problem

Workbench 5.2.29 CE Revision 6756

ERROR: Error 1067: Invalid default value for 'date_of_issue'

CREATE TABLE IF NOT EXISTS `hvo_main`.`foreign_passport` (
`num` VARCHAR(255) NOT NULL ,
`first_name` TEXT NOT NULL ,
`last_name` TEXT NOT NULL ,
`date_of_birth` TIMESTAMP NOT NULL ,
`nationality` VARCHAR(45) NOT NULL ,
`sex` VARCHAR(45) NOT NULL ,
`date_of_issue` TIMESTAMP NOT NULL DEFAULT NULL ,
`date_of_expiery` TIMESTAMP NOT NULL DEFAULT NULL ,
`authority` TEXT NOT NULL ,
`country` TEXT NOT NULL ,
PRIMARY KEY (`num`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci