从WordPress删除插件时，数据库中可能会剩下很多东西，这使数据库不必要地变大，甚至可能减慢查询速度。删除插件后清理WordPress数据库始终是一个好习惯。最近将一个客户网站启用非常轻量的GeneratePress主题，并决定将页面构建插件Elementor改为相对轻量的Beaver Builder，自然而然地需要理数据库。
本文将介绍删除Elementor插件后，以从options、postmeta、usermeta、posts表中删除剩余的数据。
主要包含以下内容：
- 删除Elementor插件和文件
- 删除Elementor文章类型
- 删除Elementor分类
- 从usermeta和postmeta删除Elementor meta_keys
- 从wp_options删除Elementor选项
删除Elementor插件和文件
wp plugin delete elementor --allow-root wp plugin delete elementor-pro --allow-rootrm -rf wp-content/uploads/elementor 删除Elementor文章类型
列出文章类型，并查看Elementor是否在其中
wp post-type list --allow-root | grep elementor 在这里我没找到相关信息。下面开始查找数据库：
wp db query "SELECT DISTINCT(post_type) FROM $(wp db prefix --allow-root)posts" --allow-root elementor_library post类型在这里！
+---------------------+ | post_type | +---------------------+ | amn_exact-metrics | | attachment | | custom_css | | customize_changeset | | download | | edd_log | | edd_payment | | elementor_library | | gp_elements | | nav_menu_item | | oembed_cache | | page | | post | | pretty-link | | revision | | wpcf7_contact_form | +---------------------+现在可以删除所有elementor_library post了
先列出它们：
wp post list --post_type=elementor_library --post_status=draft,revision,publish --allow-root 输出：
+-----+---------------------+---------------------+---------------------+-------------+ | ID | post_title | post_name | post_date | post_status | +-----+---------------------+---------------------+---------------------+-------------+ | 217 | Default Kit | default-kit | 2020-03-08 00:05:51 | publish | | 112 | WP css2js Minify | wp-css2js-minify | 2016-12-10 22:13:29 | publish | | 64 | Works with template | works-with-template | 2016-10-30 20:02:04 | publish | | 18 | Home Final Final | home-final-final | 2016-10-26 13:52:42 | publish | +-----+---------------------+---------------------+---------------------+-------------+为了删除这些，必须使用--force，否则将出现以下错误：
Warning: Posts of type 'elementor_library' do not support being sent to trash. Please use the --force flag to skip trash and delete them permanently.使用WP-CLI删除elementor_library所有文章的命令：
wp post delete $(wp post list --post_type=elementor_library --post_status=draft,revision,publish --allow-root --skip-plugins --format=ids) --force --allow-root应该看到类似这样的输出：
Success: Deleted post 217. Success: Deleted post 112. Success: Deleted post 64. Success: Deleted post 18.删除Elementor分类
在搜索数据库时，我发现分类表中有Elementor引用，因此请确认你也有这些引用！
这是在数据库中搜索elementor字符串的结果。
wp_posts:post_type 18:elementor_library wp_posts:post_type 64:elementor_library wp_posts:post_type 112:elementor_library wp_posts:post_type 217:elementor_library wp_term_taxonomy:taxonomy 5:elementor_library_type wp_term_taxonomy:taxonomy 6:elementor_library_type计算分类表中的Elementor行数：
wp db query "SELECT COUNT(*) AS ElementorTaxonomy FROM $(wp db prefix --allow-root)term_taxonomy WHERE taxonomy LIKE '%elementor%'" --allow-root输出：
+-------------------+ | ElementorTaxonomy | +-------------------+ | 2 | +-------------------+现在可以删除这些了
wp db query "DELETE FROM $(wp db prefix --allow-root)term_taxonomy WHERE taxonomy LIKE '%elementor%'" --allow-root清理Elementor postmeta
列出postmeta包含字符串elementor的表：
wp db query "SELECT DISTINCT(meta_key) FROM $(wp db prefix --allow-root)postmeta" --allow-root | grep elementor输出：
_elementor_data _elementor_edit_mode _elementor_template_type _elementor_version _elementor_conditions _elementor_page_settings _elementor_pro_version _elementor_template_widget_type _elementor_global_widget_included_posts _elementor_template_sub_type _elementor_popup_display_settings _elementor_source_image_hash _elementor_controls_usage _elementor_css计算一下有多少Elementor Postmeta：
wp db query "SELECT COUNT(*) AS ElementorPostMeta FROM $(wp db prefix --allow-root)postmeta WHERE meta_key LIKE '%elementor%'" --allow-root输出：
+-------------------+ | ElementorPostMeta | +-------------------+ | 52 | +-------------------+删除所有Elementor postmeta条目
wp db query "DELETE FROM $(wp db prefix --allow-root)postmeta WHERE meta_key LIKE '%elementor%'" --allow-root清理Elementor usermeta
wp db query "SELECT DISTINCT(meta_key) FROM wp_usermeta" --allow-root | grep elementor输出：
elementor_introduction elementor_admin_notices wp_elementor_connect_common_data计算行数：
wp db query "SELECT COUNT(*) AS ElementorUserMeta FROM $(wp db prefix --allow-root)usermeta WHERE meta_key LIKE '%elementor%'" --allow-root输出：
+-------------------+ | ElementorUserMeta | +-------------------+ | 2 | +-------------------+清理：
wp db query "DELETE FROM $(wp db prefix --allow-root)usermeta WHERE meta_key LIKE '%elementor%'" --allow-root清理Elementor选项（Options）
检查网站上自动加载的数据量，越少越好！
+-----------------------+---------+--------------------------------------------------------------------+ | name | status | message | +-----------------------+---------+--------------------------------------------------------------------+ | autoload-options-size | success | Autoloaded options size (116.58kb) is less than threshold (900kb). | +-----------------------+---------+--------------------------------------------------------------------+列出属于Elementor的选项
wp option list --field=option_name --allow-root | grep elementor输出：
elementor_active_kit elementor_allow_svg elementor_allow_tracking elementor_beta elementor_clear_cache elementor_connect_site_key elementor_container_width elementor_controls_usage elementor_cpt_support elementor_css_print_method elementor_custom_icon_sets_config elementor_default_generic_fonts elementor_disable_color_schemes elementor_disable_typography_schemes elementor_edit_buttons elementor_editor_break_lines elementor_enable_inspector elementor_exclude_user_roles elementor_font_awesome_pro_kit_id elementor_fonts_manager_fonts elementor_fonts_manager_font_types _elementor_general_settings _elementor_global_css elementor_global_image_lightbox elementor_icon_manager_needs_update _elementor_installed_time elementor_library_category_children elementor_load_fa4_shim elementor_log elementor_maintenance_mode_exclude_mode elementor_maintenance_mode_exclude_roles elementor_maintenance_mode_mode elementor_maintenance_mode_template_id elementor_page_title_selector elementor_pro_activecampaign_api_key elementor_pro_activecampaign_api_url elementor_pro_convertkit_api_key elementor_pro_donreach_api_key elementor_pro_donreach_api_url elementor_pro_drip_api_token elementor_pro_facebook_app_id elementor_pro_getresponse_api_key _elementor_pro_installed_time elementor_pro_license_key elementor_pro_mailchimp_api_key elementor_pro_mailerlite_api_key elementor_pro_recaptcha_secret_key elementor_pro_recaptcha_site_key elementor_pro_recaptcha_v3_secret_key elementor_pro_recaptcha_v3_site_key elementor_pro_recaptcha_v3_threshold elementor_pro_theme_builder_conditions elementor_pro_tracker_notice elementor_pro_upgrades elementor_pro_version elementor_remote_info_feed_data elementor_remote_info_library elementor_remote_info_templates_data elementor_replace_url elementor_reset_api_data elementor_rollback elementor_rollback_pro elementor_rollback_pro_separator elementor_scheme_color elementor_scheme_color-picker _elementor_scheme_last_updated elementor_scheme_typography _elementor_settings_update_time elementor_space_between_widgets elementor_stretched_section_container elementor_tracker_last_send elementor_tracker_notice elementor_typekit-kit-id elementor_upgrades elementor_use_mini_cart_template elementor_validate_api_data elementor_version elementor_viewport_lg elementor_viewport_md plugin_last_upgraded_date_elementor plugin_last_upgraded_date_elementor-pro-elementor-pro-php plugin_last_upgraded_version_elementor plugin_last_upgraded_version_elementor-pro-elementor-pro-php widget_elementor-library计算行数：
wp db query "SELECT COUNT(*) AS ElementorOptions FROM $(wp db prefix --allow-root)options WHERE option_name LIKE '%elementor%'" --allow-root输出：
+------------------+ | ElementorOptions | +------------------+ | 79 | +------------------+从wp_options表中删除所有Elementor设置：
wp db query "DELETE FROM $(wp db prefix --allow-root)options WHERE option_name LIKE '%elementor%'" --allow-root清理脚本
这是以上所有步骤的脚本，用于清理删除Elementor插件后清理WordPress数据库。
#!/usr/bin/env/bash # Purpose - clean Elementor leftover database rows from WordPress # Mike from https://zhanzhangb.com # deactivate and delete wp plugin deactivate elementor --allow-root wp plugin deactivate elementor-pro --allow-root wp plugin delete elementor --allow-root wp plugin delete elementor-pro --allow-root # clean up leftover Elementor uploads rm -rf wp-content/uploads/elementor # taxonomy wp db query "DELETE FROM $(wp db prefix --allow-root)term_taxonomy WHERE taxonomy LIKE '%elementor%'" --allow-root # custom post types wp post delete $(wp post list --post_type=elementor_library --post_status=draft,revision,publish --allow-root --skip-plugins --format=ids) --force --allow-root # postmeta wp db query "DELETE FROM $(wp db prefix --allow-root)postmeta WHERE meta_key LIKE '%elementor%'" --allow-root # usermeta wp db query "DELETE FROM $(wp db prefix --allow-root)usermeta WHERE meta_key LIKE '%elementor%'" --allow-root # options wp db query "DELETE FROM $(wp db prefix --allow-root)options WHERE option_name LIKE '%elementor%'" --allow-root声明：
1.本站大部分内容均收集于网络!若内容若侵犯到您的权益，请发送邮件至：ceo@zunw.cn，我们将第一时间处理！
2.资源所需价格并非资源售卖价格，是收集、整理、编辑详情以及本站运营的适当补贴，并且本站不提供任何免费技术支持
3.所有资源仅限于参考和学习，版权归原作者所有，更多请阅读网站声明。
