How to Migrate Magento Store From Localhost To Server?

After creating your dream Magento store on localhost when its time to move it to production server sometimes people get nervous. Its a piece of cake and we will help you in migrating your Magento store from localhost to production server.


1. Working domain
2. Production ready for Magento

Working domain

By working domain means the domain on which you are going to host your store. For example

Production ready for Magento

It means there should be all the elements properly setup on the server which is required for a Magento to run. If you need any help regarding that then you can check the link

Steps for Migration

1. Export your localhost database

Export your localhost Magento store database. There are two ways of doing it

A) Via PhpMyAdmin

My personal favorite is via command line interface(CLI) as it is faster than the former one. We will see each way one by one.


Login to you PhpMyAdmin and go to your database. There you will see option “Export” in the header. Here “testmage1” is the name of my database.

Check the below image for reference


b) CLI

CLI or command line interface is better than PhpMyAdmin as it is faster.

mysqldump -u root -p testmage1 > database_name.sql

Put the name of you database in the place of testmage1. This command will create the dump of your database with the name database_name.sql

2. Compress and upload your Magento files

After the database has been exported now its time to compress your Magento store files. Create the zip of all the files of your store. This way it will be easy to upload it on the server. Now open Filezilla and upload the zipped file over the server and extract it in the required folder.

3. Import Database

Now its time to import your database on your production. Now again there are two ways of doing it

a) PhpMyAdmin

Login to your PhpMyAdmin of production and create an empty database with the same name as on your localhost. After creating a database you will see “Import” option in the header.

Check Image for reference.


After clicking on the Import browser you file as shown in the image and click on GO. This will take a few minutes and your database will be imported.

b) CLI

For importing database via CLI you need to upload your database file via FTP and login to your server via terminal. Use following command to import the database

mysql -u username -p database_name < file.sql

Here database_name is the name of the database in which your file will be imported and file.sql is the file which you are importing.

4. Modify local.xml

Now we need to modify our local.xml file so that our Magento can access the database. Open Magento_Root/app/etc/local.xml
In it search for <connection> node.


Update these tags as per the production configuration. Your database connectivity is done now.

5. Update domain name

Now its time to make entry of domain name in the database. Open table core_config_data and update your domain in

as shown in the image.

6. Flush Cache

Now its time to refresh your cache as there might be some cache from your localhost machine. To refresh your cache go to


This folder contains your cache. Delete all the files and directory of this folder.

Now you are all set. Your Magento store has been successfully migrated from localhost to production server. Go to your web browser and enter your domain in address base and hit enter. Your website will open as it was in your localhost.


These are the steps to migrate your localhost Magento store to the production server. Always keep backup of your code and database in case anything goes wrong. If your website is not opening properly then go through the above-mentioned steps again and check if you missed anything. Happy Coding:)

Prashant Kumar

Prashant Kumar

Prashant is a passionate Magento developer. He loves exploring e-commerce and reading books.

Leave a Reply

Your email address will not be published. Required fields are marked *