Export Favourites?

5,432 views
Skip to first unread message

matm00

unread,
Jul 28, 2010, 6:36:12 AM7/28/10
to Sequel Pro
I'm moving to a new Mac and would like to transfer all my favourites
to this new machine so I don't have to input all the details again -
is there an easy way of doing this, a preferences file perhaps?

Thanks.

Filipp Lepalaan

unread,
Jul 28, 2010, 6:40:24 AM7/28/10
to seque...@googlegroups.com
If you use Apple's Migration Assistant, all the favourites will transfer automatically. :-)
Otherwise just copy ~/Library/Preferences/com.google.code.sequel-pro.plist

-filipp

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.
>

JRP Support

unread,
Jul 28, 2010, 6:57:39 AM7/28/10
to seque...@googlegroups.com
...can we have this integrated with MobileMe please !!!! :-)

Jakob Egger

unread,
Jul 28, 2010, 2:25:44 PM7/28/10
to seque...@googlegroups.com
MobileMe should sync your Sequel Pro preferences (and favorites) automatically, at least if I understand Apple's documentation correctly. See http://support.apple.com/kb/ht2085

Are you saying that this automatic syncing does not work? It could be that syncing doesn't work if Sequel Pro is running on both computers simultaneously.

I do not have a MobileMe subscription, so I cannot test this myself.

Best Regards,
Jakob Egger

JRP Support

unread,
Jul 28, 2010, 3:44:50 PM7/28/10
to seque...@googlegroups.com
I find it does not.
That's not your fault.
It does not appear in MobileMe syncable preferences so I expect it needs some hook into the Apple and MobileMe system or a file/preference installed in the right place ?

JRP
www.jrpmedia.co.uk
www.jrpsupport.co.uk
www.jrphosting.co.uk

Jakob Egger

unread,
Jul 28, 2010, 4:24:31 PM7/28/10
to seque...@googlegroups.com
I just read some more documentation on MobileMe. (This is pretty hard, if you try to figure out a service you don't use yourself...)

Sequel Pro has no specific support for Mobile Me. However, you can enable "Preferences"-syncing. (There's this "System Preferences" icon next to it). If I understand correctly, this should synchronize all application preferences, including Sequel Pro. Of course this could be more than you want...

To offer real syncing via MobileMe (with an icon in the MobileMe preferences), Sequel Pro would need to support Sync Services.

I have created a feature request in the Sequel Pro issue tracker at http://spbug.com/773

Best Regards,
Jakob Egger

JRP Support

unread,
Jul 28, 2010, 5:17:17 PM7/28/10
to seque...@googlegroups.com
Thanks Jakob,

Will try it out in the morning (UK)

James.

JRP
www.jrpmedia.co.uk
www.jrpsupport.co.uk
www.jrphosting.co.uk

JRP Support

unread,
Jul 29, 2010, 7:19:46 AM7/29/10
to seque...@googlegroups.com
Hi Jakob,

Yes! That did it, thank you :-)

James.

Aaron Bauman

unread,
Nov 19, 2012, 3:38:46 PM11/19/12
to seque...@googlegroups.com, fil...@mac.com
I found that copying the plist file correctly copied my favorites, but many of these were SSH connections whose passwords were not copied.

The passwords are in Keychain and must be copied separately, from ~/Library/Keychains/login.keychain

I also copied ~/.ssh/ for good measure

Rodolfo Vieira

unread,
Mar 6, 2013, 12:02:07 PM3/6/13
to seque...@googlegroups.com, fil...@mac.com
Quick update -- the favorites  to have moved to a new location on OSX/Sequel Pro 1.0.1 [build 4004]:

~/Library/Application Support/Sequel Pro/Data/Favorites.plist

Carlos Duarte do Nascimento

unread,
Nov 10, 2013, 3:18:48 AM11/10/13
to seque...@googlegroups.com, fil...@mac.com
Confirmed to remain this location  on 1.0.2

Tom Rossi

unread,
Jan 2, 2014, 9:27:56 AM1/2/14
to seque...@googlegroups.com
Copying the .plist file over doesn't appear to work with OSX 10.9.1 and Sequel Pro 1.0.2.  The .plist file appears to be overwritten each time Sequel Pro launches.

Jakob Egger

unread,
Jan 13, 2014, 4:34:26 AM1/13/14
to seque...@googlegroups.com
Yeah, OSX Mavericks caches user defaults. There's a lengthy discussion about this topic on cocoa-dev: http://prod.lists.apple.com/archives/cocoa-dev/2013/Nov/msg00320.html

A workaround might be to make sure to quit Sequel Pro, and kill "cfprefsd" before replacing the preference file.

Best regards,
Jakob


--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.

To post to this group, send email to seque...@googlegroups.com.

steve beyatte

unread,
Feb 19, 2014, 3:22:50 PM2/19/14
to seque...@googlegroups.com
This worked for me but I had to copy in the new .plist file within like 2 seconds or else the daemon would start up again. Hopefully that helps someone. Thanks!
Reply all
Reply to author
Forward
0 new messages