We help IT Professionals succeed at work.

MySQL Workbench - Guidance on how to synchronize 2 databases

Ederwainer
Ederwainer asked
on
1,269 Views
Last Modified: 2012-06-27
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
screen 1screen 2screen 3screen 4
Comment
Watch Question

Author

Commented:
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 JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
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
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I came across a simple solution and dismissed Mysql Workbench
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.