我的網域即將到期，由於 godaddy 的續約價太盤我就直接到 cloudflare 買了個便宜的新網域但更換…
我原先在文章內插入圖片時，都是選擇 從網址插入媒體
然後輸入 https://blog.joda.tw/wp-content/uploads/imgs/…../xxx.jpg
而新的網域是 yuru.app
要把所有文章的圖片網址改成 https://blog.yuru.app/wp-content/uploads/imgs/…../xxx.jpg
一篇一篇的修改文章內容太慢了
可以透過下面方式，wordpress 批次修改文章內容
wordpress 的原始文章是存放在資料庫內的
所以我們直接連進資料庫下語法，就可以一次把所有文章的圖片網址更換
UPDATE wp_posts SET post_content = REPLACE(post_content, 'joda.tw', 'yuru.app');另外，想從遠端連線到 NAS 的資料庫內，需要設定權限
ssh 進 NAS 後，參照下面步驟
# 1.連進資料庫
mysql -u root -p
# 2.輸入正確的密碼後，就可進入DB CLI
# 3. 設置使用者權限，單引號都要留著，IP是要連進資料庫的那台電腦的IP
GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'IP' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
# 4. 重新載入權限表
FLUSH PRIVILEGES;
Great breakdown of poker strategy – it’s all about reading the game and adapting. Just like how I use the AI Reviews Assistant to stay ahead with curated insights.
Great breakdown of poker strategy – it’s all about reading the game and adapting. Just like how I use the AI Reviews Assistant to stay ahead with curated insights.
B52cc sounds interesting. What kind of action do they have there? Anyone cracked the code and made some serious cash? I’m game! See what’s up: b52cc
WinPH5, yeah I’ve heard of it. Anyone actually win big there? Thinking about trying it out. Let me know if it’s legit! Gotta check out winph5
WinPH5, yeah I’ve heard of it. Anyone actually win big there? Thinking about trying it out. Let me know if it’s legit! Gotta check out winph5
Interesting read! Seeing platforms like bet 100 casino prioritize quick verification (94.7% approval!) is huge for trust. Makes the whole experience smoother, especially with options like GCash too. What are your thoughts on data-driven gaming?
Interesting read! Seeing platforms like bet 100 casino prioritize quick verification (94.7% approval!) is huge for trust. Makes the whole experience smoother, especially with options like GCash too. What are your thoughts on data-driven gaming?
Excellent SQL tip for domain migrations! This REPLACE command approach is far more efficient than manual updates. For those managing content-heavy sites, similar database optimization strategies apply across platforms. Mobile-optimized platforms like phonejoy also benefit from streamlined backend operations. Thanks for sharing this practical WordPress solution!
Interesting analysis! Seeing more platforms like fanduel enter the Philippines is great for players – more choice & competition. Secure verification is key, as they highlight, for a reliable experience. Solid points made in the article!