MainWP Blog - database

One of the most widely used form plugins is WPForms. The lite version of WPForms crossed over 5 million active installs. The WPForms plugin uses the following custom database tables for data storage; wp_wpforms_entries wp_wpforms_entry_meta wp_wpforms_entry_fields wp_wpforms_tasks_meta wp_wpforms_admin_builder_templates_cache_update wp_wpforms_email_summaries_fetch_info_blocks wp_wpforms_process_forms_locator_save wp_wpforms_process_forms_locator_scan wp_wpforms_admin_addons_cache_update The database prefix will differ depending on the table prefix defined in your site’s wp-config.php file. The WPForms plugin has an uninstall option which can be found in the settings menu in wp-admin; WPForms > Settings > Misc Continue reading the post...

The WP Statistics is a widely used plugin with over 600k active installations and is used as a self-hosted solution to track analytics. The WP Statistics plugin uses the following custom database tables for data storage; wp_statistics_exclusions wp_statistics_historical wp_statistics_pages wp_statistics_search wp_statistics_useronline wp_statistics_visit wp_statistics_visitor wp_statistics_visitor_relationships The plugin does not have a built-in way to clean or delete the custom database tables other than manually deleting the custom tables using an application such as phpMyAdmin, or a plugin such as WP-Optimize. If Continue reading the post...

YITH provides many limited free plugins on WordPress.org and premium versions of those plugins. The YITH WooCommerce Wishlist plugin has a constant which would need to be added to the site wp-config.php file that can be used to delete that plugins data; define( 'YITH_WCWL_REMOVE_ALL_DATA', true ); YITH plugins will use YITH or YIT in the options database table. Example names to look for: yith-wcqv-enable yith-wcqv-enable-mobile yith-wcqv-button-label yith-wcqv-background-modal yith-wcqv-close-color yith-wcqv-close-color-hover yit_plugin_fw_panel_wc_default_options_set yith_plugin_fw_promo_2019_bis yith_system_info yith_wcmg_slider_direction yith_wcmg_enable_plugin yith_wcmg_enable_mobile yith_wcmg_force_sizes yith_wcmg_zoom_width yith_wcmg_zoom_height yith_wcmg_zoom_position yith_wcmg_zoom_mobile_position Continue reading the post...

The WP Staging plugin is commonly used to create a staging site if your host does not provide one-click staging site creation. If you no longer need one of the created staging sites, then you can delete it from the UI of the WP Staging plugins. Uninstalling the WP Staging plugin would not delete any staging sites or delete the created database tables for the staging site. Even after deleting a staging site, there might be some left-over database tables Continue reading the post...

Wordfence is a security plugin that can help protect your site. The database tables that the Wordfence plugin uses should be checked for size as part of regular maintenance checks on the site’s database. Wordfence plugin uses many database tables, which were covered before in this article. Below is the Wordfence database table to regularly check for the size; wp_wfHoover You can use a plugin such as WP-Optimize to check the database size. With the plugin installed and active in Continue reading the post...

If you are using the WP Activity Log plugin on your WordPress website for tracking site activity and changes, then it is worth keeping an eye on the site’s database tables that the plugin uses. The WP Activity Log plugin uses the following custom database tables for storage; wp_wsal_metadata wp_wsal_occurrences wp_wsal_sessions If you are already using the WP-Optimize plugin, then you can quickly check the size of the WP Activity Log from wp-admin; WP-Optimize > Database > Tables Then go Continue reading the post...

If you are using the FluentSMTP plugin for sending site emails using a transactional email provider such as AWS SES, Postmark, Sendinblue, SendGrid, or SparkPost then the logs database table could cause a lot of bloat on your site. The below database table for FluentSMTP logs could increase to 5-12 GB in size: wp_fsmpt_email_logs You can use the WP-Optimize plugin or phpMyAdmin to check how large the email logs database table is. With the WP-Optimize plugin installed and activated, go Continue reading the post...

If you are using the SEOPress plugin and want to migrate to a different SEO plugin, you may need to remove the database tables it was using. Before deleting the database tables, make sure that you run the migration from SEOPress to the SEO plugin that you want to replace it with. Here’s the database table that you will need to delete; wp_seopress_significant_keywords Additionally, there will be SEOPress database entries in both the postmeta and options database tables; the entries Continue reading the post...

The WP Offload SES plugin is used to send site emails using the cheapest AWS SES service. WP Offload SES Lite Plugin for WordPress Below are the custom database tables that the WP Offload SES plugin uses; wp_oses_attachments wp_oses_clicks wp_oses_email_attachments wp_oses_emails wp_oses_failures wp_oses_jobs The database table to check; wp_oses_emails From the WP Offload SES plugin settings, check that you are not storing 30+ days or email logging in your site’s database. The ideal setting for log storage would be between Continue reading the post...

If you use the iThemes Security plugin on your WordPress website and want to uninstall it completely, but, the normal uninstallation sometimes leaves the database tables and cron events that you may need to remove manually. This guide is for you! iThemes Security Plugin for WordPress In order to remove the iThemes Security plugin’s database entries, you can use the WP-Optimize plugin as one of the easiest ways to find database tables of iThemes security. After installing and activating the Continue reading the post...