Backup or Transfer Navicat 6 Connections on OSX

I needed to take all the connections from my old machine and move them and navicat 6 over to the new one.

There is no exporter built into Navicat version 6, so I was more than a little concerned that I was going to have to find all my details and plug all the connections settings back in. Luckily this wasn’t the case.

If you browse to /Users/yourusername/Library/Preferences/com.prect.Navicat.plist – remember to replace ‘yourusername’ with your actual username

Copy that file to the new machine. Install Navicat. Put that file in the same location on your new machine.

Or if you just want to back up your connections then put the file somewhere safe and you’re done.

Open navicat and cross your fingers. All the connections should appear as if by magic. Nice.

I was moving from a 10.4 machine to 10.5 and did so with the same copy version of navicat.