如何變更 WordPress 連線網址
WordPress 是目前世界上最多網站使用的內容管理系統,前陣子剛好有一個網站需要變更網址,修改的方式可以透過後台(設定 > 一般 > WordPress 位置)進行設定,如下:
查了一下資料發現除了透過 WorePress 後台的網址設定功能以外,針對資料庫的資料可能也需要進行刷新,整理刷新 URL 的 SQL 如下,需要進入 MySQL 執行 Query。
1 2 3 4 5 6 7 8 |
<span class="jush"><span class="jush-sql_code"><a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/update.html" target="_blank" rel="noreferrer noopener">UPDATE</a> <a class="jush-custom" href="https://part.gapple3c.toright.com/adminer.php?server=10.140.0.2&username=root&db=wp_philia.tw&table=wp_posts">wp_posts</a> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html" target="_blank" rel="noreferrer noopener">SET</a> guid=<a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace" target="_blank" rel="noreferrer noopener">REPLACE</a>(guid,<span class="jush-sql_apo"><span class="jush-op">'</span>https://old.com.tw<span class="jush-op">'</span></span>,<span class="jush-sql_apo"><span class="jush-op">'</span>https://new.com.tw<span class="jush-op">'</span></span>)<span class="jush-op">;</span></span><span class="jush-sql_code"> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/update.html" target="_blank" rel="noreferrer noopener">UPDATE</a> <a class="jush-custom" href="https://part.gapple3c.toright.com/adminer.php?server=10.140.0.2&username=root&db=wp_philia.tw&table=wp_posts">wp_posts</a> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html" target="_blank" rel="noreferrer noopener">SET</a> post_content=<a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace" target="_blank" rel="noreferrer noopener">REPLACE</a>(post_content,<span class="jush-sql_apo"><span class="jush-op">'</span>https://old.com.tw<span class="jush-op">'</span></span>,<span class="jush-sql_apo"><span class="jush-op">'</span>https://new.com.tw<span class="jush-op">'</span></span>)<span class="jush-op">;</span></span><span class="jush-sql_code"> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/update.html" target="_blank" rel="noreferrer noopener">UPDATE</a> <a class="jush-custom" href="https://part.gapple3c.toright.com/adminer.php?server=10.140.0.2&username=root&db=wp_philia.tw&table=wp_options">wp_options</a> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html" target="_blank" rel="noreferrer noopener">SET</a> option_value=<a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace" target="_blank" rel="noreferrer noopener">REPLACE</a>(option_value,<span class="jush-sql_apo"><span class="jush-op">'</span>https://old.com.tw<span class="jush-op">'</span></span>,<span class="jush-sql_apo"><span class="jush-op">'</span>https://new.com.tw<span class="jush-op">'</span></span>)<span class="jush-op">;</span></span><span class="jush-sql_code"> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/update.html" target="_blank" rel="noreferrer noopener">UPDATE</a> <a class="jush-custom" href="https://part.gapple3c.toright.com/adminer.php?server=10.140.0.2&username=root&db=wp_philia.tw&table=wp_postmeta">wp_postmeta</a> <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html" target="_blank" rel="noreferrer noopener">SET</a> meta_value = <a class="jush-help" href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace" target="_blank" rel="noreferrer noopener">REPLACE</a>(meta_value,<span class="jush-sql_apo"><span class="jush-op">'</span>https://old.com.tw<span class="jush-op">'</span></span>,<span class="jush-sql_apo"><span class="jush-op">'</span>https://new.com.tw<span class="jush-op">'</span></span>)<span class="jush-op">; </span></span></span> |
這樣就完成囉,Good Luck~