Saltar al contenido

WordPress Migrate Remote to Local Server with Xampp

febrero 2, 2020


Having a test environment our local WordPress web is interesting as we allows testing, modifications, extensions facilities, templates … and test them without affecting the web we have in production (server hosting).

With that we ensure that once we implement on the web we have in production there will be no problem.

for this entry will use a Windows and a local server, in this case Xampp, but there are others such as WampServer.

Table of Contents

  • What is a local server?
  • Download Xampp
  • Install Xampp
  • Download files Hosting
  • Download Database
  • Copy files on our local server
  • Import Database file datosModificar wp-configModificar URL of the site administrator WordPress
  • Modify file wp-config
  • Modify URL of the site administrator WordPress
  • Video tutorial
  • Conclusions
  • Modify file wp-config
  • Modify URL of the site administrator WordPress

What is a local server ?

Some will wonder what a local server, because there is no mystery.

A local server is a PC application that contains all the packages needed to make our web load .

That is the same program provides a database, Apache and PHP which are the elements needed to make our website (WordPress, Joomla, Prestashop) is displayed.

Let’s start some fun.

Download Xampp

The first step would be to download our local server Xampp from their official website: access the official website of XAMPP.

Nothing we access that offers downloads for Windows, Linux and OS (Mac) operating systems depending on the operating system that have to be installed.

The Windows version supports Windows 7, Windows 8.1 and Windows 10 and 32 systems and 64-bit so you do not have to worry about the version you have installed on your PC.

how we will use a Windows PC, will press the button « XAMPP for Windows » and start downloading.

Install Xampp Installation is very simple, as any other program have installed, you just have to launch the installation package that we previously downloaded.

select the right mouse button on the file and click on «Run as administrator «.

The first window we see is the beginning of the installation , just select Next .

The next window asks us that we indicate the components you want to install .

can be left by default with all applications but there are components that sense I do not see them installed such as those for mail services.

In block Server we marked options Apache , MySQL and Tomcat and uncheck options FileZilla and Mercury Mail server .

  • Apache Server Software.
  • MySQL database management system data.
  • FileZilla: Application FTP for file management.
  • Mercury Mail Server: Server emails.
  • Tomcat: Software for Java applications.

In block Program Languages ​​ we selected options PHP , Per and phpMyAdmin and desmarcamos Webalizer and Fake Sendmail:

  • PHP: Programming language.
  • Per: Programming language.
  • phpMyAdmin: Database Manager.
  • Webalizer: Software for data analysis.
  • Fake Sendmail: Client SMTP for sending mail.

Then hit Next and the next window we shows the URL where you installed by default in this case is in the XAMPP folder, we just have to click on «Next «.

The next window informs us that there are versions of Xampp incorporating packages Joomla , WordPress or Drupal pre-installed.

Simply click on Next and finally tells us begin the installation, the same, click on Next .

Immediately after the installation we see a window showing the panel XAMPP control.

In the panel can see the applications that have active , button Start to start services and Config button for application settings.

No need to complicate our lives with different default settings because we have more than enough.

The only thing that may interest us is the Apache configuration with the file php.ini where we can modify PHP server values ​​but, as I say, by default it serves.

Since we’re going to start with Xampp services and test that everything works well, for it click on the Start button services Apache and MySQL.

Once we see that torn services are shown in green .

To test the service and see that everything works well only have to access the browser and add URL « localhost».

The new window shows Welcome page or Dashboard that tells us that everything is correct and our server is running.

also test access to phpMyAdmin and the same time will create the database that we need for the web we want to move from our hosting.

only have to press phpMyAdmin in the top menu.

The window that opens is the manager Databases phpMyAdmin.

In the right column we see the databases we have created and the top menu with the options to create databases, export, conduct consultation, etc.

We will focus only on creating the database that is what matters to us, selecting the « Databases» option.

We have only to add the name of our database in the cell » name database «.

In this case we’ll put the name « weblocal » may use the name you want is just an example and be the name of the database that will use our facility.

A good practice would be to use the same name as the domain or the database we have in the hosting facility.

That can easily identify the database for each installation if you have more than one installed application.

Then hit create and to create the new database.

Easy, right? Well, we have half work done so without realizing it, we downloaded a local server, installed and above create a data base.

And I thought that I could not do it and it is easier than I thought ….

Download files


The next step is to download the files and the database of the system we have in our hosting account.

Download the file we will from the file manager we have in our cPanel account.

On this blog entry Webempresa we have a tutorial where you can learn how to use the File Manager: File Manager cPanel how to search for files ?.

access our cPanel account and block «File» select the file manager tool

Inside the folder public_html folder we see that we have several domains as we have added our own hosting.

In the case of this example will use the WordPress folder where I have a testing facility WordPress + WooCommerce, in your case would be the folder where the facility is.

may have multiple domains hosting on our account and do not know which folder is using the Web we want to migrate so one of the questions would be: To what folder pointing my domain? .

How do you know which folder pointing my domain? .

is very simple, we just have to block access Domains our cPanel account.

see that shows all the domains added to our account and folder It pointed to each domain in the root directory column.

Once located the installation folder where we want to migrate the next step is would compress the folder to download to our team.

As always, very simple, you just have to select the folder with the right mouse button and select Compress .

Another option would be selecting the folder and clicking the button Compressing found on the top menu.

select « ZIP file» the type of compression and click on the button Compress File (s) .

Once we have the ZIP file with our application, we would just download the package with the selected files, the zip that we compress and pressing « Download » from the top menu.

As are several things we have to download as advice and to have everything controlled, it is best to create a folder, for example, discharges and both the zip and the database we downloaded now, we will directly on that binder.

In my case I created a folder named weblocal .

Download Database

We get export the database of our facility, for that use the phpMyAdmin application find in our cPanel account.


the like happened with our application files, you may we have several facilities and do not know which database is being used our app.

How do you know which database uses my site?

We have several ways to know which database you are using.

For the Hosting Webempresa have the WpCenter tool within the block Applications Webempresa our cPanel account.

Nothing access WpCenter see that shows all applications WordPress we have installed, press in the button set the application you want to move, in my case would be WordPress.

In the general tab we block installation General data where we can view all web data including the name of the database.

Another option would be editing the file wp-config that is in the root of the installation.

Access the folder where the application is installed, select the file wp-config with the right button and click on «edit «.

The window that opens is to the file where you can see all the data setting up our WordPress, one option is the name of the database.

already have the data we needed, now it export base data by accessing phpMyAdmin .

Once we access the database manager phpMyAdmin data on the left side we see all the databases we have created.

will select the database our application and press in the export button from the top menu.

We only have to click on the button «Continue » and the database is downloaded.

With this we would have everything we need, we have the server installed, the files of our application and data base .

Copy files on our local server

is slowly taking shape this so we get down to work and start copying files downloaded to the folder we create on our local server.

Access the folder where you have downloaded both the database and the zip and unzip files with the zip file.

if you use WinRAR only have to select the file with the right button and click «Extract Here «.


This will create a folder with all files.

to that folder can rename it or just leave it alone. The folder name will be that we will use to access our website, in my case will rename and put weblocal .

With the right button of the mouse select the folder and click on copy .

We access the file manager on your PC -> Disk C -> XAMPP folder and finally the htdocs folder.

htdocs folder say it is the root of our local server, it would be like the folder public_html our hosting.

Within the folder htdocs folder will stick with our installation files have copied above.

Already we have left less! Easy now, right ?, because the heaviest already have. Now we have the database, you will see how easy it is.

Import Database

With services Xampp MySQL and Apache initiated only need to add the URL of the browser «localhost» to access the Dashboard from our local server.

are the same steps we did to create the database. We access

phpMyAdmin, select the database you created earlier and click Import from the top menu.

In block « file to import » click on the button « Select file » and up the database to export the installation we have in our Hosting.

to the moving web hosting locally, as usual, the URL change, ie, in hosting the URL access our web would instead locally this URL changes and would be localhost / folder_name.

Since we are with our database will use to modify the siteurl table value wp_options , which is what stores the URL of our facility.

select the table and press wp_optintion edit in the « siteurl «.

will modify the URL of the cell « option_value » by the URL of our local facility, in the case of this example would be localhost / weblocal .

Localhost would be the name of our server and weblocal , the folder name where we have our WordPress installation.

In your case the name of the folder may differ, there is only to change the name to the folder where you have the installation.

Come this we already have, we will only modify data access to the database in the WordPress configuration file.

file wp-config Modify

The last step would indicate the access data to our server and database.

A server changing these data may also change and if we try now access our local website we will find a connection error to the database.

The WordPress configuration data may be found in the file wp -config found in our installation folder on the local server.

Access the folder of our local installation and edit the file wp-config , I can open it with Windows Notepad.

After editing the file we have to modify define of connection to the database.

  • DB_NAME: the name of the database we created for our installation Local, in the case of this example use weblocal.
  • DB_USER: Default is root unless a user is created for access to the database.
  • DB_PASSWORD: Password This data would access the database, we’ll leave empty and that being a local installation have not created any user.

This is an example of the installation we are doing in this tutorial, if you’ve followed all the steps with the same data, define would be the same.

Modify URL of the site administrator WordPress

This we have, we get to change the URL of the site and that will access manager WordPress adding in the direction of the browser» localhost / name-de-la-folder / wp-admin «where folder name is the name of the folder where you have the facility locally.

For this example would be localhost / weblocal / wp-admin

We access our local administrator installation, user and password are the same we have in our hosting facility.

Within WordPress administrator will drive settings -> General and modify the URL of the « site address (URL) » option for the URL of our site locally.

and time yes yes we have everything, you just have web access and view all sections loaded without problems. Video tutorial

The following video tutorial will see the whole process of how we can move the WordPress Hosting we have in our PC, locally using Xampp application.


I know that the best is to have a clone in our hosting account but it is not always possible topics of space or because our hosting plan does not allow this.

This is a way to have our application locally to perform the necessary tests without affecting the page we have in production.

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *