Title: Fruti Serialized Data Audit
Author: frutilabs
Published: <strong>2026 年 9 月 28 日</strong>
Last modified: 2026 年 9 月 28 日

---

搜尋外掛

![](https://ps.w.org/fruti-serialized-data-audit/assets/banner-772x250.png?rev=3717392)

![](https://ps.w.org/fruti-serialized-data-audit/assets/icon-256x256.png?rev=3717392)

# Fruti Serialized Data Audit

 由 [frutilabs](https://profiles.wordpress.org/frutilabs/) 開發

[下載](https://downloads.wordpress.org/plugin/fruti-serialized-data-audit.1.0.0.zip)

 * [詳細資料](https://tw.wordpress.org/plugins/fruti-serialized-data-audit/#description)
 * [使用者評論](https://tw.wordpress.org/plugins/fruti-serialized-data-audit/#reviews)
 *  [安裝方式](https://tw.wordpress.org/plugins/fruti-serialized-data-audit/#installation)
 * [開發資訊](https://tw.wordpress.org/plugins/fruti-serialized-data-audit/#developers)

 [技術支援](https://wordpress.org/support/plugin/fruti-serialized-data-audit/)

## 外掛說明

A plain find-and-replace on a WordPress database, or a hand-edited export, changes
the text inside
 serialized values but not the byte-length prefix PHP stored with
every string. The import then reports success, and widgets, theme settings, page-
builder layouts or plugin options quietly disappear. This plugin reads a `.sql` 
dump, parses every serialized payload it finds, and lists the ones that are structurally
broken, with the line number, the table it belongs to, the reason and a short snippet.

Detected structural problems:

 * `string_length_mismatch` – a string’s declared byte length no longer matches 
   its content, the
    classic result of a naive search-and-replace or of a UTF-8/
   latin1 conversion.
 * `count_mismatch` – an array or object declares more items than it contains.
 * `truncated` – the payload ends in the middle of a structure.
 * `invalid_type` – a payload starts but the expected next token is not a valid 
   serialized value.

Supported serialization tokens: `N`, `b`, `i`, `d`, `s`, `a`, `O`, `r`, `R`, `E`
and `C`, in both
 plain and `mysqldump`-escaped form. `C:` payloads are treated 
as opaque bytes and are never parsed recursively.

The plugin never modifies your data. It does not import the dump, does not connect
to the database,
 does not execute SQL and does not write a repaired file. It only
reports.

#### How to use it

 1. Export the database you are about to import: `mysqldump -u user -p dbname > dump.
    sql`.
 2. Open Tools -> Fruti Serialized Data Audit, choose that `.sql` file and press Run
    Audit.
 3. Read the summary and the list of broken payloads: status, table, line, reason and
    snippet.
 4. Fix the cause with `wp search-replace` or a serialization-aware replacement, export
    a fresh dump
     and audit it again.

#### Privacy

The uploaded SQL file is processed locally on your own WordPress server. It is analysed
in PHP’s
 upload temporary file: it is not copied into the media library, not placed
in `wp-content/uploads`, not saved in the plugin directory, not stored in the database
and not written to logs or cache. The plugin makes no network requests, sends no
telemetry and does not transmit the dump anywhere.

#### Support

Questions, bug reports and support: hello@fruti.lt

## 螢幕擷圖

[⌊The audit result after a run: how many structurally broken payloads were found
in the uploaded dump.⌉⌊The audit result after a run: how many structurally broken
payloads were found in the uploaded dump.⌉[

The audit result after a run: how many structurally broken payloads were found in
the uploaded dump.

[⌊The findings table: line, table, reason and snippet for every broken payload, 
read-only and nothing changed.⌉⌊The findings table: line, table, reason and snippet
for every broken payload, read-only and nothing changed.⌉[

The findings table: line, table, reason and snippet for every broken payload, read-
only and nothing changed.

## 安裝方式

 1. Upload the plugin folder to `/wp-content/plugins/`, or install the ZIP through 
    Plugins -> Add New -> Upload Plugin.
 2. Activate the plugin through the Plugins screen.
 3. Go to Tools -> Fruti Serialized Data Audit.

## 常見問題集

### Does the plugin change or repair my dump?

No. It is strictly read-only and reports findings only. Fix the underlying cause(
use
 wp search-replace or a serialization-aware replacement), then export a new 
dump and audit it again.

### Which file types are accepted?

Only `.sql`. Archives such as `.zip` or `.gz` are not unpacked: extract the dump
first.

### What happens with very large dumps?

The dump is read into memory for analysis, so extremely large files may exceed the
memory limit of
 your server. The plugin refuses files above 256 MB and shows a 
message; split larger dumps and audit the parts separately.

### Does the plugin send my dump anywhere?

No. Everything happens inside your own admin request on your own server. There is
no external
 service, no account, no API call and no telemetry, and the uploaded
file is discarded when the request ends.

## 使用者評論

這個外掛目前沒有任何使用者評論。

## 參與者及開發者

以下人員參與了開源軟體〈Fruti Serialized Data Audit〉的開發相關工作。

參與者

 *   [ frutilabs ](https://profiles.wordpress.org/frutilabs/)

[將〈Fruti Serialized Data Audit〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/fruti-serialized-data-audit)

### 對開發相關資訊感興趣？

任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/fruti-serialized-data-audit/)、
查看 [SVN 存放庫](https://plugins.svn.wordpress.org/fruti-serialized-data-audit/)，
或透過 [RSS](https://plugins.trac.wordpress.org/log/fruti-serialized-data-audit/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/fruti-serialized-data-audit/)。

## 變更記錄

#### 1.0.0

 * First release. Bundles parser core 1.0.4, which supports `N`, `b`, `i`, `d`, `
   s`, `a`, `O`, `r`,
    R, `E` and `C` tokens in plain and `mysqldump`-escaped form.

## 中繼資料

 *  版本 **1.0.0**
 *  最後更新 **6 天前**
 *  啟用安裝數 **少於 10 次**
 *  WordPress 版本需求 ** 6.0 或更新版本 **
 *  已測試相容的 WordPress 版本 **7.1.2**
 *  PHP 版本需求 ** 8.1 或更新版本 **
 *  語言
 * [English (US)](https://wordpress.org/plugins/fruti-serialized-data-audit/)
 * 標籤:
 * [database](https://tw.wordpress.org/plugins/tags/database/)[debug](https://tw.wordpress.org/plugins/tags/debug/)
   [migration](https://tw.wordpress.org/plugins/tags/migration/)[serialized data](https://tw.wordpress.org/plugins/tags/serialized-data/)
 *  [進階檢視](https://tw.wordpress.org/plugins/fruti-serialized-data-audit/advanced/)

## 評分

這個項目尚無任何評論記錄。

[撰寫評分](https://wordpress.org/support/plugin/fruti-serialized-data-audit/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/fruti-serialized-data-audit/reviews/)

## 參與者

 *   [ frutilabs ](https://profiles.wordpress.org/frutilabs/)

## 技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

 [檢視技術支援論壇](https://wordpress.org/support/plugin/fruti-serialized-data-audit/)