i do not see the "site url and home options" under Wp_Options (phpmyadmin)

by Daljit Singh Khalsa   Last Updated June 13, 2019 07:08 AM

i wanted to show you this issue. This is happening first time with me in my 10 years career, I have cloned many sites to another domain in past but this is for the first time, when i do not see the "site url and home options" under Wp_Options (phpmyadmin)

This is the domain name which i cloned --> https://13cabsonline.com.au and this is the destination domain --> https://silverservice.sydney/

i have downloaded and restored files via Backup Widget. Uploaded the filemanager + databases and connected the databases with a user too.

But the issue is that i am not able to find the options under Wp_Options in phpmyadmin.

For example: A normal look of wp_options is like this --> http://prnt.sc/o1724k but i see this --> https://prnt.sc/o172as

Can you please have a look at it as there is no video or blog about it on the internet. This is strange for me.

Tags : wp-options


Answers 1


Check wp-config.php. It's possible to define these values there, in which case they won't be available as settings, which means they won't be saved in the database.

It is possible to set the site URL manually in the wp-config.php file.

Add these two lines to your wp-config.php, where “example.com” is the correct location of your site.

define( 'WP_HOME', 'http://example.com' );
define( 'WP_SITEURL', 'http://example.com' );

This is not necessarily the best fix, it’s just hard-coding the values into the site itself. You won’t be able to edit them on the General settings page anymore when using this method.

https://wordpress.org/support/article/changing-the-site-url/#edit-wp-config-php

If this was done on the original site, the corresponding values won't exist in wp_options. The solution would be to either change the values in wp-config.php, or remove these lines from wp-config.php and then insert the desired values into wp_options manually.

Jacob Peattie
Jacob Peattie
June 13, 2019 06:50 AM

Related Questions


Updated May 09, 2016 08:03 AM

Updated February 25, 2016 01:03 AM

Updated December 20, 2017 23:08 PM

Updated January 22, 2018 15:08 PM

Updated July 24, 2015 13:03 PM