Copyright © ashik rahman's Blog
Showing posts with label magento. Show all posts
Showing posts with label magento. Show all posts

Tuesday, August 14, 2012

How to move Magento shop to another host?

IN Your Old Server:

1. Take the Dump MySQL database.
2. Take the backup files from your public_html

IN Your New Server:

1.Make a New Database, User, Pass in you phpmyadmin
2.Before loading the database file execute these Lines in SQL form the phpmyadmin:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 
 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;

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;

3.Import you Dumped MySQL database.
4. Go to table named "core_config_data" And change the records with these values in “path” column:
                                >web/unsecure/base_url --> http://www.your-domain-name.com
>web/secure/base_url --> --> http://www.your-domain-name.com
5. Upload the zip / tar back-up files to public_html in your new server And unzip.
6. last of all Just change this file: public_html/app/etc/local.xml with the credential of Database info and username, Password.

that's it.