Migrate WordPress from Remote Server to Local with Xampp

Hosting Mautic QuickStart -50% with support in Spanish
24 hours and free training

Send up to 1,000,000 emails/year. Mautic support in Spanish 24 hours, 365 days

have a Test Environment of our local is interesting since it allows us to carry out tests, modifications, installation of extensions, templates… and check its operation without affecting the web that we have in production (on the hosting server).

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

For this entry we will use a Windows computer and a local server, in this case xamppbut there are others such as WampServer .

What is a local server?

some of you will ask What is a local serverbecause there is no mystery.

a local server is a PC application that contains all the necessary packages to make our website load.

In other words, the same program provides us with a database, Apache and PHP which are the necessary elements to make our website (WordPress, Joomla, Prestashop) be displayed.

Let’s start having some fun. πŸ˜‰

Download xampp

The first step would be download our local Xampp server from its official page: access the official page of .

As soon as we access we see that it offers us downloads for Windows, Linux and OS (Mac) operating systems depending on the operating system in which we have to install.

The Windows version supports Windows 7, Windows 8.1 and Windows 10 as well as 32 and 64 Bit systems so we won’t have to worry about the version we have installed on our PC.

As we will use a PC with Windows, we will click on the button ” XAMPP for Windows ” and the download will start.

Install Xampp

The installation is very simple, like any other program that we have installed, we only have to launch the installation package that we have previously downloaded.

Select the file with the right mouse button and click on ” Execute as an administrator β€œ.

The first window we see is the start of installationwe only select Next.

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

It can be left by default with all the applications, but there are components that I don’t see the point of having them installed, such as those of the mail services.

In the block servers We leave the options marked Apache , mysql Y tomcat and uncheck the options FileZilla Y Mercury Mail server.

  • Apache: Server Software.
  • mysql: Database management system.
  • FileZilla : FTP application for file management.
  • Mercury Mail server: Email server.
  • tomcat: Software for Java applications.

In the block Program Languages We leave the options selected. PHP, Per Y phpMyAdmin and uncheck Webalizer Y FakeSendMail:

  • PHP: Programming language.
  • Per: Programming language.
  • phpMyAdmin: Database Manager.
  • Webalizer: Data analysis software.
  • Fake SendMail: SMTP client for sending mail.

Click on Next and the next window shows us the URL where it will be installed by default, which in this case is in the xampp folder, we just have to click on ” Next ”.

See also  WordPress Activity Log: WP Security Audit Plugin

The next window informs us that there are versions of Xampp that incorporate the packages of Joomla, wordpress either Drupal pre-installed.

We simply click on Next and to finish it tells us that the installation will begin, the same, click on Next.

As soon as the installation is finished, we see that it shows us a window with the Xampp control panel.

on the dashboard we can see the applications that we have activethe button Start to start the services and the button Settings for application configuration.

There is no need to complicate our lives with the different configurations since by default we have more than enough.

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

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

Once booted we see that services are shown in green.

To test the services and see that everything works well, we just have to access the browser and add ” in the URL. localhost ”.

The new window shows us the page of Welcome or Dashboard which tells us that everything is correct and our server is working.

We will also test access to phpMyAdmin and at the same time we will create the database that we need for the website that we want to transfer from our hosting.

We just have to press phpMyAdmin in the top menu.

The window that opens is the Database manager phpMyAdmin.

In the right column we see the databases that we have created and the upper menu with the different options to create databases, export, perform queries, etc.

We will focus only on the creation of the database that is what matters to us, selecting the option ” Databases β€œ.

We just have to add the name of our database in the cell ” Database name ”.

In this case we will put as name ” web-local ” we can use the name that we want is just an example and it will be the name of the database that our installation will use.

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

With that we can easily identify the database of each installation if we have more than one application installed.

Click on to create and the new Database will be created.

Easy, right? Well, we already have half a task done, so without realizing it, we have downloaded a local server, we install it and on top of that we create a database.

See also  Metrics configuration exits error 500

And I thought I wouldn’t know how to do it and it turns out that it’s easier than I thought…

Download Hosting files

The next step will be to download the files and the database of the installation that we have in our Hosting account.

We will download the files from the file manager that we have in our WePanel account.

In this blog entry we have a tutorial where we can learn to use the file manager: .

We access our WePanel account and in the β€œFiles” block we select the tool file manager

Inside the public_html folder we see that we have several folders depending on the domains that we have added to our hosting account.

In the case of this example I will use the folder wordpress where I have a test installation of WordPress + WooCommerce, in your case it would be the folder where the installation is.

It is possible that we have several domains in our hosting account and we do not know which folder is used by the Web that we want to migrate, so one of the questions would be: What folder does my domain point to?.

How do I know which folder my domain points to?.

It’s very simple, we just have to access the block domains from our WePanel account.

We see that it shows us all the domains added to our account and the folder to which each domain points in the column Root directory.

Once the folder where the installation we want to migrate is located, the next step would be to compress the folder to download it to our computer.

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

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

We select ” zip file ” in the Compression type and click on the button Compress File(s).

Once we have the ZIP file with our application, we would only have to download the package with the selected files, the zip that we compressed and pressing ” Discharge ” from the top menu.

As there are several things that we have to download, as a tip and to have everything under control, it is best to create a folder, for example, in downloads and both the zip and the database that we download now, we will do it directly in that folder.

In my case I have created a folder with the name web-local.

Download Database

We have to export the database of our installation, for that we will use the application phpMyAdmin that we will find in our WePanel account.

As it happened with our application files, it is possible that we have several installations and we do not know which database our application is using.

See also  BACK button that makes me go back 2 steps

How to know what database my website uses?

We have several ways of knowing which database we are using.

In the case of Hosting we have the tool inside the block applications from our WePanel account.

As soon as you access WpCenter we see that it shows us all the WordPress applications that we have installed, we will click on the button set up of the application that we want to transfer, in my case it would be WordPress.

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

Another option would be editing the file wp config located at the root of the installation.

We access the folder where the application is installed, select the file wp config with the button on the right and click on ” edit ”.

The window that opens is the file where we can see all the configuration data of our WordPress, one of the options is the name of the database.

We already have the data that we needed, now it’s time to export the database by accessing phpMyAdmin.

Once we access the database manager of phpMyAdminon the left side we see all the databases that we have created.

We will select the database of our application and click on the button export from the top menu.

We just have to click on the button ” Continue ” and the database will be downloaded.

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

Copy files to our local server

Little by little this is taking shape so we get down to work and start by copying the files that we downloaded to the folder that we will create on our local server.

We access the folder where we have downloaded both the database and the zip with the files and unzip the zip file.

If you use WinRAR you only have to select the file with the button on the right and click on ” Extract here β€œ.

This will create a folder with all the files.

We can change the name of that folder or simply leave it as it is. The name of the folder will be the one we will use to access our website, in my case I am going to change the name and I will put web-local.

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

We access the file manager of our PC ->…

Loading Facebook Comments ...
Loading Disqus Comments ...