Change URL options in MySQL database when move WordPress CMS website

~ tadmin

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

Published by tadmin