{"id":10401,"date":"2024-04-28T12:58:30","date_gmt":"2024-04-28T12:58:30","guid":{"rendered":"https:\/\/hostvento.com\/kb\/web-hosting\/getting-started-guide\/shared-hosting-quick-start-guide\/move-wordpress-from-local-server-to-live-site\/"},"modified":"2024-06-14T06:22:15","modified_gmt":"2024-06-14T06:22:15","slug":"move-wordpress-from-local-server-to-live-site","status":"publish","type":"docs","link":"https:\/\/www.hostvento.com\/kb\/docs\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/","title":{"rendered":"Learn to Manually Move WordPress from Local Server to Live Site"},"content":{"rendered":"\n

Once\u00a0you\u00a0have\u00a0finished\u00a0customizing\u00a0your\u00a0website,\u00a0transfer\u00a0it\u00a0from\u00a0your\u00a0computer\u00a0to\u00a0a\u00a0server\u00a0so\u00a0that\u00a0anybody\u00a0can\u00a0view\u00a0it. Let\u00a0us\u00a0explore\u00a0how\u00a0to\u00a0manually\u00a0migrate\u00a0your\u00a0WordPress\u00a0website\u00a0from\u00a0a\u00a0local\u00a0server\u00a0to\u00a0a\u00a0live\u00a0website.<\/p>\n\n\n\n

Step 1: Exporting Local WordPress Database<\/h3>\n\n\n\n

First,\u00a0use\u00a0phpMyAdmin\u00a0to\u00a0export\u00a0the\u00a0local\u00a0WordPress\u00a0database.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Navigate to http:\/\/localhost\/phpmyadmin\/<\/strong> and click on your WordPress database. Then, from the top menu bar click on the Export<\/strong> button.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

In the Export<\/strong> option, select either \u201cQuick\u201d<\/strong> or \u201cCustom\u201d<\/strong>. With Custom<\/strong>, you will get more options for exporting your database.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

It is recommended to select Quick<\/strong>, and then click the Go<\/strong> button. This will download your database.<\/p>\n\n\n\n

Step 2: Uploading WordPress Files to Live Site<\/h3>\n\n\n\n

After your database is downloaded, you will need to move your website files to the live site.
To start with, open the FTP client and connect to your web hosting account.
Make sure the files are uploaded to the correct directory after you have established a connection to your live website. You must upload every file in your public_html directory, for instance, if you wish to host your website on yoursite.com.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

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

Step 3: Creating MySQL Database on Live Site<\/h3>\n\n\n\n

While your WordPress files are being uploaded using the FTP client, begin importing your database onto the live server. The majority of WordPress hosting companies provide cPanel for hosting account management.
At first, log in to your cPanel dashboard and click on the\u00a0MySQL Databases<\/strong>\u00a0icon located in the\u00a0Databases<\/strong>\u00a0section.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Next, enter a name for your database to create new database and click on the Create Database<\/strong> button.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Once you create a database, go to the MySQL Users<\/strong> section and create a new user or add an existing user to the database.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The user’s MySQL rights will then be shown after that. Here, tick every box to give the user full access, then press the “Make Changes” button.<\/p>\n\n\n\n

Step 4: Importing WordPress Database on Live Site<\/h3>\n\n\n\n

Now, you will need to import your WordPress database.
In the cPanel dashboard, go to the\u00a0Databases<\/strong>\u00a0section and click on\u00a0phpMyAdmin<\/strong>.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

After the phpMyAdmin dashboard gets displayed, click on the database you created in\u00a0Step 3<\/strong>. This will show your new database without any tables.
In the top menu, click on the\u00a0Import<\/strong>\u00a0tab. Once the\u00a0Import<\/strong>\u00a0page gets displayed, click on\u00a0Choose File<\/strong>\u00a0button and then select the database file saved in\u00a0Step 1<\/strong>.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Next, click the Go<\/strong> button at the bottom of the page. This will import your WordPress database.<\/p>\n\n\n\n

Step 5: Changing the Site URL<\/h3>\n\n\n\n

You will need to change the site URL in your database for connecting with the live WordPress site.
In\u00a0phpMyAdmin<\/strong>, search for the\u00a0wp_options<\/strong>\u00a0table in your database imported in\u00a0Step 4<\/strong>. In case, you have changed your database prefix, then instead of\u00a0wp_options<\/strong>, you will see it as\u00a0{prefix}_options<\/strong>.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Next to wp_options<\/strong> click on the Browse<\/strong> button or the link in the sidebar to open the page with list of fields in the wp_options<\/strong> table as shown below:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Search for the\u00a0siteurl<\/strong>\u00a0under the\u00a0option_name<\/strong>. Click on the\u00a0Edit<\/strong>\u00a0icon located at the far left at the start of the row.
The\u00a0Edit<\/strong>\u00a0field window will get displayed. You will see the URL of your local install such as:\u00a0http:\/\/localhost\/test<\/strong>\u00a0in the input box for\u00a0option_value<\/strong>. Insert your new site url in this field, for example:\u00a0https:\/\/howto.idigitalcamp.com\/blog<\/strong>.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Click on the\u00a0Go<\/strong>\u00a0button to save the changes.
Repeat this step for the\u00a0option_name<\/strong>:\u00a0home<\/strong>. Since the\u00a0wp_options<\/strong>\u00a0page is a few pages long, so just search for the name home. Generally, you will find it on the second page.
Update the home url similar to your siteurl.<\/p>\n\n\n\n

Step 6: Setting up Your Live Site<\/h3>\n\n\n\n

After importing the database and uploading the content, you need to configure WordPress.
If you try browsing your site now, you will get an\u00a0Error Establishing Database Connection<\/strong>\u00a0error.
This can be fixed by connecting to your website using an FTP client and editing\u00a0wp-config.php<\/strong>\u00a0file.
Here you need to provide the database name, user and password created in\u00a0Step 3<\/strong>.
Save the\u00a0wp-config.php<\/strong>\u00a0file and upload it back to your server.
Now visit your website, and it will be live now.
Next, login to your WordPress admin panel and go to\u00a0Settings \u00bb General<\/strong>. Scroll to the bottom and click the\u00a0Save Changes<\/strong>\u00a0button.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

With this, the site URL will get corrected anywhere else where it needs to be.<\/p>\n\n\n\n

Next go to Settings \u00bb Permalink<\/strong> and click Save Changes<\/strong> to check that all post links are working fine.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Step 7: Fixing Images and Broken Links by Updating Paths<\/h3>\n\n\n\n

When you move a WordPress site from one domain to another, or from local server to a live site, there will be broken links and missing images.<\/p>\n\n\n\n

You can use the SQL<\/strong> query or use the Velvet Blues WordPress<\/strong> plugin for fixing this issue.<\/p>\n\n\n\n

If you want to do it via\u00a0SQL<\/strong>, use the below simple SQL query:
UPDATE wp_posts SET post_content = REPLACE(post_content, ‘localhost\/test\/’, ‘www.yourlivesite.com\/’);<\/p>\n\n\n\n

Go to phpMyAdmin<\/strong>, click on your database and then click on SQL<\/strong> from the top menu. Use this query, but replace it with your own local site and live site URLs.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

That\u2019s it, you have migrated WordPress from local server to a live site successfully!<\/p>\n\n\n\n

Hope that now your live website is up and running smoothly. Browse your website and make sure that everything is working as expected. In case there are any errors, go though this guide to common WordPress errors for help troubleshooting.<\/p>\n","protected":false},"excerpt":{"rendered":"

Once\u00a0you\u00a0have\u00a0finished\u00a0customizing\u00a0your\u00a0website,\u00a0transfer\u00a0it\u00a0from\u00a0your\u00a0computer\u00a0to\u00a0a\u00a0server\u00a0so\u00a0that\u00a0anybody\u00a0can\u00a0view\u00a0it. Let\u00a0us\u00a0explore\u00a0how\u00a0to\u00a0manually\u00a0migrate\u00a0your\u00a0WordPress\u00a0website\u00a0from\u00a0a\u00a0local\u00a0server\u00a0to\u00a0a\u00a0live\u00a0website. Step 1: Exporting Local WordPress Database First,\u00a0use\u00a0phpMyAdmin\u00a0to\u00a0export\u00a0the\u00a0local\u00a0WordPress\u00a0database. Navigate to http:\/\/localhost\/phpmyadmin\/ and click on your WordPress database. Then, from the top menu bar click on the Export button. In the Export option, select either \u201cQuick\u201d or \u201cCustom\u201d. With Custom, you will get more options for exporting your database. It is recommended to select Quick, and then click the Go button. This will download your database. Step 2: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23377,"menu_order":430,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-10401","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/comments?post=10401"}],"version-history":[{"count":2,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10401\/revisions"}],"predecessor-version":[{"id":10404,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10401\/revisions\/10404"}],"up":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/23377"}],"wp:attachment":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/media?parent=10401"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=10401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}