內容簡介
Overl1te Migration SQL 是一款幫助用戶在不同環境之間遷移 WordPress 網站的外掛，透過生成 SQL 語句讓用戶自行執行，確保在執行前不會改變現有資料庫。
【主要功能】
• 匯出資料表結構及可選的 INSERT 資料
• 生成 UPDATE … REPLACE 語句以更改 URL
• 預覽符合條件的資料列數量（乾跑）
• 上傳生產環境的 .sql 檔案並生成修補程式
• 複製安全的 WP-CLI 搜尋替換命令
外掛標籤
開發者團隊
原文外掛簡介
Overl1te Migration SQL helps you move a WordPress site between environments by generating SQL you run yourself. It does not change the live database until you (or your DBA) execute the generated statements.
The plugin is intended for administrators who already make database backups and understand SQL. Typical uses:
Export table structure and optional INSERT data, with the new domain substituted in text values.
Generate UPDATE … REPLACE statements for selected tables when only URLs need to change.
Preview how many rows would match (dry run) before you generate replacement SQL.
Upload a production .sql dump, detect its prefix and domain, and generate a finish patch (URL replace, prefix rename, missing columns).
Copy ready-made WP-CLI search-replace commands, which are safer for serialized data.
What it does not do
It does not execute migration SQL against production for you.
It does not upload dumps to a remote host or phone home.
It does not rewrite post GUIDs (by design).
Plain SQL REPLACE can break PHP serialized strings. Use WP-CLI for those leftovers.
Safety
Only users with the manage_options capability can open the plugin. All form actions use WordPress nonces. Uploaded dumps are read from the temporary upload file and are not stored in the media library. Always take a full database backup before running generated SQL.
Privacy
The plugin stores a short generation history in a WordPress option on the site where it is installed. History and SQL transients are removed when you uninstall the plugin. No data is sent to third parties.
