Once you have altered the choices above you should restore the database at the new area.
A great practice is to create several options in the MySQL backup data file before uploading it. The next should be included at the beginning of the SQL file:
Now you can import the database by using phpMyadmin tool -> Import or another MySQL tool based on what kind of access you need to the website.
If you want to reestablish the database by using a shell command you can use as follows:
mysql -h HOST -u USER -p DATABASENAME < FILENAME.sql
and get into the password for the database user if asked.
Remember that if the Magento online shop is expected to work with a various domain name at the new place you should modify the entries for it in the MySQL database.
The table you ought to change is core_config_data as well as the values you need to alter are in the path column. Modify theweb/unsecure/base_url and web/secure/base_url to match the new domain name by changing the value column for both information.
The final step is to clear the Magento cache. You may do this either by using the Magento admin panel > System > Cache management or through deleting the items of the var/cache and var/session folders within your Magento installation directory.
That is all. Your Magento should now be properly functioning at the new location.