Navicat - MySQL Web GUI interface

I've been using SQLyog for years now on my PC. When I switched to a Mac I had to install Parallels so I could boot up XP and use SQLyog because I can't stand PHPmyadmin.

So I tried installing SQLyog today and setting up my db connections. However, I ran into a problem when both of my connections required ssh tunneling. the first connection would work fine, but then when i closed the connection to the first db on one server, and then tried to connect to the db on another server, i got errors. i even tried switching connections, doing the second one first, and the first one second. it didn't seem to matter which one i connected to first, the second one always failed. my theory is that the program is getting confused and tries to log into the second server with the first server's credentials, therefore the passwords are incorrect. its almost as if their are 'session' like variables that aren't getting cleared.

anyways, i stumbled upon Navicat today looking for SQLyog help on Google. its great, i can even do transfers from one db to another db, even when they are on different servers. with webyog (or PC's) you couldn't do it because only one ssh connection is allowed at a time. in fact, while i am writing this i am transferring all my db from one to another with no problems.

It's a bit pricey, but i'm glad to finally found a mac solution to webyog, who has promised for a while to come out with a mac version but has not done so yet.

Link: Navicat for Mac OSX

Trouble with Dreamweaver 8 on Mac OS X

Found out from a friend today that Dreamweaver 8 (Studio 8) is not fully compatible with Mac's new Intel based computers yet but instead is using an emulation software called Rosetta. Rosetta allows software that is PowerPC compatible to be run on the new Intel based computers. Adobe's next release of the Studio (and Photoshop3) should all be fully compatible but for now we have to make do until the new releases come out.

Been noticing my Dreamweaver has been kinda slow compared to my previous PC experience so thats why I did some research.

When buying software for Macs, look for the Universal symbol - that lets you know the application is using Apple's Xcode and means it runs natively on both the new Intel-based Mac computers and on legacy PowerPC-based Mac systems.

This PDF might be helpful - I know it was for me.

PDF from Adobe

Hope this helps some other Mac newbies out there.

How to Print Screen on a Mac

How to take a screen shot on a Mac

Cmd + Shift + 3

Your Mac should make a shutter sound - like a camera taking a picture type sound.

If you switched your Cmd key with your Ctrl key like me, then it would be:

Ctrl + Shift + 3

Hope this helps!

Cool FTP client for a Mac - Transmit

Finally found a nice FTP client for my new Mac - Transmit.

If you came from a PC like me you are probably familiar with other FTP clients like Filezilla, WSFTP or IPSwitch.

Pros:
These all pretty look the same - your PC is on the left and the server you are connecting to is on the right. I like that, am use to it, and work faster that way. And that's how Transmit is.

Other FTP clients for Mac like Fetch did not have the 2 panes and it was hard for me to adjust.

Cons:
However, Transmit is $29.95 so it is on the pricey side for an FTP client.

Link: Transmit by Panic

Money and project management software for a Mac - iBank and iBiz

Been continuing my search on the net for good Mac software ever since I switched to a Mac about 3 weeks ago.

Found 2 new good ones from IGGSoftware - iBiz and iBank

iBiz lets you define clients, define projects for a client, and then specify the work you did for that project and how much each task costs. For example, I set up a service called 'Flash'. I set up my standard Flash rate, punch in the number of hours I worked, and then it calculates the total and adds it to the project total.

iBank is a nice budget tool that helps you see what you are spending and what you are getting. It has some nice graphs, budget tools and easily lets you categorize your expenses and purchases.

I think they can be linked somehow but have not gotten that far yet. They both seem to have a ton of functions and capabilities that I have not tapped into yet.

iBank is around $40 and iBiz is $50. You can get both for $65 if you buy them together.

Ctrl+C, Ctrl+V, Ctrl+X vs. Cmd+C, Cmd+V, Cmd+X

I finally got a Mac for work but my work flow was slowing down because I could not use the same shortcuts I used on my PC.

Specifically, the beloved copy,paste and cut shortcuts, Ctrl+c, Ctrl+v and Ctrl+x, respectively.On the Mac, you can still use those shortcuts, but you have to use the Apple/Cmd key instead - its the 2 kesy that have an Apple on it - either side of the space bar.

To fix this problem, click on the Apple in the top left of your screen, > System Preferences > Keyboard and Mouse > Modifier Keys (button on the bottom of the window) and change the Ctrl key to the command key and the Cmd key to the control key. Voila!!! Now you all you old skool PC peeps like me can keep using Ctrl+c,v,x like we use to.Hope this helps.This article helped me a lot.

Link: Lifehacker Site

Password manager for Mac OS - Wallet

When I was on a PC I used Any Password. Now that I'm on a Mac Book Pro, I found a nice tool called Wallet.

Wallet was developed by Waterfall Software and they are now on version 2.6.Wallet allows you to create groups/folders, store passwords, account numbers, serial numbers, etc...you know, all that important stuff that you can't remember.

You can also sync it up with your iPod, it does backups, has a widget, autofill features and has a password generator. It is also extremely flexible where you can even create custom fields. For example, I created a folder that has the ip addresses, usernames, passwords, url links and notes for all the servers I manage.Then I created another folder that contains all the serial numbers for the software that i buy and a url link to that software supplier.

I give the Wallet 10 stars out of 10!

Link: Waterfall Software