Is there a way to export my existing connections from MySQL Workbench to Sequel PRO

Question

I have been browsing through all options I could and I cant find an option that would let me export all my connections from workbench

I have a lot of connections in the workbench and I am planning on using sequel pro now.

Here is a bug related to "Backup file creation error" when attempting the current accepted answer https://stackoverflow.com/a/31862137/470749 https://bugs.mysql.com/bug.php?id=102501 — Ryan, Oct 19 '21 at 23:22
On ubuntu (installed via snap): ~/snap/mysql-workbench-community/9/.mysql/workbench/connections.xml — Hafenkranich, Apr 17 '22 at 16:41

score 100 · Accepted Answer · answered Aug 06 '15 at 17:28

100

Unfortunately due to the fact that Sequel Pro does not have option to import connections at all, you will be unable to import the connections.

There are two ways in order to export your connections from MySQL Workbench into a file:

Follow the procedure to export the connections from the menu:

Open and Select MySQL Workbench > In the Menu bar select Tools > Configuration > Backup Connections
Find the CONNECTIONS.XML file located at

Users/Username/Library/Application Support/MySQL/Workbench/connections.xml

About Sequel Pro...

The connections strings are stored in the following preference file:

~/Library/Preferences/com.sequelpro.SequelPro.plist
The passwords are stored in the Mac OSX Keychain, which is stored here:

~/Library/Keychains/login.keychain

answered Aug 06 '15 at 17:28

Anton Todorov

Ah that's a bummer. I dont want to keep setting up connections in the sequel pro.. I will stick to workbench for now. And thanks for the answer – Nick Div Aug 06 '15 at 19:12
You are welcome. It will be greatly appreciated if you mark it as an answer at least. – Anton Todorov Aug 06 '15 at 21:46
2

`Sequel Pro does not have option to import connections at all` not true check the [JAstuccio's answer](http://stackoverflow.com/a/37145386/316700) – fguillen Feb 15 '17 at 15:04
That is a new feature. It was not available back in 2015. – Anton Todorov Jun 23 '18 at 12:20
For number 2. Run the 'Keychain Access' Application in OSX, search for SequelPro and all your connections are listed. Right click 'export password' and job done. – Nick T Oct 19 '18 at 16:32
6

Windows 10 path for connections.xml will be Users\User\AppData\Roaming\MySQL\Workbench – Maksim Maksimov Jan 21 '20 at 15:13
1

Error: Backup file creation error; Could not create the backup file. Please check path and permissions and try again. (MySQL Workbench 8.0.26 on Windows 10) – Shibu Aug 02 '21 at 07:34

score 40 · Answer 2 · edited May 23 '17 at 12:26

40

You can import a plist file using Sequel Pro. Click the gear icon in the bottom left.

credit to james-chevalier for showing me how to do this.

edited May 23 '17 at 12:26

Community

answered May 10 '16 at 17:37

JAstuccio

Great answer - nice that you can import/export from that menu - you can also select multiple. I had a time machine backup so the keychain/password thing was there, but for whatever reason the favorites didn't come across. +1 – mikevoermans Jul 19 '16 at 20:20
3

hi - this is what i hoped for, but perhaps i am missing something obvious. i copied over the plist via airdrop - when i try to import via the 'import' i get 'error reading import file'. any thoughts? – petednz - fuzion Oct 17 '16 at 11:41
syntax error in your plist file maybe? @petednz-fuzion – JAstuccio Oct 19 '16 at 01:08
If you copy the file, you will get an error. Select all your connections, click on the Settings icon and click Export selected. Then you will be able to import that file. – David Simon Feb 12 '19 at 14:47

score 14 · Answer 3 · answered Feb 11 '19 at 17:16

14

Open Keychain Access using Alfred.
Find (top right of GUI): sequel
Double-click the result you're looking for... It should be something like root@localhost/
Checkbox Show Password
Type in your Mac password
Enjoy

answered Feb 11 '19 at 17:16

corysimmons

3 Answers3