Next, you need to replicate this step for the option name: home. 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.
Update the home url to be the same as your siteurl.
Step 6: Setup Your Live Site
Now that we have imported the database and all of our content should be uploaded, it’s time to configure WordPress.
At this time, your site should be showing an Error Establishing Database Connection error.
To fix this, connect to your website using an FTP client and edit wp-config.php file.
You will need to provide the database name, user and password you created earlier in Step 3.
Next, save the wp-config.php file and upload it back to your server.
You can now visit your website, and it should be live now.
Next, you need to login to your WordPress admin panel and go to Settings » General. Without changing anything, scroll to the bottom and click the Save Changes button.
This will ensure that the site URL is corrected anywhere else that it needs to be.
After that go to Settings » Permalink and click Save Changes to ensure that all post links are working fine.
Step 7: Fix Images and Broken Links by Updating Paths
Whenever you are moving a WordPress site from one domain to another, or from local server to a live site, you’ll face broken links and missing images.
You can either use the SQL query or use the Velvet Blues WordPress plugin.
For those who want to do it via SQL, here is a simple SQL query that should solve this problem: