{"id":7719,"date":"2020-06-12T09:46:45","date_gmt":"2020-06-12T09:46:45","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=7719"},"modified":"2024-03-19T10:00:29","modified_gmt":"2024-03-19T10:00:29","slug":"move-wordpress-from-local-server-to-live-site","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/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":"

After completing with your website customization, move website free<\/a> from your computer to server machine to make it accessible for all. Let\u2019s learn to move your WordPress website from local server to a live site with the manual method.<\/p>\n

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

At first, export your local WordPress database using phpMyAdmin<\/strong>.<\/p>\n

\"\"<\/p>\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

\"\"<\/p>\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

\"\"<\/p>\n

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

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

After your database is downloaded, you will need to move your website files to the live site.<\/p>\n

To start with, open the FTP client and connect to your web hosting account.<\/p>\n

After getting connected to your live site, ensure that you upload the files in the right directory. For example, if you want to host your site on yoursite.com<\/strong>, then you will need to upload all the files in your public_html<\/strong> directory.<\/p>\n

\"\"<\/p>\n

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

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

Start importing your database to live server, while the FTP client is uploading your WordPress files. cPanel is offered by most of the WordPress hosting providers for managing your hosting account.<\/p>\n

At first, log in to your cPanel dashboard and click on the MySQL Databases<\/strong> icon located in the Databases<\/strong> section.<\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\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

\"\"<\/p>\n

After this, the MySQL privileges for that user will get displayed. Here, grant all the privileges to the user by checking every box and then click on the Make Changes<\/strong> button.<\/p>\n

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

Now, you will need to import your WordPress database.<\/p>\n

In the cPanel dashboard, go to the Databases<\/strong> section and click on phpMyAdmin<\/strong>.<\/p>\n

\"\"<\/p>\n

After the phpMyAdmin dashboard gets displayed, click on the database you created in Step 3<\/strong>. This will show your new database without any tables.<\/p>\n

In the top menu, click on the Import<\/strong> tab. Once the Import<\/strong> page gets displayed, click on Choose File<\/strong> button and then select the database file saved in Step 1<\/strong>.<\/p>\n

\"\"<\/p>\n

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

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

You will need to change the site URL in your database for connecting with the live WordPress site.<\/p>\n

In phpMyAdmin<\/strong>, search for the wp_options<\/strong> table in your database imported in Step 4<\/strong>. In case, you have changed your database prefix, then instead of wp_options<\/strong>, you will see it as {prefix}_options<\/strong>.<\/p>\n

\"\"<\/p>\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

\"\"<\/p>\n

Search for the siteurl<\/strong> under the option_name<\/strong>. Click on the Edit<\/strong> icon located at the far left at the start of the row.<\/p>\n

The Edit<\/strong> field window will get displayed. You will see the URL of your local install such as: http:\/\/localhost\/test<\/strong> in the input box for option_value<\/strong>. Insert your new site url in this field, for example: https:\/\/howto.idigitalcamp.com\/blog<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on the Go<\/strong> button to save the changes.<\/p>\n

Repeat this step for the option_name<\/strong>: home<\/strong>. Since the wp_options<\/strong> page is a few pages long, so just search for the name home. Generally, you will find it on the second page.<\/p>\n

Update the home url similar to your siteurl.<\/p>\n

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

After importing the database and uploading the content, you need to configure WordPress.<\/p>\n

If you try browsing your site now, you will get an Error Establishing Database Connection<\/strong> error.<\/p>\n

This can be fixed by connecting to your website using an FTP client and editing wp-config.php<\/strong> file.<\/p>\n

Here you need to provide the database name, user and password created in Step 3<\/strong>.<\/p>\n

Save the wp-config.php<\/strong> file and upload it back to your server.<\/p>\n

Now visit your website, and it will be live now.<\/p>\n

Next, login to your WordPress admin panel and go to Settings \u00bb General<\/strong>. Scroll to the bottom and click the Save Changes<\/strong> button.<\/p>\n

\"\"<\/p>\n

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

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

\"\"<\/p>\n

Step 7: Fixing Images and Broken Links by Updating Paths<\/h3>\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

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

If you want to do it via SQL<\/strong>, use the below simple SQL query:<\/p>\n

UPDATE wp_posts SET post_content = REPLACE(post_content, 'localhost\/test\/', 'www.yourlivesite.com\/');<\/pre>\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
\"\"<\/p>\n
That\u2019s it, you have migrated WordPress from local server to a live site successfully!<\/p>\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":"
After completing with your website customization, move website free from your computer to server machine to make it accessible for all. Let\u2019s learn to move your WordPress website from local server to a live site with the manual method. Step 1: Exporting Local WordPress Database At first, export your local WordPress database using phpMyAdmin. Navigate […]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[1470,1469,78,178],"class_list":["post-7719","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-wordpress-faq","tag-live-site","tag-move-wordpress-from-local-server-to-live-site","tag-wordpress-2","tag-wordpress-website"],"yoast_head":"\nLearn to Manually Move WordPress from Local Server to Live Site<\/title>\n<meta name=\"description\" content=\"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn to Manually Move WordPress from Local Server to Live Site\" \/>\n<meta property=\"og:description\" content=\"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-12T09:46:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-19T10:00:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/06\/phymyadmin-min.png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/\",\"name\":\"Learn to Manually Move WordPress from Local Server to Live Site\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/06\/phymyadmin-min.png\",\"datePublished\":\"2020-06-12T09:46:45+00:00\",\"dateModified\":\"2024-03-19T10:00:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn to Manually Move WordPress from Local Server to Live Site\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn to Manually Move WordPress from Local Server to Live Site","description":"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/","og_locale":"en_GB","og_type":"article","og_title":"Learn to Manually Move WordPress from Local Server to Live Site","og_description":"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-06-12T09:46:45+00:00","article_modified_time":"2024-03-19T10:00:29+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/06\/phymyadmin-min.png","type":"","width":"","height":""}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/","name":"Learn to Manually Move WordPress from Local Server to Live Site","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/06\/phymyadmin-min.png","datePublished":"2020-06-12T09:46:45+00:00","dateModified":"2024-03-19T10:00:29+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"Learn to move your website needs from your computer to a live site to make it accessible to all with the manual method.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/move-wordpress-from-local-server-to-live-site\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn to Manually Move WordPress from Local Server to Live Site"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":521,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7719"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7719\/revisions"}],"predecessor-version":[{"id":15275,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7719\/revisions\/15275"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}