How can I backup MySQL Connections on MySQLWorkBench?

user_4480164 0
Viewed 2198

I've been using MySQL WorkBench for so long on Mac OS X. I've been trying to save/backup all my host connections before I update MySQL WorkBench.

enter image description here

Is there a way to do that ?

mysqlconnection macos-mojave mysql-workbench macos mysql
2 Answers

To backup/restore connections you can use 'Backup Connections...'/'Restore Connections...' form Tools->Configuration menu.

enter image description here

user_42269260

On your Mac, find the file ~/Library/Application Support/MySQL/Workbench/connections.xml

This XML file contains all the connection info, except for plaintext passwords (those are stored in the Keychain).

Re your comment:

I don't know why you need to delete the app. Just install the latest version over the old version. That's what I do, and what I assume everyone else does too.

You would not need to back up the connections.xml file unless you want to install MySQL Workbench on a different Macbook, and bring the connections to that new installation. But you'd need to enter the passwords again anyway.

Bill_Karwin_208600
Related