Moving connections and instances between two computers

mysql mysql-workbench workbench
Mr Rebel picture Mr Rebel · Dec 15, 2010 · Viewed 53.5k times · Source

I´ve got a mysql-server that I´m administrate remotely with MySQL Workbench.

Now I´ve got a new computer and I cant find any solution to move my connections and instances-profiles to my new computer. This can´t be an unsolved question, huh? Not the first time this would happen for someone else.

Correction: It´s not the server-instances that I want to move. I need to export/move/backup my many client-profiles/instances-connections in MySQL Workbench.

Answer

Glyn Jackson picture Glyn Jackson · Sep 4, 2014

You don't need to copy any files manually as other answers suggest. On both Windows and Mac you can export all your settings within MySQL Workbench and restore to another system.

Select Tools > Configuration > Backup Connections

This will export as a .zip. Then on your new new install just

Select Tools > Configuration > Restore Connections

Linux MySQL Workbench Backup/Restore Connections

That's it!

Related questions

Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More
How to copy table between two models in Mysql workbench?

I am doing some databese thing, I need copy one table from one model to another, but i try many ways there no effect. Is there any way for doing this?

Read More
Does MySQL Workbench autocomplete work?

Using MySQL Workbench, when I press CTRL + space it looks like there is an autocomplete feature (However, no items appear in the auto complete box). I am not sure that MySQL workbench has an autocomplete feature like SQLyog has(See …

Read More