內容簡介
NextGEN Gallery 是 WordPress 中最好的圖片插件之一，如果沒有說是最好的，那也絕對是最好之一。我在許多網站上使用了數年。然而，我注意到了一個問題，一個錯誤，會在 WordPress 的數據庫中留下「孤立的」記錄。我已經向 Imagely 報告了這個問題，他們正在調查。
使用 NextGEN Gallery 可能會在文章和文章元數據數據庫表中留下孤立的記錄，尤其是如果經常添加和刪除相冊。看起來這些孤立的記錄是在上傳期間創建的，因此如果您經常添加圖像，它們會隨著時間積聚。我在一個網站上注意到這一點，我每周上傳數百張圖片，並開始注意到數據庫備份非常大。我開始尋找是什麼原因導致某些表格的大小巨大，我發現了問題。
我創建了這個插件來清理這些孤立的記錄。它會分析 WordPress 表中與 NextGEN 相關的孤立記錄以及 NextGEN 專用表中的孤立記錄。然後顯示每個具體表格中的孤立者數量。如果單擊「Clean」，插件將清理這些孤立的記錄（刪除）。
警告 - 請閱讀此項！
本插件使用時不承擔任何數據損失責任。
使用清理功能前，建議您進行完整備份，以便在出現問題時進行恢復。
本插件的範圍無法涵蓋您可能需要備份和成功還原數據庫表所需的所有信息。但是，我建議閱讀我撰寫的博客文章“27 Essential WordPress Plugins”：https://www.pqinternet.com/technology/27-essential-wordpress-plugins ，並獲取我目前推薦的任何備份插件，目前我推薦 BackWPup（連結在博客文章中，還附有一些註釋）。您可以選擇僅備份本插件清潔的表： wp_ngg_album，wp_ngg_gallery，wp_ngg_pictures，wp_posts，wp_postmeta（請注意， wp_ 前綴在您的系統上可能不同）。我的文章還包含一個鏈接，可以幫助導入大型 sql dump（備份），以防失敗。
閱讀我的博客文章：處理巨大的MySQL數據庫表導出/導入/備份 https://www.pqinternet.com/web-site-design-html-css/handling-huge-mysql-database-table-exports-imports-backups
注意：「分析」和「清理」功能可能需要很長時間才能執行，請耐心等待，不要重新加載頁面！根據表格的大小和數量，「清理」功能可能需要很長時間！
外掛標籤
開發者團隊
② 後台搜尋「pqInternet's NextGEN Database Analysis and Clean-up Tool」→ 直接安裝（推薦）
📦 歷史版本下載
原文外掛簡介
NextGEN Gallery is one of the best, if not THE best image gallery plugins for WordPress. I’ve used it for years on many sites. However I’ve noticed a problem, a bug if you will, that leaves “orphaned” records in the WordPress database. I’ve reported this to Imagely and they’re looking into it.
Using NextGEN Gallery can leave orphaned records in the posts and posts meta database tables, especially if you add and delete galleries often. It appears to me that the orphaned records are created during upload, so if you add images often they will build up over time. I noticed this on a site where I upload hundreds of images a week and started noticing the database backups were extremely large. I started looking for what was causing the huge size of some of the tables and I found the issue.
I created this plugin to clean up the orphaned records. It analyzes the WordPress tables for orphaned records related to NextGEN and in the NextGEN specific tables as well. It then shows you the number of orphans in each specific table. The plugin will clean up these orphaned records (delete), if you click “Clean”.
WARNING – READ THIS!
I assume NO responsibility for any loss of data from using this plugin.
YOU SHOULD MAKE A FULL BACKUP BEFORE USING THE CLEAN FUNCTION, TO ALLOW RECOVERY IF THERE IS A PROBLEM.
It is beyond the scope of this plugin to cover all the information you may need to backup and successfully restore database tables. However I recommend reading my blog post 27 Essential WordPress Plugins: https://www.pqinternet.com/technology/27-essential-wordpress-plugins, and get whatever backup plugin I currently recommend. At the time of writing this sentence, I recommend BackWPup (link in the blog post along with some notes). You can select to backup just the tables this plugin cleans: wp_ngg_album, wp_ngg_gallery, wp_ngg_pictures, wp_posts, wp_postmeta (note that the wp_ prefix may be different on your system). There is also a link in my post to a utility to help import large sql dumps (backups) if they fail.
Read my blog post: Handling Huge MySQL Database Table Exports/Imports/Backups https://www.pqinternet.com/web-site-design-html-css/handling-huge-mysql-database-table-exports-imports-backups
NOTE: The “Analyze” and “Clean” functions can take A LONG TIME to execute, be patient, do not reload the page! The “Clean” function can take a VERY LONG TIME depending on how large and bloated the tables are!
