Pages

▼

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.
at