Magento website is redirecting to old url.

I have transfered my magento website from one server to another server.
After installed that in new server, My magento website is redirecting to old url. This is the Issue.

To clear this
just follow these steps:

your host/phpmyadmin

1. Select your database
2. Find core_config_data table in that
3. Change the secure and unsecure urls here, which is https://www.domain.com/   This is your new website url.  
4. Refresh Your page.

Import & Export all products using csv file (without extension)

If you want to import all products to your website, just follow the following instructions.

1. First of all, create all categories and create one product in your website,
2. After this, export that data and keep that with you.
3. Now arrange the data which you want to import, that total have to be arrange in the format of your exported data.
4. After arranged you can easily import the data into your website which you want to import newly in usual manner.
5. Then go to system > import/Export > Data flows > Follow that rules.

Magento site is in maintenance mode

Website is in maintenance mode Or temporarily unavailable problem is common in magento, No need to worry.

To clear this,
From your Root folder  find and delete the file name maintenance.flag After refresh your homepage or admin page.

Now your website works as usually.

Delete all Orders, Sales & Customer Data in Magento

I have tested this and worked for me on my server.
Tested on Magento CE 1.4.1.1 - 1.9.1.1
Just run this sql.



SET FOREIGN_KEY_CHECKS=0;

##############################
# SALES RELATED TABLES
##############################
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;
TRUNCATE `sales_flat_invoice_comment`;
TRUNCATE `sales_flat_invoice_grid`;
TRUNCATE `sales_flat_invoice_item`;
TRUNCATE `sales_flat_order`;
TRUNCATE `sales_flat_order_address`;
TRUNCATE `sales_flat_order_grid`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sales_flat_order_payment`;
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_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_shipment`;
TRUNCATE `sales_flat_shipment_comment`;
TRUNCATE `sales_flat_shipment_grid`;
TRUNCATE `sales_flat_shipment_item`;
TRUNCATE `sales_flat_shipment_track`;
TRUNCATE `sales_invoiced_aggregated`;            # ??
TRUNCATE `sales_invoiced_aggregated_order`;        # ??
TRUNCATE `log_quote`;

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_invoice` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_comment` 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_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_payment` 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_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_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;

#########################################
# DOWNLOADABLE PURCHASED
#########################################
TRUNCATE `downloadable_link_purchased`;
TRUNCATE `downloadable_link_purchased_item`;

ALTER TABLE `downloadable_link_purchased` AUTO_INCREMENT=1;
ALTER TABLE `downloadable_link_purchased_item` AUTO_INCREMENT=1;

#########################################
# RESET ID COUNTERS
#########################################
TRUNCATE `eav_entity_store`;
ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;


##############################
# CUSTOMER RELATED TABLES
##############################
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`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `tag_properties`;            ## CHECK ME
TRUNCATE `wishlist`;
TRUNCATE `log_customer`;

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;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `tag_properties` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_customer` AUTO_INCREMENT=1;


##############################
# ADDITIONAL LOGS
##############################
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;
TRUNCATE `report_event`;
TRUNCATE `report_viewed_product_index`;
TRUNCATE `sendfriend_log`;
### ??? TRUNCATE `log_summary`

ALTER TABLE `log_url` AUTO_INCREMENT=1;
ALTER TABLE `log_url_info` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;
ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
### ??? ALTER TABLE `log_summary` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Adding the list of states in India to Magento

I have tested this and worked for me on my server : 

INSERT INTO `directory_country_region` VALUES

(NULL , "IN", "Andaman and Nicobar","Andaman and Nicobar"),

(NULL , "IN", "Andhra Pradesh","Andhra Pradesh"),

(NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"),

(NULL , "IN", "Assam","Assam"),

(NULL , "IN", "Bihar","Bihar"),

(NULL , "IN", "Chandigarh","Chandigarh"),

(NULL , "IN", "Chhattisgarh","Chhattisgarh"),

(NULL , "IN", "Dadra and Nagar Haveli","Dadra and Nagar Haveli"),

(NULL , "IN", "Daman and Diu","Daman and Diu"),

(NULL , "IN", "Delhi","Delhi"),

(NULL , "IN", "Goa","Goa"),

(NULL , "IN", "Gujarat","Gujarat"),

(NULL , "IN", "Haryana","Haryana"),

(NULL , "IN", "Himachal Pradesh","Himachal Pradesh"),

(NULL , "IN", "Jammu and Kashmir","Jammu and Kashmir"),

(NULL , "IN", "Jharkhand","Jharkhand"),

(NULL , "IN", "Karnataka","Karnataka"),

(NULL , "IN", "Kerala","Kerala"),

(NULL , "IN", "Lakshadweep","Lakshadweep"),

(NULL , "IN", "Madhya Pradesh","Madhya Pradesh"),

(NULL , "IN", "Maharashtra","Maharashtra"),

(NULL , "IN", "Manipur","Manipur"),

(NULL , "IN", "Meghalaya","Meghalaya"),

(NULL , "IN", "Mizoram","Mizoram"),

(NULL , "IN", "Nagaland","Nagaland"),

(NULL , "IN", "Orissa","Orissa"),

(NULL , "IN", "Pondicherry","Pondicherry"),

(NULL , "IN", "Punjab","Punjab"),

(NULL , "IN", "Rajasthan","Rajasthan"),

(NULL , "IN", "Sikkim","Sikkim"),

(NULL , "IN", "Tamil Nadu","Tamil Nadu"),

(NULL , "IN", "Tripura","Tripura"),

(NULL , "IN", "Uttar Pradesh","Uttar Pradesh"),

(NULL , "IN", "Uttaranchal","Uttaranchal"),

(NULL , "IN", "West Bengal","West Bengal");

  

INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` )

    SELECT 'en_US', tmp.region_id, tmp.default_name FROM `directory_country_region`

        AS tmp WHERE tmp.country_id='IN';