optionsテーブル等の不要データ削除記録

WP-Optimize

table

DROP TABLE `wp_tm_taskmeta`;
DROP TABLE `wp_tm_tasks`;

options record

SELECT *  FROM `wp_options` WHERE `option_name` LIKE '%wp-optimize-%';

• wp-optimize-installed-for
• wp-optimize-schedule
• wp-optimize-last-optimized
• wp-optimize-schedule-type
• wp-optimize-retention-enabled
• wp-optimize-retention-period
• wp-optimize-enable-admin-menu
• wp-optimize-total-cleaned
• wp-optimize-auto
• wp-optimize-settings
• wp-optimize-compression_server
• wp-optimize-image_quality
• wp-optimize-back_up_original
• wp-optimize-back_up_delete_after
• wp-optimize-back_up_delete_after_days
• wp-optimize-is_gzip_compression_enabled
• wp-optimize-corrupted-tables-count
• wp-optimize-enable-auto-backup
• wp-optimize-revisions-retention-enabled
• wp-optimize-logging
• wp-optimize-logging-additional
• wp-optimize-enable-auto-backup-scheduled
• wp-optimize-enable-db-force-optimize
• wp-optimize-install-or-update-notice-version
• wp-optimize-dismiss_dash_notice_until

UpdraftPlus

options record

SELECT * FROM `wp_options` WHERE `option_name` LIKE '%updraft%';

• updraft_task_manager_plugins
• updraft_task_manager_dbversion
• updraft_lock_wpo_page_cache_preloader_creating_tasks
• updraft_lock_wpo_minify_preloader_creating_tasks

Nelio Content

options record

• nc_site_id
• nc_api_secret
• nc_site_limits
• nc_has_social_profiles
• nc_version
• nc_reshare_last_day
• nelio-content_settings

BackWPup

options record

SELECT *  FROM `wp_options` WHERE `option_name` LIKE '%backwp%';

• backwp_opts
• backwpup_cfg_hash
• backwpup_jobs
• backwpup_version
• backwpup_cfg_showadminbar
• backwpup_cfg_showfoldersize
• backwpup_cfg_protectfolders
• backwpup_cfg_jobmaxexecutiontime
• backwpup_cfg_jobstepretry
• backwpup_cfg_jobrunauthkey
• backwpup_cfg_loglevel
• backwpup_cfg_jobwaittimems
• backwpup_cfg_jobdooutput
• backwpup_cfg_windows
• backwpup_cfg_maxlogs
• backwpup_cfg_gzlogs
• backwpup_cfg_logfolder
• backwpup_cfg_httpauthuser
• backwpup_cfg_httpauthpassword
• backwpup_messages
• backwpup_cfg_authentication

Rating-Widget: Star Review System

options record

SELECT * FROM `wp_options` WHERE `option_name` LIKE '%fs\_%';

• fs_active_plugins
• fs_debug_mode
• fs_accounts
• fs_api_cache
• fs_gdpr
• widget_ratingwidgetplugin_topratedwidget

接頭辞「fs_*」のレコードは、このプラグインが使っているFreemius WordPress SDKというライブラリーが生成するレコードのようである。プラグインの有料ライセンスを管理するため？のライブラリーのようだがよく分からない。様々なプラグインで使われているのは間違いないようだ。

Insert Headers And Footers

options record

• insert-headers-and-footers_welcome_dismissed_key

WP to Twitter

postmeta record

SELECT *
FROM `wp_postmeta`
WHERE (
    `meta_key` = '_jd_tweet_this' OR
    `meta_key` = '_jd_wp_twitter' OR
    `meta_key` = '_wpt_tweet_id' OR
    `meta_key` = '_wpt_status_message' OR
    `meta_key` = '_wpt_failed'
);

• _jd_tweet_this
• _jd_wp_twitter
• _wpt_tweet_id
• _wpt_status_message
• _wpt_failed

options record

• jd_last_tweet

WooCommerce

options record

• product_cat_children
• default_product_cat

Japanized For WooCommerce

options record

• wc4jp-*

WP Upload Restriction

options record

• wpur_*

Mailchimp for WooCommerce

table

• wp_mailchimp_carts
• wp_mailchimp_jobs

VK All in One Expansion Unit

options record

• widget_vkexunit_fbpageplugin
• widget_vkexunit_contact
• widget_vkexunit_contact_section
• widget_vkexunit_cta
• widget_vkexunit_post_list
• widget_vkexunit_childpagelist
• widget_wp_widget_vkexunit_profile
• widget_wp_widget_vkexunit_3pr_area
• widget_wp_widget_vkexunit_pr_blocks
• widget_vkexunit_button
• widget_vkexunit_banner
• widget_vk_twitter_widget
• widget_wp_widget_vk_archive_list
• widget_wp_widget_vk_taxonomy_list

WP Downgrade

options record

• wpdg_download_url
• wpdg_edit_download_url
• wpdg_specific_version_name

Count Per Day

table

• wp_cpd_counter

options record

• count_per_day
• widget_countperday_widget
• widget_countperday_popular_posts_widget
• count_per_day_online
• count_per_day_search
• count_per_day_summary

All-in-One WP Migration

options record

• ai1wm_updater
• ai1wm_secret_key
• ai1wm_status
• ai1wm_backups_labels
• _site_transient_ai1wm_last_check_for_updates

WP Migrate Lite Compatibility

options record

• wpmdb_settings
• wpmdb_saved_profiles
• wpmdb_recent_migrations
• wpmdb_remote_migration_state
• wpmdb_schema_version
• wpmdb_usage
• _site_transient_wpmdb_disabled_legacy_addons

Custom Post Type UI

options record

• cptui_new_install
• cptui_post_types

Really Simple SSL

options record

• rlrsssl_options
• rsssl_activation_timestamp

WP Social Bookmarking Light

options record

• wp_social_bookmarking_light_options

Breadcrumb NavXT

options record

• widget_bcn_widget
• bcn_version
• bcn_options
• bcn_options_bk

WordPress File Upload

options record

• widget_wordpress_file_upload_widget
• wordpress_file_upload_last_idlog
• wordpress_file_upload_table_dbxqueue_version
• wordpress_file_upload_table_log_version
• wordpress_file_upload_table_userdata_version

WordPress Flash Uploader

options record

• WFUAdminOptions

WP File Manager

options record

• filemanager_email_verified_*
• filemanager_email_address_*
• verify_filemanager_fname_*
• verify_filemanager_lname_*
• filemanager_cancel_lk_popup_*

YARPP – Yet Another Related Posts Plugin

プラグイン削除と同時にoptionsテーブルのデータも削除されたが一応記録。

options record

• widget_yarpp_widget
• yarpp_pro
• yarpp
• yarpp_fulltext_disabled
• yarpp_version
• yarpp_activate_timestamp
• yarpp_version_info_timeout

All In One SEO Pack

options record

• aioseop_options
• aioseop_notices
• aioseop_detected_conflicting_plugins
• _transient_timeout_aioseop_feed

LightStart – Maintenance Mode, Coming Soon and Landing Page Builder（WP Maintenance Mode）

プラグイン削除と同時にwp_wpmm_subscribersとoptionsテーブルのデータも削除されたが一応記録。

table

wp_wpmm_subscribers

options record

• wpmm_settings
• wpmm_version
• wpmm_activated