Are there any considerations involved with migrating an installation from one server to another besides tarring the entire folder and dumping it onto the new server and then exporting/importing the sql table?
this is a very new open source commerce solution, but i may say if you are changing servers and the servers are not within the same hosting company or your hosting company has there reasons not to do a seemless migration. This has nothing to do with magento. Or maybe you have worded your question incorrectly.
I’m not complaining or anything. I’m just asking if this is doable.
Yes im sure its do-able but only by what you have said prevously. To move any database from one server to another be it Joomla or Magento the backup and restore of folders and database are the sound solution.
@garyhe: before importing database dump to new database make sure to run these statements first:
SET SQL_MODE=''; 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';
After import run these to restore original modes:
SET SQL_MODE=IFNULL(@OLD_SQL_MODE,''); SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS,0);
I follow the advice from Moshe and migrate Magento from server to localhost. But when I click the link in the localhost home page, it goes back to the original server not the localhot. Do you have any idea how to fix this problem?
Problem solved: change the base_url from http://www.epacificweb.com to /localhost/magento in sql file, then import the sql file to the local machine.
Sales: Call 877.832.5289 (N America)|310.295.4144 (International)
