How to migrate your magento installation from remote host to local host
This is an old revision of the document!
Here I take the migration from my remote host to my XAMPP local test environment for example, because I first installed magento at my remote host then I want to develope it at my hard drive for convenience and speed. Some remote hosting company provides script installer and it is faster to install magento with it.
1. Always create database dump from the magento backend / admin panel >System >Tools >backups >Create Backup, and then download the dump file by clicking on the “gz”. Save the dump file in a place and no need to extract it.
Create a database from phpmyadmin and import the dump.
Note: Sometimes the dump can’t be imported successfully, then you need to repeat the above.
2. Enter the file manager from the cpanel, and compress the magento folder into zip file.
My installation is under www.mydomain.com/magento/ folder, so I created a magento.zip in the root folder. I downloaded it to my hard drive, too.
Now you can extract the file structure to the local XAMPP environment. I extracted to C:xampphtdocsmagento.
3. Open C:windowssystem32driversetchosts and insert the following lines: 127.0.0.1 www.mydomain.com mydomain.com
4. Go to C:xampphtdocsmagentovar and delete all files in this folder.
5. Go to C:xampphtdocsmagentoappetc and delte use_cache.ser
6. Open C:xampphtdocsmagentoappetclocal.xml and update the following settings: dbuser - by default is root, dbname - the database you created in step 1, pass - by default is blank.
Everything is done! Note: you can now enter your local test website by entering www.mydomain.com/magento in the ie address bar.