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