Menu
Is there a way to export my existing connections from MySQL Workbench to Sequel PRO
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.
Thanks in advance.
984
To export an SQL dump file of the table structure or contents you must first be connected a mysql host and have a database selected. Next, choose Export > MySQL Dump... from the File menu. This will bring up a dialog box where you can choose what tables you would like to export.
To import an SQL dump file using the most recent version of Sequel Pro, connect to your MySQL host and select a database, then choose 'Import...' from the File menu.
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.
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
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
