MySQL Workbench - Guidance on how to synchronize 2 databases

Hello everybody,

I'm having difficulty to synchronize two databases, one local model and a remote DB using Mysql Workbench.

I create the model and connect to the source and when I get to the screen that should show both dbs so I can choose what to synch, it shows my source as N/A with a messge at the end saying that my model is not yet on the RDBMS Server and I need to Forwar Engineer to create it.

My scenario is:

I have a remote database that I need to use as a source to update/synchronize other databases.

Can anybody help?

Thanks!

Eder Wainer

MySQL Server

Last Comment

Ederwainer

8/22/2022 - Mon

Ederwainer

5/19/2011

ASKER

Maybe someone knows a different way for doing this.

Im open to suggestions, considering that all I need to do is update mysql databases based on a remote db or a local model, preserving the existing data.

Thanks

Eder

Tomas Helgi Johannsson

5/20/2011

Your message log indicates that you have typed an invalid password for user clicksec2@% or this user has not enough privileges to create databases and/or create/alter tables in
that particular db.

http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
Hope this helps.

Regards,
Tomas Helgi

ASKER CERTIFIED SOLUTION

Ederwainer

5/24/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Ederwainer