WDH: Magento

<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Follow these steps to transfer Magento from one account to another:</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjE3Kh6PvRJLYpLIVeOdUeUrRdGsEux7nuBT9bDuBj6oXXSiorXir-Qd__UK9c2ZA360nIa_hzAEZb-XIVjnl9AXTsovzLrGybjvJzakb_FsxDDVlPth5rf9eWY20HFwoWrJPHC6ApV12E/s1600/magentologo.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="magento" border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjE3Kh6PvRJLYpLIVeOdUeUrRdGsEux7nuBT9bDuBj6oXXSiorXir-Qd__UK9c2ZA360nIa_hzAEZb-XIVjnl9AXTsovzLrGybjvJzakb_FsxDDVlPth5rf9eWY20HFwoWrJPHC6ApV12E/s1600/magentologo.jpg" title="magento" width="320" /></a></div>
<br />
<ul style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 1: Backup the Magento MySQL Database</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 2: Transfer all Magento Files</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 3: Adjust the Magento Configuration</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 4: Restore the Magento Database</li>
</ul>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
STEP 1 Backup the Magento MySQL Database<br />
<br />
On SiteGround servers you have phpMyAdmin included by default in cPanel for your account. In other cases you will have to use the same tool or a similar one that is capable of exporting your MySQL database. Detailed information on how to perform a MySQL backup can be found in our MySQL Tutorial.<br />
<br />
Alternatively, if you don’t have phpMyAdmin installed but you have shell access you can use the mysqldump tool. The syntax is as follows:<br />
<br />
mysqldump -h HOST -u USER -p DATABASENAME > FILENAME.sql<br />
where:<br />
<br />
HOST is the database server hostname or it can be omitted if you are running the MySQL server locally<br />
USER - a user with full privileges to the Magento database<br />
DATABASENAME - is the full name of the database which Magento is running<br />
FILENAME - can be anything you find suitable for the backup file<br />
Also, if you have Plesk, DirectAdmin or any other web hosting management tool, you can look at the available options. Many panels allow you to dump the database with just a few clicks. For example cPanel does have an option for this.<br />
<br />
STEP 2 Transfer all Magento Files<br />
<br />
You will need to <span class="IL_AD" id="IL_AD1" style="background-attachment: scroll !important; background-clip: initial !important; background-color: transparent !important; background-image: none !important; background-origin: initial !important; background-position: 0% 50%; background-repeat: repeat !important; background-size: initial !important; border-bottom-color: rgb(103, 176, 69) !important; border-bottom-style: dotted !important; border-bottom-width: 1px !important; color: rgb(103, 176, 69) !important; cursor: pointer !important; display: inline !important; float: none !important; padding: 0px 0px 1px !important; position: static;">download all</span> files from your current store and upload them to the new location. This can be a time consuming task considering that a standard Magento installation consists of many files. A good alternative is to archive the files prior to downloading/uploading them if possible.<br />
<br />
If you have SSH access you can log on your server -> magento installation directory and archive all the files using the following command:<br />
<br />
tar -czif ARCHIVENAME.tar.gz<br />
This will create a tarball archive of all the files in the directory.<br />
<br />
You can then download the archive and easily upload it to the new location. To extract it at the new location use the following command in the desired destination folder for the Magento installation:<br />
<br />
tar -xzif ARCHIVENAME.tar.gz<br />
STEP 3 Adjust the Magento Configuration<br />
<br />
After the files are restored you should alter the configuration file in order to match the new settings. All you need to change here is the database details at the new location. Those are stored in the app/etc/local.xml file. The lines you need to alter are:<br />
<br />
<host><![CDATA[HOSTNAME]]></host><username><![CDATA[USER]]></username><password><![CDATA[PASSWORD]]></password><dbname><![CDATA[DATABASENAME]]></dbname><br />
where:<br />
<br />
HOSTNAME should be the database hostname, most commonly - localhost<br />
USER is a user that has full privileges to the database<br />
PASSWORD is the password for the database user<br />
DATABASENAME is the complete database name for the database you are going to use with the transferred Magento<br />
STEP 4 Restore the Magento Database<br />
<br />
Once you have adjusted the options above you should restore the database at the new location.<br />
<br />
A good practice is to add several options in the MySQL backup file prior to uploading it. The following should be added at the beginning of the SQL file:<br />
<br />
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;<br />
The next option should be added at the end of the file after all other queries:<br />
<br />
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;<br />
You can now import the database using phpMyadmin -> Import or another MySQL tool depending on what kind of access you have to the website.<br />
<br />
In case you would like to restore the database via a shell command you can use the following:<br />
<br />
mysql -h HOST -u USER -p DATABASENAME < FILENAME.sql<br />
and enter the password for the database user when asked.<br />
<br />
Note that if the Magento online store is supposed to work with a different domain name at the new location you should alter the entries for it in the MySQL database.<br />
<br />
The table you should edit is core_config_data and the values you need to change are in the path column. Change the web/unsecure/base_url and web/secure/base_url to match the new domain name by altering the value column for both records.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH0ymbqn3NuYv_1iwjUhGXqPInsBY8-InCs3MGhMXejrdfKFun8MQW1L1QmK5B7jFufjps5CAKa9UlpHNWAAEskdmbUIGJ379UMFv30qeYoEtQcVdvemcPpqJEf0XtjzuSYdWUfIVchfci/s1600/magentomove01.jpg" imageanchor="1" style="color: #771100; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH0ymbqn3NuYv_1iwjUhGXqPInsBY8-InCs3MGhMXejrdfKFun8MQW1L1QmK5B7jFufjps5CAKa9UlpHNWAAEskdmbUIGJ379UMFv30qeYoEtQcVdvemcPpqJEf0XtjzuSYdWUfIVchfci/s1600/magentomove01.jpg" style="border: none; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
The last step is to clear the Magento cache. You can do this either via the Magento admin panel > System > Cache management or by deleting the contents of the var/cache and var/session folders inside your Magento installation directory.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
That is all. Your Magento should now be properly functioning at the new location.</div>
</div>
</div>

Move your Magento site from one hosting account to another

Follow these steps to transfer Magento from one account to another: Step 1: Backup the Magento MySQL Database Step 2: Transfer all Ma...

Move your Magento site from one hosting account to another

Magento's database configuration file