Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Moving connections and instances between two computers

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.

like image 559
Mr Rebel Avatar asked Dec 15 '10 14:12

Mr Rebel


People also ask

Where are MySQL connections stored?

On Windows, connection profiles are stored in C:\Documents and Settings\ UserName \Application Data\MySQL directory, where UserName is the name of the current Windows user. On Linux, the files are stored in the ~/. mysqlgui directory.


1 Answers

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!

like image 98
Glyn Jackson Avatar answered Dec 12 '22 18:12

Glyn Jackson