Unable to change theme colour in Magento

"What you can do is check that settings is not overrided on different scope level like website or store view
Scope switch is located in top left corner of Configuration page
More info about scopes - http://queldorei.com/faq.html#basic_6"

Command to login ssh

You may not be able to unzip a file via ftp.

Log into ssh using
ssh username@serverName.com
then unzip

Where do I add a Meta tag for Magento?

Just edit app\design\frontend\default\default\template\page\html\head.phtml and add the custom meta tags in there. Or maybe the path is different if you set up a new template for your website (maybe app\design\frontend\yourtemplate\default\template\page\html\head.phtml)
or
Please go to System > Configuration > Design > Html Head and edit “Miscellaneous scripts” field. Unfortunately this works only for static information / meta-tags.


See more about SEO on Magento:
http://www.screenpages.com/about/articles/seo-in-magento

What file contained these SQL database connection variables in Magento?

 /app/etc/local.xml

Start the FTP Server in OS X

Start the FTP Server in OS X

This will start a generic FTP and FTPS server on the Mac, but not an SFTP server:

• Launch the Terminal (/Applications/Utilities) and enter the following command to start the FTP server:
sudo -s launchctl load -w /System/Library/LaunchDaemons/ftp.plist
• Confirm the FTP server works by typing:
ftp localhost


Create an FTP user and set up an FTP password

Transfer a zip file via FTP

Open CyberDuck

type in ftp serverName 

Enter your userName

Enter your password

Navigate to your file on your local drive: lcd /Users/UserName/Downloads/xxx/

Upload your zip file in the above directory: Put fileName.zip

Your file will then be uploaded to your ftp server
Go to ssh on terminal, login, type in unzip filename.zip

* Do a 'ls' on your server directory

Files will have a dash (-) as the first character in the leftmost column and folders will have a d listed (the d stands for directory). 
* Common Commands

put filename - Upload a file to the server

get filename - Download a file from the server

mput filename - Put multiple files on the server

mget filename - Get multiple files on the server

ls - Get a list of files in the current directory

cd - Change directory

quit - Ends your ftp session

Move entire content from a folder

* You can also use mv to move a whole directory and its content:

mv includes/* ./

This will move all files (and folders) in the includes/ directory to the current working directory.

How to - Migrate Magento manually

You will need
1. A fresh Magento template folder
2. Existing Magento sql file
3. Existing Magento Media folder

1. Create a Database
2. Import the existing SQL file or run all the SQL commands in myphpadmin
3. Install Magento
4. Copy the entire media folder and replace the content in your existing media directory