Change URL options in MySQL database when move WordPress CMS website


Warning: Undefined array key "socialize_RedditWidget" in /home/phpacd/websites/shkodenko.com/wp-content/plugins/socialize/frontend/socialize-services.php on line 166

To change URL options in MySQL database when move WordPress CMS website from one domain to another SQL query can be used:

update wp_options set option_value = REPLACE(option_value, 'http://old.shkodenko.com', 'http://new.shkodenko.com');

Note, this is true if default value

$table_prefix  = 'wp_';

is used in main configuration file wp-config.php