Title: atec Database Author: docjojo Published: 2024 年 10 月 19 日 Last modified: 2026 年 3 月 24 日 --- 搜尋外掛 ![](https://ps.w.org/atec-database/assets/banner-772x250.png?rev=3172292) ![](https://ps.w.org/atec-database/assets/icon.svg?rev=3172104) # atec Database 由 [docjojo](https://profiles.wordpress.org/docjojo/) 開發 [下載](https://downloads.wordpress.org/plugin/atec-database.1.1.34.zip) * [詳細資料](https://tw.wordpress.org/plugins/atec-database/#description) * [使用者評論](https://tw.wordpress.org/plugins/atec-database/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/atec-database/#installation) * [開發資訊](https://tw.wordpress.org/plugins/atec-database/#developers) [技術支援](https://wordpress.org/support/plugin/atec-database/) ## 外掛說明 atec Database is a powerful plugin that gives you full control over your WordPress database. Features include: * List all database tables with info (size, type, engine, rows)* Optimize, truncate, or drop any table * Clean up spam comments, trashed posts/pages, post revisions, and expired transients * Browse and manage `wp_options` entries * Set or unset autoload flag per option This plugin is lightweight and safe — all destructive actions require confirmation. ### Specifications * Database access: Uses core WPDB methods ### Third-Party Services ### Integrity check Once, when activating the plugin, an integrity check is requested from our server– if you give your permission. Source: https://atecplugins.com/ Privacy policy: https:// atecplugins.com/privacy-policy/ ## 螢幕擷圖 * [[ * All tables * [[ * Comments * [[ * Posts * [[ * Revisions * [[ * Transients * [[ * Options * [[ * Individual table ## 安裝方式 1. Upload the plugin to `/wp-content/plugins/` or install via the WP admin panel. 2. Activate the plugin from the Plugins menu. 3. Select “atec Database” link in admin menu bar. ## 常見問題集 ### Can I break my database with this? Only if you drop essential tables. Be cautious with destructive operations like DROP or TRUNCATE. ### Does this plugin optimize InnoDB tables? Yes. It uses `OPTIMIZE TABLE` where supported. ### Can I remove autoloaded options? Yes, you can toggle the autoload flag for individual `wp_options` entries. ## 使用者評論 ![](https://secure.gravatar.com/avatar/d49c6f2c9c97d616e262c19b80ac95ce47ae471ef39684a0bdccdeacd35011c2? s=60&d=retro&r=g) ### 󠀁[A hidden gem to maintain your WordPress database](https://wordpress.org/support/topic/a-hidden-gem-to-maintain-your-wordpress-database/)󠁿 [Boston Tom](https://profiles.wordpress.org/tneveu/) 2025 年 7 月 16 日 1 則留言 The atec Database plugin is a fantastic little tool that saved me hours of frustration. After trying several other database management plugins—some of which caused more harm than good—atec came to the rescue. With just one click, it cleared over 7,000 post revisions that were bloating my database. The tabbed interface makes it easy to navigate between cleanup tasks, from optimizing tables to fixing indexes and cleaning up comments. You can search, multi-select, and trash orphaned items, and more—no more going into your hosting company’s control panel and using the cumbersome PHPMyAdmin. It even helped me remove leftover clutter from plugins I’d tried once and forgotten about. And for advanced users, there’s an option to run SQL commands directly or upload SQL files. Deleting transients and fixing auto-loaded options is a snap. If you’re relatively new to WordPress databases, atec Database is a safe, user-friendly way to optimize your site. Always make a backup of your DB (it’s good practice) before doing major cleaning. While the plugin is free, the “Pro” version unlocks a ton of extra features. Even better, it gives you access to the Pro versions of over 45 atec plugins via the Deploy plugin. You’ll need to explore their site to see how much is included. The coding genius behind the plugins is incredibly responsive and helpful and is an email away, whether through the plugin support page or their site. And be sure to check out the caching plugins. My site speed improved by over 500%! Can’t beat that for the price. ![](https://secure.gravatar.com/avatar/c131d1fc640702864679d342c9b3ce585db4e8c0afd4c14cc676cdf864de6006? s=60&d=retro&r=g) ### 󠀁[Everything you need](https://wordpress.org/support/topic/everything-you-need-55/)󠁿 [docjojo](https://profiles.wordpress.org/docjojo/) 2024 年 10 月 19 日 Plugin has everything you need to manage, clean up and optimize the WP tables.- List all tables with table info (size, type, engine and number of items).- Optimize, truncate or drop tables.- Delete SPAM in comments, trashed pages/posts, revisions and timed out transients.- List all options and selectively remove some and set autoload option.Well-arranged features, fast and reliable – no gimmicks. [ 閱讀全部 2 則使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/) ## 參與者及開發者 以下人員參與了開源軟體〈atec Database〉的開發相關工作。 參與者 * [ docjojo ](https://profiles.wordpress.org/docjojo/) [將〈atec Database〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/atec-database) ### 對開發相關資訊感興趣？ 任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/atec-database/)、 查看 [SVN 存放庫](https://plugins.svn.wordpress.org/atec-database/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/atec-database/?limit=100&mode=stop_on_copy&format=rss) 訂閱[開發記錄](https://plugins.trac.wordpress.org/log/atec-database/)。 ## 變更記錄 #### 1.1.34 [2026.03.23] * Dashboard undefined issue #### 1.1.33 [2025.12.09] * WP 6.9 tested #### 1.1.32 [2025.12.06] * Minor fixes #### 1.1.31 [2025.12.02] * WP 6.9 tested #### 1.1.30 [2025.12.02] * WP 6.9 tested #### 1.1.29 [2025.11.04] * SVN cleanup #### 1.1.28 [2025.09.27] * Plugin prefix fixed for all #### 1.1.27 [2025.09.09] * Fixed get_plugin_base_root on WIN #### 1.1.26 [2025.08.10] * SVN update and WP clean upload #### 1.1.25 [2025.08.06] * get_plugin_base_root 👈 one level up #### 1.1.24 [2025.08.06] * Fixed get_plugin_base_root on WIN #### 1.1.23 [2025.08.03] * Changes after review #### 1.1.22 [2025.07.30] * WP_PLUGIN_DIR #### 1.1.21 [2025.07.23] * Line 424 in INIT fixed #### 1.1.20 [2025.07.22] * SVN update #### 1.1.19 [2025.07.19] * Framework changes, new ALIAS class #### 1.1.18 [2025.07.09] * $is_table #### 1.1.17 [2025.07.08] * Revisions: $max_age #### 1.1.16 [2025.07.08] * CAST revision age #### 1.1.13 [2025.07.03] * Framework change: Dashboard, SVG #### 1.1.12 [2025.06.28] * Framework change: progress(); ALIAS class #### 1.1.11 [2025.06.26] * Framework change: Removed mixed …$args #### 1.1.10 [2025.06.26] * Framework change, admin_debug_all() #### 1.1.9 [2025.06.25] * New SQL Tab #### 1.1.8 [2025.06.24] * Framework change | License check improved #### 1.1.7 [2025.06.20] * Minor fixes #### 1.1.6 [2025.06.19] * Fixed LOADER for windows #### 1.1.5 [2025.06.19] * fixed flush() #### 1.1.4 [2025.06.19] * normalize_path #### 1.1.3 [2025.06.18] * Nonce issus fixed #### 1.1.2 [2025.06.17] * SVN Update #### 1.1.1 [2025.06.17] * Integrity Fix #### 1.1.0 [2025.06.15] * AWF NextStep #### 1.0.55 [2025.06.15] * Framework change #### 1.0.54 [2025.05.30] * AWF update #### 1.0.40 [2025.05.29] * Framework: New DASHBOARD, removed WIDGET #### 1.0.39 [2025.05.23] * Framework testing #### 1.0.38 [2025.05.15] * new autoloader #### 1.0.37 [2025.05.03] * INIT::maybe_load_assets(**DIR**, \’atec_wpdp\’); #### 1.0.36 [2025.04.30] * AWF now fully namespaced #### 1.0.34 [2025.04.23] * NAMESPACE implemented #### 1.0.33 [2025.04.06] * Framework change #### 1.0.32 [2025.03.28] * class:: fix #### 1.0.31 [2025.03.18] * Added Indexes #### 1.0.30 [2025.03.16] * New style.css and check.css #### 1.0.29 [2025.03.04] * Framework changes #### 1.0.28 [2025.02.15] * (function() { #### 1.0.27 [2025.02.10] * New atec-fs filesystem #### 1.0.26 [2025.02.03] * Updated atec-check.js #### 1.0.25 [2025.02.02] * Framework changes (atec-check) #### 1.0.24 [2025.01.29] * define(\’ATEC_TOOLS_INC\’,true); // just for backwards compatibility #### 1.0.23 [2025.01.26] * switched require_once -> require #### 1.0.22 [2025.01.17] * Check button replaced #### 1.0.21 [2025.01.16] * SVN cleanup #### 1.0.20 [2025.01.08] * Added \”delete\” for table row #### 1.0.19 [2024.12.24] * Fixed style sheet #### 1.0.18 [2024.12.21] * Fixed: atec-wpdb-del-timedout.php not found #### 1.0.17 [2024.12.21] * Clean up #### 1.0.15 [2024.12.21] * New styles, cleaned up .svg #### 1.0.14 [2024.12.17] * Fixed sanitize_text_field($id) #### 1.0.13 [2024.12.07] * Framework update #### 1.0.12 [2024.12.01] * New Column CHECK TABLE #### 1.0.11 [2024.11.27] * Improved plugin activation routine #### 1.0.10 [2024.11.22] * Optimized atec-*-install.php routine #### 1.0.9 [2024.11.24] * remove options with plugin selection #### 1.0.6, 1.0.7, 1.0.8 [2024.10.19] * review – license #### 1.0.3 [2024.09.08] * Options * Tables_in_wordpress fix #### 1.0.2 [2024.08.09] * review #### 1.0.1 [2024.08.03] * Pagination #### 1.0 [2024.08.02] * Initial Release ## 中繼資料 * 版本 **1.1.34** * 最後更新 **2 個月前** * 啟用安裝數 **80+** * WordPress 版本需求 ** 4.9 或更新版本 ** * 已測試相容的 WordPress 版本 **6.9.4** * PHP 版本需求 ** 7.4 或更新版本 ** * 語言 * [English (US)](https://wordpress.org/plugins/atec-database/) * 標籤: * [cleanup](https://tw.wordpress.org/plugins/tags/cleanup/)[database](https://tw.wordpress.org/plugins/tags/database/) [Optimize](https://tw.wordpress.org/plugins/tags/optimize/)[wp db](https://tw.wordpress.org/plugins/tags/wp-db/) [wp options](https://tw.wordpress.org/plugins/tags/wp-options/) * [進階檢視](https://tw.wordpress.org/plugins/atec-database/advanced/) ## 評分 5 星，滿分為 5 星 * [ 2 個 5 星使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=5) * [ 0 個 4 星使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=4) * [ 0 個 3 星使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=3) * [ 0 個 2 星使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=2) * [ 0 個 1 星使用者評論 ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/atec-database/reviews/#new-post) [查看全部使用者評論](https://wordpress.org/support/plugin/atec-database/reviews/) ## 參與者 * [ docjojo ](https://profiles.wordpress.org/docjojo/) ## 技術支援 使用者可在技術支援論壇提出意見反應或使用問題。 [檢視技術支援論壇](https://wordpress.org/support/plugin/atec-database/)