Title: Overl1te Migration SQL Author: overl1te Published: 2026 年 8 月 25 日 Last modified: 2026 年 8 月 25 日 --- 搜尋外掛 ![](https://ps.w.org/overl1te-migration-sql/assets/banner-772x250.png?rev=3665491) ![](https://ps.w.org/overl1te-migration-sql/assets/icon-256x256.png?rev=3665491) # Overl1te Migration SQL 由 [overl1te](https://profiles.wordpress.org/overl1te/) 開發 [下載](https://downloads.wordpress.org/plugin/overl1te-migration-sql.1.3.1.zip) * [詳細資料](https://tw.wordpress.org/plugins/overl1te-migration-sql/#description) * [使用者評論](https://tw.wordpress.org/plugins/overl1te-migration-sql/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/overl1te-migration-sql/#installation) * [開發資訊](https://tw.wordpress.org/plugins/overl1te-migration-sql/#developers) [技術支援](https://wordpress.org/support/plugin/overl1te-migration-sql/) ## 外掛說明 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. ## 安裝方式 1. Upload the `overl1te-migration-sql` folder to the `/wp-content/plugins/` directory, or install the zip via Plugins Add New Upload Plugin. 2. Activate the plugin through the Plugins screen. 3. Open **Migration SQL** in the admin menu. 4. Generate SQL, download the `.sql` file, and run it on the target database after a backup. ## 常見問題集 ### Does this plugin modify my database? No. It generates SQL (and WP-CLI commands) for you to review and run. The dry-run action only counts matching rows. ### Will serialized data stay valid? SQL `REPLACE()` does not update serialized string lengths. After a domain change, run WP-CLI `search-replace` for remaining serialized values. The plugin prints those commands on its admin page. ### Does it support WordPress multisite? Yes. On a network it can include tables for all sites (blog prefixes plus shared tables such as usermeta). ### Why are post GUIDs left unchanged? WordPress uses `guid` as a unique identifier, not as a public permalink. Changing it is usually unnecessary and can confuse feed readers. ### What should I do after importing SQL? Visit Settings Permalinks and click Save. Then verify `siteurl` / `home` and log in on the target site. ### Can I restore a previous SQL generation? The plugin keeps the last five generations. Structure dumps with INSERT data store only a preview in history; download the full SQL while it is still on the page. ## 使用者評論 這個外掛目前沒有任何使用者評論。 ## 參與者及開發者 以下人員參與了開源軟體〈Overl1te Migration SQL〉的開發相關工作。 參與者 * [ overl1te ](https://profiles.wordpress.org/overl1te/) [將〈Overl1te Migration SQL〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/overl1te-migration-sql) ### 對開發相關資訊感興趣？ 任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/overl1te-migration-sql/)、 查看 [SVN 存放庫](https://plugins.svn.wordpress.org/overl1te-migration-sql/)，或 透過 [RSS](https://plugins.trac.wordpress.org/log/overl1te-migration-sql/?limit=100&mode=stop_on_copy&format=rss) 訂閱[開發記錄](https://plugins.trac.wordpress.org/log/overl1te-migration-sql/)。 ## 變更記錄 #### 1.3.1 * Rename the plugin to Overl1te Migration SQL to follow WordPress.org naming guidelines. * Update Tested up to WordPress 7.1. #### 1.3.0 * Prepare the plugin for the WordPress.org directory: English UI, readme.txt, uninstall cleanup, and enqueued assets. * Switch the license to MIT. #### 1.2.0 * Add production-dump analysis, dry run, generation history, SQL download, and WP-CLI helpers. #### 1.0.0 * Initial release: table structure SQL and domain replacement SQL. ## 中繼資料 * 版本 **1.3.1** * 最後更新 **1 週前** * 啟用安裝數 **少於 10 次** * WordPress 版本需求 ** 5.8 或更新版本 ** * 已測試相容的 WordPress 版本 **7.1** * PHP 版本需求 ** 7.4 或更新版本 ** * 語言 * [English (US)](https://wordpress.org/plugins/overl1te-migration-sql/) * 標籤: * [database](https://tw.wordpress.org/plugins/tags/database/)[import](https://tw.wordpress.org/plugins/tags/import/) [migration](https://tw.wordpress.org/plugins/tags/migration/)[search replace](https://tw.wordpress.org/plugins/tags/search-replace/) [sql](https://tw.wordpress.org/plugins/tags/sql/) * [進階檢視](https://tw.wordpress.org/plugins/overl1te-migration-sql/advanced/) ## 評分 這個項目尚無任何評論記錄。 [撰寫評分](https://wordpress.org/support/plugin/overl1te-migration-sql/reviews/#new-post) [查看全部使用者評論](https://wordpress.org/support/plugin/overl1te-migration-sql/reviews/) ## 參與者 * [ overl1te ](https://profiles.wordpress.org/overl1te/) ## 技術支援 使用者可在技術支援論壇提出意見反應或使用問題。 [檢視技術支援論壇](https://wordpress.org/support/plugin/overl1te-migration-sql/)