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

Magento - Complains missing InnoDB when it is available

Navigate within your Magento Folder

Replace:

public function supportEngine()
    {
        $variables  = $this->_getConnection()
            ->fetchPairs('SHOW VARIABLES');
        return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;
    }

with

public function supportEngine()
    {
        $variables  = $this->_getConnection()
            ->fetchPairs('SHOW ENGINES');
        return (isset($variables['InnoDB']) && $variables['InnoDB'] != 'NO');
    }

Increase Size of import SQL File in phpmyadmin

Modify php.ini

Open text pad, enter


Save as .php on your local machine
Navigate to this file using any Browser
Find

Configuration File (php.ini) Path

/usr/local/php5/lib

Open Terminal
Paste: nano /usr/local/php5/lib/php.ini

Modify output buffering
search for "output_buffering" without the quotation mark
change the value to on
restart apache service

Find: (Ctrl + W)
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Restart Apache service: sudo apachectl restart