Best IT Recipes

Moving connections and instances between two computers

I have a mysql server that I can administer remotely using MySQL Workbench.

Now I have a new computer, and I can’t find a solution for transferring my connections and profile instances to a new computer. This may not be an unresolved issue, right? Not for the first time this will happen to someone else.

Correction: These are not server instances that I want to move. I need to export / move / reserve my numerous client profiles / connection instances in MySQL Workbench.

+59
mysql mysql-workbench workbench
Dec 15 '10 at 14:21
source share
8 answers

I had the same questions. I found the MySQL directory in% APPDATA%. Copy the entire directory to the same location on the new computer. You need to clear the passwords and re-enter them. As soon as I did this, I started working again.

You can find your% APPDATA% folder on Windows by typing it in the address bar of Windows Explorer.

+41
May 17 '11 at 18:28
source share

You do not need to copy files manually, as other answers suggest. On Windows and Mac, you can export all your settings to MySQL Workbench and restore to another system.

Select Tools > Configuration > Backup Connections

It will be exported as .zip. Then on a new new installation just

 Select Tools > Configuration > Restore Connections

Linux MySQL Workbench Backup / Restore Connections

What is it!

+82
Sep 04 '14 at 11:35
source share

Found this on mac at / Users / Username / Library / Application Support / MySQL / Workbench /

file called connection.xml

+12
Feb 27 '13 at 18:28
source share

On Linux (Ubuntu), the location has been changed to $HOME/.mysql/workbench

Tested on Ubuntu 14.04 LTS.

+6
May 20 '14 at 12:08
source share

just copy them!

on Linux, they are in $HOME/.mysqlgui/

+4
Dec 15 2018-10-15
source share

Before replacing the connection.xml file, first close the Workbench application or the application will overwrite / save the xml file on exit.

+2
Aug 07 '13 at 6:18
source share

Backing up and restoring connections using the Tools> Configuration> Backup Connections and Tools> Configuration> Restore Connections menu is the easiest way, but it does not copy passwords.

Password recovery is possible in the following case:

  • The old PC should be a Windows installation.
  • You can log in using the Windows account that originally saved the passwords in Workbench, i.e. without administrator password Windows reset from administrator.

If the above requirements are met, you can log into the old computer and run the decryption tool found at http://www.donationcoder.com/forum/index.php?topic=41860.msg391762#msg391762

C ++ code for decryption is shown below (credits: f0dder)

 std::vector<unsigned char> decrypt(BYTE *input, size_t length) { DATA_BLOB inblob { length, input }; DATA_BLOB outblob; if (!CryptUnprotectData(&inblob, NULL, NULL, NULL, NULL, CRYPTPROTECT_UI_FORBIDDEN, &outblob)) { throw std::runtime_error("Couldn't decrypt"); } std::vector<unsigned char> output(length); memcpy(&output[0], outblob.pbData, outblob.cbData); return output; }
+1
Oct 31 '17 at 15:20
source share

I found the file "WbProfiles.xml" in the path C: \ Users \ .sqlworkbench \ WbProfiles.xml

Copy the file or copy the full ".sqlworkbench" folder to the same path on the new computer.

0
Aug 22 '17 at 7:27
source share


More articles:


All Articles