Moving Magento site from development server to live server

Recently I faced problem to move magento site from local (LAMP) environment to web server. I am posting steps to upload site on server.

1. Make tar / zip of code.

$ tar -cvvf site.tar /opt/lampp/magento/

2. Take backup of database through phpmyadmin. Check “Disable foreign key checks” to avoid error in restore process.

3. Open backup sql file and add following

In beginning

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;

and following in the end of 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;

4. Upload tar / zip file on web server, extract and deploy. Don’t forget to clear cache (Clear /var/cache and /var/session directories).

tar -xvvf site.tar

5. Change /var permission to 777 recursively.

$ chmod 777 /home/magento/htdocs/var

6. Restore database on server through phpmyadmin.

7. Change mysql database setting in

/app/etc/local.xml

<connection>
<host><![CDATA[localhost]]></host>
<username><![CDATA[database_username]]></username>
<password><![CDATA[database_password]]></password>
<dbname><![CDATA[database_name]]></dbname>
<active>1</active>
</connection>

8. Run website.

If you are getting blank page then check the following

1. Mysql Database setting.

2. Did you clear cache?

3. Followed step3?

If you are getting Undefined index 0 Error then check the following

1. Did you followed step3?

2. Or you can manually run these queries

UPDATE `magento`.`core_website` SET `website_id` = ‘0’ WHERE `core_website`.`code` = ‘admin’  LIMIT 1 ;

UPDATE `magento`.`core_store` SET `store_id` = ‘0’ WHERE `core_store`.`code` = ‘admin’ LIMIT 1 ;

Clear cache as you make any change.

Advertisements

Swine flue GOVERNMENT AUTHORIZED HOSPITALS – India

image001

SYMPTOMS

  • fever, which is usually high, but unlike seasonal flu, is sometimes absent
  • cough
  • runny nose or stuffy nose
  • sore throat
  • body aches
  • headache
  • chills
  • fatigue or tiredness, which can be extreme
  • diarrhea and vomiting, sometimes, but more commonly seen than with seasonal flu.

Signs of a more serious swine flu infection might include pneumonia and respiratory failure

GOVERNMENT AUTHORIZED HOSPITALS FOR TREATMENT OF SWINE FLU

City Hospital Address Contact
Chennai King Institute of Preventive Medicine (24/7 Service) Guindy, Chennai – 32 (044) 22501520, 22501521 & 22501522
Communicable Diseases Hospital Thondiarpet, Chennai (044) 25912686/87/88, 9444459543
Government General Hospital Opp. Central Railway Station, Chennai – 03 (044) 25305000, 25305723, 25305721, 25330300
Pune Naidu Hospital Nr Le’Meridian, Raja Bahadur Mill, GPO, Pune – 01 (020) 26058243
National Institute of Virology 20A Ambedkar Road , Pune – 11 (020) 26006290
Kolkata ID Hospital 57,Beliaghata, Beliaghata Road , Kolkata – 10‎ (033) 23701252
Coimbatore Government General Hospital Near Railway Station,
Trichy Road, Coimbatore – 18
(0422) 2301393, 2301394, 2301395, 2301396
Hyderabad Govt. General and Chest Diseases Hospital , Erragadda, Hyderabad (040) 23814939
Mumbai Kasturba Gandhi Hospital Arthur Road, N M Joshi Marg, Jacob Circle , Mumbai – 11 (022) 23083901, 23092458, 23004512
Sir J J Hospital J J Marg, Byculla, Mumbai – 08 (022) 23735555, 23739031, 23760943, 23768400 / 23731144 / 5555 / 23701393 / 1366
Haffkine Institute Acharya Donde Marg, Parel, Mumbai – 12 (022) 24160947, 24160961, 24160962
Kochi Government Medical College Gandhi Nagar P O, Kottayam – 08 (0481) 2597311,2597312
Government Medical College Vandanam P O, Allapuzha – 05 (0477) 2282015
Taluk Hospital Railway Station Road , Alwaye, Ernakulam (0484) 2624040  Sathyajit – 09847840051
Taluk Hospital Perumbavoor PO , Ernakulam 542 (0484) 2523138  Vipin – 09447305200
Gurgaon &
Delhi
All India Institute of Medical Sciences (AIIMS) Ansari Nagar, Aurobindo Marg Ring Road , New Delhi – 29 (011) 26594404, 26861698 Prof. R C Deka – 9868397464
National Institute for Communicable Diseases 22, Sham Nath Marg,
New Delhi – 54
(011) 23971272/060/344/524/449/326
Dr. Ram Manohar Lohia Hospital Kharak Singh Marg,
New Delhi – 01
(011) 23741640, 23741649, 23741639
Dr. N K Chaturvedi
9811101704
Vallabhai Patel Chest Institute University Enclave, New Delhi- 07 (011) 27667102, 27667441, 27667667, 27666182
Bangalore Victoria Hospital K R Market, Kalasipalayam, Bangalore – 02 (080) 26703294  Dr. Gangadhar – 94480-49863
SDS Tuberculosis & Rajiv Gandhi Institute of Chest Diseases Hosur Road, Hombegowda Nagar, Bangalore – 29 (080) 26631923  Dr. Shivaraj – 99801-48780


STAY ALERT! PREVENT AGAINST SWINE FLU

VISA MasterCard SecureCode

The Reserve Bank of India (RBI) has mandated that from 1st Aug 2009 all online credit card transactions require an extra level of verification. Your credit card issuing banks are therefore, implementing a “Verified by VISA” or “MasterCard SecureCode” password. You will need this password to continue transacting online from 1st Aug 2009.
What is the “Verified by VISA”/”MasterCard SecureCode” password?
This is the password that your credit card issuing Bank provides. This password is the additional layer of security for all your online transactions.

Benefits of “Verified by VISA”/”MasterCard SecureCode” password
Even if you lose / misplace your credit card it cannot be misused online as the password is not present on the card.

Remember:
Keep your password safe.
Do not share your password with anyone

Apply Here

Source: eBay.in

DISQUS: Aggregate your comments over the web!

DISQUS is a great service to aggregate your comments all over the web. If you add a comment on a blog / website which is using this system, your comment will be visible in to your DISQUES account as well in post. This way you can keep track of your all comments. Another cool feature is, you can subscribe comment RSS.

For webmasters, It is extremely easy and installed in 5 minutes. There is a plugin available for DISQUS. I recently integrated it into myblog and it took hardly 5 minutes!

Try this and I am sure you will like it!!

cheers 🙂

Do you think it is safe to make transaction on the Internet?

Bangalore: Hosting company and domain registrar Network Solutions has disclosed the data security breach of nearly 6,00,000 credit card holders by malware on a server. The company has notified 4,343 of its nearly 10,000 e-commerce merchant customers about the breach, said Roy Dunbar, Chairman and CEO of Network Solutions. Read full story

Make free internet calls (Google, skype, MSN, SIP, WeFi) from your mobile

Symbian Smart Phones are very popular these days. A lot of hot applications are in market for symbian platform. Thanks to Nokia for creating this platform. Now I am going to tell you about a very useful application of smart phone, If you are a freelancer (like me), CEO and other marketing executive, have to remain online all the time for customer inquiries, then I am sure you will like this application.

Go to http://www.fring.com/ download in install application in your phone. Run this application. It will ask you for permissions, allow all permissions and continue. Now you will be asked for subscription Skype, Gtalk, MSN etc, select desired services and enter login details. Done!

Now you can call buddies from fringe. The call quality is very goon even in EDGE network. Few fetures are as follows

  • Voice calls and chat over 3G and Wi-Fi
  • Skype and Google Talk integration (Voice and Chat)
  • History (Missed calls, Incoming/Outgoing calls)
  • Good voice quality

Hope you will enjoy fringe. Don’t forget to call me my ID is abhinavzone