yicr
1/20/2020 - 10:21 AM

WordPress : Tips / How to change hostname in database.

wp_option table

option_name = 'home' and 'siteurl' update new value.

mysql> desc wp_options;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| option_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| option_name  | varchar(191)        | NO   | UNI |         |                |
| option_value | longtext            | NO   |     | NULL    |                |
| autoload     | varchar(20)         | NO   |     | yes     |                |
+--------------+---------------------+------+-----+---------+----------------+
mysql> update wp_options set option_value = 'https://newdomain.com'  where option_name = 'home';
mysql> update wp_options set option_value = 'https://newdomain.com'  where option_name = 'siteurl';