Developers: Moving Magento from development to live server

Check Server Compatible Magento

In order to run Magento your server needs to meet some basic software requirements. For a complete list of system requirements please reference the System Requirements page.
You can test your server for compatibility by following these simple steps:

Download this file : http://imanalicse.blogspot.com/2014/12/magento-checkphp.html
Upload the extracted magento-check.php file to the Magento directory on your server
In your browser navigate to this page: magento/magento-check.php

Move Project files to Live Server

clear the /var/cache/* and /var/session/* directory

Set the correct permissions for magento files and folders

Once you finished with the copying then you should set the correct permissions for magento files and folders as
/var and contents should have permissions “777″
/media and contents should have permissions “777″
/app/etc and contents should have permissions “777″

Update local.xml with the new configuration details

You can find your local.xml file in the app/etc directory.
Look through the file until you see the database connection information. If will look similar to the following:

<default_setup>

  <connection>

     <host><![CDATA[localhost]]></host>

     <username><![CDATA[my_user]]></username>

     <password><![CDATA[my_pass]]></password>

     <dbname><![CDATA[my_database]]></dbname>

     <active>1</active>

  </connection>

</default_setup>

Then change the values in the square brackets after the CDATA tags to your new database server settings, for example:

<username><![CDATA[mynewusername]]></username>

Once done, save the file.

Import Development Mysql database to Live Server

After making above changes to .SQL file, Do few more changes to your .SQL file before importing. these changes will fix the issue of MySQL foreign key constraint.
So open your .SQL file and do the following changes.
Place below lines of MYSQL code on very top of the .sql file:

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT; 

SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS; 

SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION; 

SET NAMES utf8; 

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; 

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; 

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=`NO_AUTO_VALUE_ON_ZERO`; 

SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

Place below lines of MYSQL code on very end of the .SQL file:

SET SQL_MODE=@OLD_SQL_MODE; 

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; 

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; 

SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT; 

SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS; 

SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION; 

SET SQL_NOTES=@OLD_SQL_NOTES;

Update the live site URL data in the database

This needs to be done in two places in the database. Using PHPMyAdmin, select the table named core_config_data and locate the following database rows:

UPDATE core_config_data SET VALUE="http://newhostsite.com/"  WHERE path="web/unsecure/base_url";

UPDATE core_config_data SET VALUE="http://newhostsite.com/"  WHERE path="web/unsecure/base_url";

//Where “newhostsite.com” is a new server domain name.

Magento database script to delete all test data, Order, Customer Data from database

Remove Test customers

SET FOREIGN_KEY_CHECKS=0;

-- Customers

TRUNCATE `customer_address_entity`;

TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

-- Search

TRUNCATE `catalogsearch_query`;

TRUNCATE `catalogsearch_fulltext`;

TRUNCATE `catalogsearch_result`;

ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1;

ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1;

ALTER TABLE `catalogsearch_result` AUTO_INCREMENT=1;

-- Polls

TRUNCATE `poll`;

TRUNCATE `poll_answer`;

TRUNCATE `poll_store`;

TRUNCATE `poll_vote`;

ALTER TABLE `poll` AUTO_INCREMENT=1;

ALTER TABLE `poll_answer` AUTO_INCREMENT=1;

ALTER TABLE `poll_store` AUTO_INCREMENT=1;

ALTER TABLE `poll_vote` AUTO_INCREMENT=1;

-- Reports

TRUNCATE `report_viewed_product_index`;

ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Remove Test orders

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `sales_flat_creditmemo`;

TRUNCATE `sales_flat_creditmemo_comment`;

TRUNCATE `sales_flat_creditmemo_grid`;

TRUNCATE `sales_flat_creditmemo_item`;

TRUNCATE `sales_flat_order`;

TRUNCATE `sales_flat_order_address`;

TRUNCATE `sales_flat_order_grid`;

TRUNCATE `sales_flat_order_item`;

TRUNCATE `sales_flat_order_status_history`;

TRUNCATE `sales_flat_quote`;

TRUNCATE `sales_flat_quote_address`;

TRUNCATE `sales_flat_quote_address_item`;

TRUNCATE `sales_flat_quote_item`;

TRUNCATE `sales_flat_quote_item_option`;

TRUNCATE `sales_flat_order_payment`;

TRUNCATE `sales_flat_quote_payment`;

TRUNCATE `sales_flat_quote_shipping_rate`;

TRUNCATE `sales_flat_shipment`;

TRUNCATE `sales_flat_shipment_item`;

TRUNCATE `sales_flat_shipment_grid`;

TRUNCATE `sales_flat_shipment_track`;

TRUNCATE `sales_flat_invoice`;

TRUNCATE `sales_flat_invoice_grid`;

TRUNCATE `sales_flat_invoice_item`;

TRUNCATE `tag`;

TRUNCATE `tag_relation`;

TRUNCATE `tag_summary`;

TRUNCATE `wishlist`;

TRUNCATE `report_event`;

TRUNCATE `catalogsearch_fulltext`;

-- Reports

TRUNCATE `sales_bestsellers_aggregated_daily`;

TRUNCATE `sales_bestsellers_aggregated_monthly`;

TRUNCATE `sales_bestsellers_aggregated_yearly`;

TRUNCATE `sales_invoiced_aggregated`;

TRUNCATE `sales_invoiced_aggregated_order`;

TRUNCATE `sales_order_aggregated_created`;

TRUNCATE `sales_order_aggregated_updated`;

TRUNCATE `sales_refunded_aggregated`;

TRUNCATE `sales_refunded_aggregated_order`;

TRUNCATE `sales_shipping_aggregated`;

TRUNCATE `sales_shipping_aggregated_order`;

TRUNCATE `coupon_aggregated`;

TRUNCATE `review`;

TRUNCATE `review_detail`;

TRUNCATE `review_entity_summary`;

TRUNCATE `rating_store`;

ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;

ALTER TABLE `tag` AUTO_INCREMENT=1;

ALTER TABLE `tag_relation` AUTO_INCREMENT=1;

ALTER TABLE `tag_summary` AUTO_INCREMENT=1;

ALTER TABLE `wishlist` AUTO_INCREMENT=1;

ALTER TABLE `report_event` AUTO_INCREMENT=1;

ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1;

TRUNCATE `eav_entity_store`;

ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Log Cleaning

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `log_customer`;

TRUNCATE `log_visitor`;

TRUNCATE `log_visitor_info`;

TRUNCATE `log_visitor_online`;

TRUNCATE `log_quote`;

TRUNCATE `log_url`;

TRUNCATE `log_url_info`;

TRUNCATE `sendfriend_log`;

ALTER TABLE `log_customer` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_online` AUTO_INCREMENT=1;

ALTER TABLE `log_quote` AUTO_INCREMENT=1;

ALTER TABLE `log_url_info` AUTO_INCREMENT=1;

ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Reindex the data

Go to the admin panel. Click on the “Index Management” under “System”. Select all rows and reindex data.

Reset admin pssword

If you forget your admin password for Magento and you can’t remember the email or just want quick fix you can use one line of SQL to sort that issue out.

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

All you have to do is replace the “password” with your required one and run the query.

ERROR

cache_dir

This tutorial shows how to resolve the " Could not determine temp directory, please specify a cache_dir manually " error message in Magento. This error sometimes ossurs when you are trying to access some areas of the Magento admin panel.
1) Open Magento root directory and create tmp folder.
2) Set directory permissions to 777 or 755
2) Open “lib/Zend/Cache/Backend/File.php“, and locate the following code

protected $_options = array(

‘cache_dir’ => null,

replace with

protected $_options = array(

‘cache_dir’ => ‘tmp’,

Developers

Pages

Moving Magento from development to live server