\u65b0VPS\u3078\u79fb\u884c\u3057\u305f\u3082\u306e\u306eDNS\u306e\u8a2d\u5b9a\u5909\u66f4\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u305f\u3081\u65e7VPS\u3082\u52d5\u304b\u3057\u7d9a\u3051\u3066\u3044\u307e\u3059\u3002
\n\u3057\u304b\u3057\u3001\u65b0\u65e7VPS\u306e\u540d\u79f0\u3092\u540c\u3058\u306b\u3057\u305f\u305f\u3081\u3001\u65e7VPS\u304b\u3089\u65b0VPS\u3078\u5b9a\u671f\u7684\u306bwordpress\u5185\u90e8\u30a2\u30af\u30bb\u30b9\u304c\u767a\u751f\u3057\u3066\u3044\u308b\u3053\u3068\u306b\u6c17\u4ed8\u304d\u307e\u3057\u305f\u3002\u3053\u308c\u3092\u4fee\u6b63\u3059\u308b\u306b\u306f\u3001\u65e7VPS\u306ewordpress\u306eURL\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3063\u3066\u3053\u3068\u3067\u65e9\u901fmariadb\u306e\u8a72\u5f53URL\u3092\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n
oldvps% mysql -u foo -p dbname\r\n> set autocommit=0;\r\nQuery OK, 0 rows affected (0.004 sec)\r\n> select * from wp_options where option_name = 'siteurl';\r\n+-----------+-------------+--------------------------+----------+\r\n| option_id | option_name | option_value | autoload |\r\n+-----------+-------------+--------------------------+----------+\r\n| 1 | siteurl | https:\/\/www.ish.org\/blog | yes |\r\n+-----------+-------------+--------------------------+----------+\r\n1 row in set (0.001 sec)\r\n> update wp_options set option_value = 'https:\/\/hoge.ish.org\/blog' where option_name = 'siteurl';\r\nQuery OK, 1 row affected (0.006 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0\r\n> select * from wp_options where option_name = 'siteurl';\r\n+-----------+-------------+---------------------------+----------+\r\n| option_id | option_name | option_value | autoload |\r\n+-----------+-------------+---------------------------+----------+\r\n| 1 | siteurl | https:\/\/hoge.ish.org\/blog | yes |\r\n+-----------+-------------+---------------------------+----------+\r\n1 row in set (0.001 sec)\r\n> select * from wp_options where option_name = 'home';\r\n+-----------+-------------+--------------------------+----------+\r\n| option_id | option_name | option_value | autoload |\r\n+-----------+-------------+--------------------------+----------+\r\n| 2 | home | https:\/\/www.ish.org\/blog | yes |\r\n+-----------+-------------+--------------------------+----------+\r\n1 row in set (0.001 sec)\r\n> update wp_options set option_value = 'https:\/\/hoge.ish.org\/blog' where option_name = 'home';\r\nQuery OK, 1 row affected (0.000 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0\r\n> select * from wp_options where option_name = 'home';\r\n+-----------+-------------+---------------------------+----------+\r\n| option_id | option_name | option_value | autoload |\r\n+-----------+-------------+---------------------------+----------+\r\n| 2 | home | https:\/\/hoge.ish.org\/blog | yes |\r\n+-----------+-------------+---------------------------+----------+\r\n1 row in set (0.000 sec)\r\n> commit;\r\nQuery OK, 0 rows affected (0.002 sec)\r\n> exit\r\nBye<\/pre>\n