I need to modify wp_options table

Support
, ,
4

Good point on the inability to use a plugin here.

I’m not sure why the system won’t let you update the value via Adminer. There are a number of other options that you could try – of course, replace the URL with that of your site, and make sure that URL matches the one set in Local for the site.

  1. If you’re having issues editing the value directly within Adminer, you could try running SQL to perform the update – something like:

update wp_options set option_value = 'https://example.com' where option_name = 'siteurl';
update wp_options set option_value = 'https://example.com' where option_name = 'home';

  1. Modify the SQL file before re-importing it via Adminer.
  2. Add something like this to your theme’s functions.php file and try loading the site:

update_option( 'siteurl', 'https://example.com' );
update_option( 'home', 'https://example.com' );

  1. Alternatively, you could override the database entries by placing entries in the wp-config.php file along the lines of:

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

It’s going to be better to get those database entries correct. The last one won’t touch the database, but uses a little brute force to override the database entries.

2 Likes