Change WordPress URL In Database With PhpMyAdmin And SQL Query | Code For Developers

Change WordPress URL in Database with phpMyAdmin and SQL query

Replace WordPress old URL to new URL with SQL Query

First, make sure you are on correct database on phpMyAdmin.

September 22, 2022

Put the below code under the SQL tab and press go.

Before you press go make sure you change youroldsite.com and yournewsite.com

SQL Query
UPDATE wp_options SET option_value = replace(option_value, 'https://youroldsite.com', 'https://yournewsite.com') WHERE option_name = 'home' OR option_name = 'siteurl';UPDATE wp_posts SET guid = replace(guid, 'https://youroldsite.com','https://yournewsite.com');UPDATE wp_posts SET post_content = replace(post_content, 'https://youroldsite.com', 'https://yournewsite.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://youroldsite.com','https://yournewsite.com');
Previous Code

Create a new WordPress administrator via functions.php & FTP

TweetShareSharePin0 Shares ...

Next Code

Allow Only Business Email Addresses in the Email Field of Elementor Forms

Accept submissions from Business emails on Element ...

Leave a Reply

Your email address will not be published. Required fields are marked *

If you find it useful

Buy me a coffee

ACF

Elementor

JavaScript

jQuery

Others

PHP

WooCommerce

WordPress

WP Plugin Development

WordPress category or taxonomy list

WordPress custom taxonomy term list with function ...

Remove Website field from WordPress comment & Change cookies remember text

Remove Website field from WordPress comment & Chan ...

WooCommerce Mostly used Shortcode

Most use shortcode for popular eCommerce plugin Wo ...

Conditional statement to show pagination

Conditional statement to show pagination on WordPr ...

HTML img tag to HTML SVG tag [WordPress]

Image to SVG for WordPress. Generate svg code from ...

top