This is my first guide in moving Magento site to another site or server. I’ve completed few Magento site transfers as we recently develop and host Magento sites. I also encountered several issues in transferring sites, and searched for different approaches from other blog/forum sites, such as installing a new Magento instance on destination server. I checked the official Magento guide in moving site but I haven’t tried it yet since my current process works fine. This is similar to my procedures when moving other sites such as Oscommerce, Drupal, Wordpress, etc. I assume you have ssh access to your server.
Export/dump source database. You can do it via Phpmyadmin or using mysqldump from command line.
Update your database dump file before importing to destination database. You need to change the referrences to source url/domain, path/home directory, database details such as database name in case you have tables that referrence to other tables (foriegn keys etc). You can edit your sql file or dump file with your editor and do the search and replace. For me i do this directly using perl/sed.
Import your modified database dump to destination database using phpmyadmin or via command line.
Copy all of Magento files to your destination site or server and preserve attributes
Empty contents of
Same process with database, update references to url, path, database details, and other variables that
differs from your source and destination server (ex: db host). Ex:
1 2 3 4 5
media/ directories are world-writable (777)
That’s all check your new site and watch out if there are links coming from your old url.