WordPress has become one of the most widely used content management systems in recent years. Thanks to its ease, convenience, and options, a large number of companies build their websites based on the adaptable virtues of WordPress.
In this new post we accept the challenge of showing you the easiest way to migrate WordPress from local to your web server. Remember that if you have PrestaShop hosting from Línea Gráfica, you will have plenty of space and, in addition, you will have a server 100% optimized for PrestaShop.
Please take note and prepare the following requirements as we are already underway:
To do this, we will go to the cPanel control panel, look for the "Databases" option and click on "MySQL Databases". We will create a new user and give it all the privileges to be able to perform the migration.
Next, connect to your hosting space via FileZilla using the connection details provided by your web host and transfer WordPress to the server. It's as simple as finding the WordPress installation files on your computer in the “ Local site ” section of the FileZilla interface and dragging them to the “ Remote site ” panel on the right. This is done via the “ public_html ” directory.
- Have WordPress installed
- Hosting access data
- Notepad++ ready to work
- FileZilla
Export WordPress
The first step is to access the databases on our local server through phpMyAdmin: http://localhost/phpmyadmin/ and then click on the section where WordPress was installed. Find it and click on the “Export” option. Once on the export screen, two options will appear: “Export Method” and “Format”. In the first one, choose “Quick Export” and in the second one, “SQL Format”.
Changing paths with Notepad++
Have you downloaded the SQL file with WordPress? Now it’s time to change the database paths: http://localhost/wordpress to your domain address using Notepad++ . It’s very easy, open the “Find” tab, click on “Replace”, fill in the form as shown in the image and click on “Replace all”.
Creating a database via cPanel
The first step to installing WordPress on the web is to make sure that there is a database on the MySQL server that allows us to host the download data.
To do this, we will go to the cPanel control panel, look for the "Databases" option and click on "MySQL Databases". We will create a new user and give it all the privileges to be able to perform the migration.
Import the local database
We continue to bingo. Through phpMyAdmin we access the “Import” section and choose the SQL file that we downloaded in the first step.
Configure the wp-config.php file
This crucial step in the migration involves modifying aspects in the “wp-config.php” file that you will find in the WordPress installation folder on your computer. Once located, open it with Notepad++ and change the following:- In “ define('DB_NAME', 'wordpress') ” delete “wordpress” and write the name of the database created in cPanel.
- In “ define('DB_USER', 'root') ” delete “root” and write the database user.
- In “ define('DB_PASSWORD',”----- ”) ” inside the quotes, type the password with which you created the database.
- In “ define('DB_HOST', 'localhost') ” delete “localhost” and write the name of the server.
Time to migrate WordPress files
If you've made it this far without too many problems, congratulations. Migrating WordPress from local to your server is not for everyone. Luckily, we're already in the final stretch. The last step starts through your hosting control panel. Click on the "Settings" menu, then on "General" and finish on "FTP Details"- Host Name : The FTP server.
- User : This will be the FTP user.
- Password : This will be the FTP password.
Next, connect to your hosting space via FileZilla using the connection details provided by your web host and transfer WordPress to the server. It's as simple as finding the WordPress installation files on your computer in the “ Local site ” section of the FileZilla interface and dragging them to the “ Remote site ” panel on the right. This is done via the “ public_html ” directory.
