{"id":41708,"date":"2024-09-07T12:00:48","date_gmt":"2024-09-07T09:00:48","guid":{"rendered":"https:\/\/coma.lv\/2024\/09\/07\/how-to-move-wordpress-from-a-local-server-to-a-live-website\/"},"modified":"2024-09-07T12:00:48","modified_gmt":"2024-09-07T09:00:48","slug":"how-to-move-wordpress-from-a-local-server-to-a-live-website","status":"publish","type":"post","link":"https:\/\/coma.lv\/en\/2024\/09\/07\/how-to-move-wordpress-from-a-local-server-to-a-live-website\/","title":{"rendered":"How to Move WordPress from a Local Server to a Live Website"},"content":{"rendered":"\n

Using a local server can speed up WordPress site development. We have already shown you how to install WordPress on Windows using WAMP<\/a> and on Mac using MAMP. When you have finished developing on the local server, the next step is to take the site online. In this article we will show you how to move WordPress from a local server to the internet. Using this method, you can migrate all of your content (posts, pages, images and so on), themes and plugins from the local server to a live website.<\/p>\n

Before we begin, we have to admit that plugins such as All-in-One WP Migration<\/a>, WPvivid Backup<\/a> and Duplicator<\/a> can make a migration from a local server much easier. In this article we will show how to move WordPress from a local server manually so that you can understand the whole process.<\/p>\n

Before You Start<\/h2>\n

To migrate your locally developed WordPress site to an online server, you need two things. The first is a local server. We assume that you use WordPress on a local server and have full access to it. The second is web hosting that supports WordPress, to which you will move your content.<\/p>\n

You also need an FTP program and need to know how to use it to upload your content to the live site.<\/p>\n

Note: the screenshots in our article were taken on hosting providers that have cPanel.<\/p>\n

Step 1: Export the Local WordPress Database<\/h2>\n

First you need to export your local WordPress database. To do this we will use phpMyAdmin. If you are not familiar with it, you can read our guide on how to manage a WordPress database using phpMyAdmin<\/a>. Just go to http:\/\/localhost\/phpmyadmin\/ and click your WordPress database. Then click the Export<\/em> button in the top menu.<\/p>\n

\"export-tab-phpmyadmin\"<\/p>\n

For the Export Method<\/em>, choose the custom option, which gives you more export options. Select all tables for export and gzipped for compression. Scroll to the bottom of the page and click the Go<\/em> button to download your database.<\/p>\n

Step 2: Upload the WordPress Files to the Website<\/h2>\n

Now open your FTP client and connect to your site. Once connected, make sure you upload the files to the right directory. For example, if you want to host your site at yoursite.com, you should upload all the files to the public_html directory.<\/p>\n

\"uploadingwordpress\"<\/p>\n

Now select your local WordPress files and upload them to the live server.<\/p>\n

Step 3: Create a MySQL Database on the Website<\/h2>\n

While your FTP client is uploading the WordPress files, you can import your database to the live server. Most WordPress hosting providers offer cPanel for managing your hosting account, so we will show how to create a database using cPanel. Log in to cPanel and click the Manage My Databases link in the databases section.<\/p>\n

\"createdatabasecpanel\"<\/p>\n

In the next window, enter the name of your new database.<\/p>\n

\"createnewdb\"<\/p>\n

After creating the database, scroll down to the Database Users section and create a user or add an existing user to the database. After that cPanel will show you a list of MySQL privileges for this user. Just select all privileges.<\/p>\n

\"newdbuser\"<\/p>\n

Step 4: Import the WordPress Database to the Website<\/h2>\n

The next step in the process is importing the WordPress database. Go to cPanel, scroll down to the databases section and click phpMyAdmin. This takes you to phpMyAdmin, where you need to click the database you have just created. phpMyAdmin will show you the new database with no tables. Click the Import<\/em> tab in the top menu. On the next page click the \u201cchoose file\u201d button and then select the gzipped database file you saved earlier. Finally, click the Go<\/em> button at the bottom of the page. phpMyAdmin will now import your WordPress database.<\/p>\n

\"importingdb2\"<\/p>\n

Step 5: Change the URL<\/h2>\n

To set up your site online, you need to change its URL. In phpMyAdmin, find the wp_options table in the database we have just imported. If you changed your database prefix, it may be {prefix}_options instead of wp_options.<\/p>\n

Click the \u201cbrowse\u201d button next to wp_options or the link in the sidebar to open the page listing the fields in the wp_options table.<\/p>\n

\"wpoptionsbrowse\"<\/p>\n

Under the options_name<\/strong> field you need to find siteurl<\/strong>. Click the Edit Field<\/em> icon at the start of the row on the left.<\/p>\n

\"editsiteurlphpmyadmin\"<\/p>\n

When you click Edit Field<\/em>, a new window appears. In the input field for option_value you will see the URL of your local installation, which will look something like this: http:\/\/localhost\/test. Carefully enter your new URL in this field, for example: https:\/\/coma.lv\/<\/p>\n

Save the changes by clicking the Go<\/em> button.<\/p>\n

Next you need to repeat this step for the home<\/strong> option. Update the home<\/strong> URL \u2013 it must be identical to your siteurl<\/strong>.<\/p>\n

Step 6: Configure Your Website<\/h2>\n

Now that you have imported the database and all of your content is uploaded, it is time to configure WordPress. At this point your site should show a database connection error<\/a>. To fix it, connect to your site with an FTP client and edit the wp-config.php file. Enter the name of the database, the user and the password you created earlier. Save the wp-config.php file and upload it back to your server. Go to your site \u2013 everything should work now.<\/p>\n

Log in to the WordPress admin panel and choose Settings > General<\/strong>. Click Save Options<\/em>. This will update the site URL everywhere it is needed.<\/p>\n

Then go to Settings > Permalinks<\/strong> and click Save<\/em> to make sure all links work properly.<\/p>\n

Step 7: Update Paths to Fix Broken Links and Images<\/h2>\n

When you migrate WordPress from one domain to another, or from a local server to a live website, you will run into broken links and images. In that case you can use an SQL query or the Better Search Replace<\/a> plugin for WordPress.<\/p>\n

If you want to use SQL, here is a simple SQL query that should fix the problem:<\/p>\n

\r\nUPDATE wp_posts SET post_content = REPLACE(post_content, &#039;localhost\/test\/&#039;, &#039;www.yourlivesite.com\/&#039;);\r\n<\/pre>\n
Go to phpMyAdmin, click your database and then SQL in the top menu. Enter this query, but do not forget to insert your own local and live site URLs.<\/p>\n
\"wpfiximageurls\"<\/p>\n
Extra: Security and SEO<\/h2>\n