Generally these days I’m tending to access mysql from the CLI but when writing a data importer script I needed to be able to see what tables I was accessing from two different dbs. Initially I was looking for an ERD tool but I stumbled across the successor to CocoaMysql, Sequel Pro. It’s both well executed and free which makes it my kind of app!
A nice trick for having screen open a new tab in the same directory as the one you’re currently in. To use it add it to your .screenrc
# Open new window in current dir.
bind c stuff "screen -X chdir \$PWD;screen^M"
bind ^c stuff "screen -X chdir \$PWD;screen^M"
Hat tip: mteckert on SuperUser.com
When you’re using a minimal Ubuntu install if you find the ‘add-apt-repository’ command is missing (it’s useful for adding PPAs and other repositories), then simply run:
sudo apt-get install python-software-properties
© Copyright 2004-12 Stuart Colville, all rights reserved. May contain traces of Muffin. Powered by WordPress. Hosting by Slicehost.com This page was baked in 0.467s.
I’ve also been using Sequel Pro for the last month or so. Apart from the occasional UI glitch whereby the main ‘content’ pane gets messed up until you flick to another tab and back, it’s been working very nicely.
My favourite feature (which wasn’t in the version of CocoaMysql I was using) is Copy Create Table Syntax from the Table menu. This generates the SQL CREATE TABLE statement required to create that table on another copy of the database, and puts it on your clipboard.
have you found an ERD tool btw.?
@matths: No kind of got side-tracked there on that one. Any suggestions, or are you looking for one as well?
Anyone have experience connecting Sequel Pro to a DB on Slicehost?
@jojo: The way to do this is to tunnel the connection via ssh.
See: http://www.whoopis.com/howtos/mysql_ssh_howto.html when the tunnel is up and running you can just connect sequel pro to the local end of the tunnel.