Title: Dejunk DB
Author: Muhammad Abdullah
Published: <strong>2026 年 3 月 15 日</strong>
Last modified: 2026 年 4 月 4 日

---

搜尋外掛

![](https://ps.w.org/dejunk-db/assets/banner-772x250.png?rev=3482887)

![](https://ps.w.org/dejunk-db/assets/icon-128x128.png?rev=3482887)

# Dejunk DB

 由 [Muhammad Abdullah](https://profiles.wordpress.org/ab16982/) 開發

[下載](https://downloads.wordpress.org/plugin/dejunk-db.1.0.2.zip)

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

 [技術支援](https://wordpress.org/support/plugin/dejunk-db/)

## 外掛說明

Over time, your WordPress database accumulates a massive amount of unnecessary data—
like post revisions, auto-drafts, orphaned metadata, and expired transients. This
bloat slows down your site and increases your backup sizes.

**Dejunk DB** is a lightweight, intuitive, and highly secure tool designed to clean
up this orphaned and duplicated data, optimizing your database for peak performance.

Before making any changes, Dejunk DB provides a built-in **Backup Engine** so you
can safely create a snapshot of your database and download it locally.

### 🚀 Key Features

 * **Built-In Database Backups:** Create, download, and manage secure `.sql` backups
   of your database directly from the plugin dashboard before you clean.
 * **Preview Before Dejunking:** View the exact items (up to 500 records) that are
   flagged for deletion in a clean, AJAX-powered modal so you know exactly what 
   is being removed.
 * **Post Data Cleanup:** Safely remove Post Revisions, Auto Drafts, Trashed Posts,
   and Orphaned Post Meta.
 * **Comment Cleanup:** Quickly delete Unapproved Comments.
 * **User & Term Cleanup:** Clear out Orphaned User Meta and Orphaned Term Relationships.
 * **Options Cleanup:** Flush stale and expired Transient Options (`_transient_`
   and `_site_transient_`) that bloat the `wp_options` table.
 * **Table Optimization:** Run standard MySQL `OPTIMIZE TABLE` commands on all your
   WordPress tables with a single click.
 * **Global “Dejunk Everything” Switch:** A master switch to clean up all identified
   junk sections instantly.
 * **Clean Uninstall:** When you uninstall Dejunk DB, it automatically cleans up
   its transients and securely deletes all backup files it created, leaving zero
   footprint.

_Note: Any dejunking done to your database is irreversible. Please always utilize
the built-in backup tool before running a cleanup._

## 螢幕擷圖

 * [[
 * **Dashboard Overview:** The modern Dejunk DB interface showing Database Backups,
   Dejunk Everything, and specific cleanup categories.
 * [[
 * **Details Modal:** Preview exactly which database rows (Revisions, Transients,
   etc.) are about to be deleted before confirming.
 * [[
 * **Backup Management:** Easily generate, download, or delete `.sql` backup files
   with one click.

## 安裝方式

 1. Upload the `dejunk-db` folder to the `/wp-content/plugins/` directory, or install
    the plugin directly through the WordPress plugins screen by searching for **Dejunk
    DB**.
 2. Activate the plugin through the ‘Plugins’ menu in WordPress.
 3. Navigate to **Tools -> Dejunk DB** in your WordPress admin menu.
 4. **Important:** Click “Create Backup” in the Database Backups card.
 5. Review the junk categories and click “Clean” individually, or use “Run Global Dejunk”
    to clean everything at once.

## 常見問題集

### Is it safe to delete post revisions and orphaned meta?

Yes. Orphaned meta refers to data left behind when a post or user is deleted. Revisions
are old versions of your posts. Removing them will not affect your live website 
content, but will significantly reduce database size.

### Where are the database backups stored?

Backups are stored in your `wp-content/uploads/dejunk-db-backups` directory. The
plugin automatically generates an `.htaccess` file and an `index.php` file inside
this folder to block direct web access, keeping your backups secure.

### Can I restore a backup directly from the plugin?

For strict security compliance, automatic SQL restoration is not included in the
plugin. To restore your database, simply download the `.sql` file from the dashboard
and import it using phpMyAdmin, WP-CLI, or your hosting control panel.

### Does Dejunk DB leave files behind if I uninstall it?

No. Dejunk DB hooks into the WordPress uninstall process. If you delete the plugin
from the WordPress admin, it will automatically remove its generated backup folder
and all `.sql` files to ensure no sensitive data is left behind.

### Why can I only view 500 items in the preview modal?

To prevent memory exhaustion and browser crashing on large sites that may have hundreds
of thousands of junk rows, the preview query is intentionally limited to 500 items.
The “Clean” action, however, will remove all of them.

## 使用者評論

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

## 參與者及開發者

以下人員參與了開源軟體〈Dejunk DB〉的開發相關工作。

參與者

 *   [ Muhammad Abdullah ](https://profiles.wordpress.org/ab16982/)

[將〈Dejunk DB〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/dejunk-db)

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

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

## 變更記錄

#### 1.0.1

 * Security: Removed automated SQL restore functionality for stricter security compliance.
 * Security: Refactored all core database queries to use strict `$wpdb->prepare()`
   parameterization.
 * Security: Added comprehensive nonce verification and capability checks for all
   AJAX actions.
 * UI/UX: Removed inline JavaScript and implemented proper script enqueuing.
 * Fix: Improved backup filename sanitization and backup directory protection.
 * Feature: Added `uninstall.php` cleanup routine to securely remove backups and
   transients upon plugin deletion.

#### 1.0.0

 * Initial public release.

## 中繼資料

 *  版本 **1.0.2**
 *  最後更新 **2 個月前**
 *  啟用安裝數 **少於 10 次**
 *  WordPress 版本需求 ** 5.0 或更新版本 **
 *  已測試相容的 WordPress 版本 **6.9.4**
 *  PHP 版本需求 ** 7.2 或更新版本 **
 *  語言
 * [English (US)](https://wordpress.org/plugins/dejunk-db/)
 * 標籤:
 * [clean](https://tw.wordpress.org/plugins/tags/clean/)[database](https://tw.wordpress.org/plugins/tags/database/)
   [Optimize](https://tw.wordpress.org/plugins/tags/optimize/)[revisions](https://tw.wordpress.org/plugins/tags/revisions/)
 *  [進階檢視](https://tw.wordpress.org/plugins/dejunk-db/advanced/)

## 評分

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

[Your review](https://wordpress.org/support/plugin/dejunk-db/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/dejunk-db/reviews/)

## 參與者

 *   [ Muhammad Abdullah ](https://profiles.wordpress.org/ab16982/)

## 技術支援

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

 [檢視技術支援論壇](https://wordpress.org/support/plugin/dejunk-db/)

## 贊助

想要支援這個外掛的發展嗎？

 [ 贊助這個外掛 ](https://abdullahwp.com)