> SequelPro is amazing and I used it for many many years.
Seconded.
I inherited an old MySQL/Java system and SequelPro was invaluable to understanding how it worked and keeping it running. At least until I added
a view to the schema, the export/import facility was also very effective at taking and restoring snapshots of the database state. I could connect it to production, pull down an exported SQL script and then restore exactly that state to another environment. (Including local.)
(And given that it ran in OSX, it also had a plausible subset of Emacs keybidings too. :-) )
Seconded.
I inherited an old MySQL/Java system and SequelPro was invaluable to understanding how it worked and keeping it running. At least until I added a view to the schema, the export/import facility was also very effective at taking and restoring snapshots of the database state. I could connect it to production, pull down an exported SQL script and then restore exactly that state to another environment. (Including local.)
(And given that it ran in OSX, it also had a plausible subset of Emacs keybidings too. :-) )