Some Useful WordPress MySQL Queries

This is a very quick tutorial about some useful WordPress MySQL queries. In this tutorial, I will share some useful MySQL queries which will help you when you are going to move your WordPress site from your dev, staging server to production server.

When you upload any WordPress site from staging server to production server, then you need to replace the staging URLs from your application with production URLs.

Some Useful WordPress MySQL Queries

Below are the lists of some MySQL queries which replace your old URLs to new URLs in your website’s database tables. Copy the below MySQL queries and execute it in SQL tab of your PHPMyAdmin or you can use any MySQL client software like MySQL workbench.

About: Prem Tiwari

Prem Tiwari is the founder of FreeWebMentor.com and also a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby and also he has been a regular speaker of WordPress sessions in various IT Companies. View all posts by Prem Tiwari