Search code examples
mysqlmacosmysql-workbenchmacos-mojavedatabase-connection

How can I backup MySQL Connections on MySQLWorkBench?


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 ?


Solution

  • 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.