http:\/\/localhost\/phpmyadmin\/<\/code>\u00a0and click on your WordPress database. Then, click >>\u00a0Export\u00a0button from the top menu bar.<\/p>\n <\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/wpLTL1.png\")
<\/p>\n
<\/p>\n
In the\u00a0Export Method\u00a0option, you can choose \u201cQuick\u201d or \u201cCustom\u201d. Custom will provide you with more options to export your database. We recommend choosing Quick, and then click the\u00a0Go\u00a0button to download your database.<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/wpLTL2.png\")
<\/p>\n
Step 2:<\/p>\n
Connect to your web hosting account using FTP client and upload all files in your public_html directory<\/p>\n
After that upload your local WordPress files to your live server.<\/p>\n
<\/p>\n
<\/p>\n
step 3:<\/p>\n
Meanwhile import your database to the live server.<\/p>\n
once you logged into your cPanel dashboard and click on the\u00a0MySQL Databases\u00a0icon which can be found in the databases section.<\/p>\n
<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/wpLTL3.png\")
<\/p>\n
<\/p>\n
<\/p>\n
Then it will get you to next screen .Here, create a database by entering a name for your database and clicking the\u00a0Create Database\u00a0button.<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT4.png\")
<\/p>\n
After creating your\u00a0database, scroll down to the\u00a0MySQL Users\u00a0section and create or add an existing user to the database.<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT5.png\")
<\/p>\n
<\/p>\n
After adding the user, you will get this screen to set MySQL privileges for that user. Provide all privileges to the user by making sure every box is checked, and then click the\u00a0Make Changes\u00a0button.<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT6.png\")
<\/p>\n
<\/p>\n
<\/p>\n
Step 4:<\/p>\n
Now Import your database<\/p>\n
Go to your cPanel dashboard and click >>phpMyAdmin. This will take you to phpMyAdmin where you have to click on the database you created in Step 3. PhpMyAdmin will show your new database with no tables.<\/p>\n
Click >> Import\u00a0tab in the top menu. On the import page, click >> Choose File\u00a0button and then select the database file you saved in Step 1.<\/p>\n
Finally, press the\u00a0Go\u00a0button at the bottom of the page. PhpMyadmin will now import your WordPress database.<\/p>\n
<\/p>\n
<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT7.png\")
<\/p>\n
Step 5:<\/p>\n
change the site URL in your database, so that it will connect with your live WordPress site.<\/p>\n
In phpMyAdmin, look for the wp_options table in your database that we just imported in step 4. If you\u00a0changed your database prefix, then instead of wp_options it might be {prefix}_options.<\/p>\n
Click on the\u00a0Browse\u00a0button next to wp_options or the link that you see in the sidebar to open the page with a list of fields within the wp_options table.<\/p>\n
<\/p>\n
<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT8.png\")
<\/p>\n
Under the field\u00a0options_name, you need to look for\u00a0siteurl. Click the Edit Field icon which can be found at the far left at the beginning of the row.<\/p>\n
<\/p>\n
![\"\"](\"http:\/\/javawebhosting.co.in\/blog\/wp-content\/uploads\/2018\/03\/WPTLT9.png\")
<\/p>\n
When you click the edit field, an edit field window will appear. In the input box for option_value, you will see the URL of your local install probably something like:\u00a0http:\/\/localhost\/test<\/code>. Carefully insert your new site url in this field.<\/p>\n <\/p>\n
Next, you need to replicate this step for the option name:\u00a0home. The wp_options page can be a few pages long, so simply find the home tab. Usually it is on the second page which you can navigate to by clicking on the pagination arrows in phpMyAdmin.<\/p>\n
Update the\u00a0home\u00a0url to be the same as your\u00a0siteurl.<\/p>\n
<\/p>\n
Now that we have imported the database, and all of our content should be uploaded, it\u2019s time to configure WordPress. At this time, your site should be showing an\u00a0Error Establishing Database Connection\u00a0error. To fix this, connect to your website using an FTP client and edit\u00a0wp-config.php<\/code>\u00a0file. Provide the database name, user and password you created earlier in Step 3. Save the wp-config.php file and upload it back to your server. Visit your website, and it should be live now.<\/p>\nNext, you need to login to your WordPress admin panel and go to\u00a0Settings >> General. Without changing anything, scroll to the bottom and click the\u00a0Save Changes\u00a0button. This will ensure that the site URL is corrected anywhere else that it needs to be.<\/p>\n
After that go to\u00a0Settings>> Permalink\u00a0and click\u00a0Save Changes\u00a0to ensure that all post links are working fine.<\/p>\n
<\/p>\n
Whenever you are moving a WordPress site from one domain to another, or from local server to a live site, you\u2019ll face broken links and missing images.<\/p>\n
You can do it via SQL, here is a simple SQL query that should solve this problem:<\/p>\n
\nUPDATE wp_posts SET post_content = REPLACE(post_content, 'localhost\/test\/', 'www.example.com\/');<\/pre>\n<\/div>\nSimply go to phpMyAdmin, click on your database and then click on SQL from top menu. Write this query, with your own local site and live site URLs.<\/p>\n
Now your site will be live ,hope this helps you all in\u00a0Migrate WordPress from Local host to online .<\/p>\n
see you all with another interesting Post.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi folks in our previous post we have learned about\u00a0 migrating your WordPress blog from WordPress.com to WordPress.org\u00a0 and now we are going to look about how to Migrate WordPress… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/posts\/189"}],"collection":[{"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/comments?post=189"}],"version-history":[{"count":1,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/posts\/189\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/posts\/189\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/media?parent=189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/categories?post=189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/portal\/wp-json\/wp\/v2\/tags?post=189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}