There are 13 posts filed in Mac apps (this is page 1 of 3).
I was trying to find the quickest way to export both structure and data from all tables of a database from Navicat Premium and came up with these steps:
* Use the backup tool to create a backup of your database
* Right click the backup and select to Extract SQL…
* Save to wherever you like
You can now use that .sql file to create a new database wherever you like.
Thought it was worth sharing my current local development setup. I run on mac, currently Lion 10.7.4 and these are the pieces of software I used…
Terminal
Used to run Git version control commands. If you’re going to do it, do it properly.
Sublime Text 2
If you take handcoding seriously, ditch your coda, your skEdit, your text wrangler etc, take a weekend installing and tweaking Sublime Text 2 and never look back.
Plugins, amazing autocomplete, unlimited flexability from highlighting to layout, projects, global find, powerful search, need I go on. Beautiful.
Transmit
Superb FTP client from Panic. Don’t edit live code. Download it, run a local site, update it and then use a purpose build ftp client to get the update online. No stupid mistakes.
Sequel Pro
A powerful and free MySql tool. Lots of nice touches like edit in pop-up, tabbed browsing and nice export tools.
LiveReload
Update the preview in your browser without reloading it manually. Instant for css and js, and almost instant for html, php etc. Saves a lot of cmd-R ing.
Google Chrome
Still my the browser of choice after 2 years. Great for dev work with inspector (cmd-alt-i)
FirefoxNightly
Firefox is crap, but it’s new responsive design tools can come in handy for mobile web development. Development software, so use at your own risk.
Others worth a mention…
I also use skitch for screen capture, dropbox for file sharing, Parallels for those times when you have to test windows browsers.
Enjoy and let me know what you think in the comments…
If you own a Mac and you haven’t heard of Alfred App then you’ve likely been living in a bunker for a while.
At very least Alfred allows you to quickly start applications. If you choose to delve deeper you can use it to search and open files, run applescripts, quick jump to webpage searches, send emails, control iTunes and 999 other clever tricks.
When you first get your Mac you will likely have heard of Spotlight, a built in application that can be used to search applications and files. It’s hotkey is cmd-space. It isn’t as flexible as Alfred App but it has the best hotkey combination going.
Before we start if you’ve turned off Alfred’s menu bar icon, turn it back on in Alfred appearance preferences. It’s makes for the easiest method of opening during hotkey move.
Here is how to move Alfred App to use cmd-space and Spotlight to use ctrl-space:
System Preferences -> Keyboard -> Keyboard Shortcuts
1) In the left column click Spotlight.
2) In the right column click the current key combination for spotlight of ⌘Space (cmd-space) and input your replacement key combination. I recommend ^Space (ctrl-space) although some other applications occasionally reserve it (such as Things App). At this point if you can see it you could also switch the second hotkey combination over to ⌥^Space (alt-ctrl-space).
3) Don’t worry about remembering the old hotkeys. If you change your mind later as you can click Restore Defaults to undo your changes.
You can close system preferences now.
So we’ve moved Spotlight, but now we need to move Alfred to ⌘Space (cmd-space).
Click on Alfred’s top hat menu bar icon and select preferences. (you may need to restart Alfred at this point for it to recognise that you’ve moved Spotlight to a new hotkey.
Choose General and you should see a large box Alfred Hotkey box. Click it and press our new hotkey for Alfred App.
⌘Space (cmd-space)
And that’s it. You should now see Spotlight when you hit ^Space (ctrl-space) and Alfred when you click ⌘Space (cmd-space).
I love Postbox. I talk about it a lot. However Postbox is trying to be more than a mail client and as part of that is attempting to sneak into the world of GTD with the inclusion of todos and topics.
Now call me old fashioned but I use Things for my GTD stuff and so don’t use todos or topics in Postbox.
“Not a problem really is it?” I hear you yell. Well no until you look at the amount of space the topic row of Message View takes up. Believe me on a small screen this matters:
To backup your Postbox email profile browse to
Mac:
/Users/[username]/Library/Application Support/Postbox/Profiles
Vista:
Users\[username]\AppData\Roaming\Postbox
XP:
Documents and Settings\[username]\Application Data\Postbox
And copy the folders named xxxxxx.default to your backup location.
If you have created a new profile then your folder may also be called xxxxx.yourprofilename.
If you just want to backup your email and not your preferences or settings then go into your profile folders and backup the Imap, Mail and sometimes Local Mail folders.
