MainWP Blog

How to Easily Check Your WordPress Site's Database Usage
Tips & Tricks
Sebastian Moran

How to Get an Easy Overview of Your WordPress Site Database Usage

Keeping an eye on your WordPress site’s database usage helps you optimize it when needed. The latest plugin developed by 99w allows users to obtain a thorough overview of their database usage and the option to view the size of individual database tables within their WordPress site’s database. The plugin is called Database Table Overview and Logs and when installed and activated, it will add a new menu in wp-admin, “Database Table Overview & Logs.” The free version of the plugin includes several useful features, such as; List of all database tables, including name, size, and rows Preview a record

Sebastian Moran March 22, 2023 2 Comments
Code Snippets - WordPress 6.2
Tips & Tricks
Sebastian Moran

Useful Code Snippets for WordPress 6.2

WordPress 6.2, the next major release of WordPress core, is scheduled for March 28th. The new version of WordPress comes with many feature improvements and enhancements, but you may not want to use them. Here are some code snippets to disable certain features: 1) To disable the new Openverse category from showing in the new media tab in the block editor, you can use this code snippet. add_filter( ‘block_editor_settings_all’, function( $settings ) { $settings[‘enableOpenverseMediaCategory’] = false;return $settings; }, 10 ); Let’s discuss 2) There is a new filter wp_save_post_revision_revisions_before_deletion which can be used to delete all but the oldest post

Sebastian Moran March 15, 2023 No Comments
Remove Zero Spam Plugin Unused Data
Tips & Tricks
Sebastian Moran

How to Remove Zero Spam Plugin Data on Your WordPress Website

A commonly used spam protection plugin is Zero Spam which has over 30k active installations. To avoid conflicts when switching from the Zero Spam plugin, it’s recommended to remove any remaining data before installing, activating, and setting up the new spam protection solution. The Zero Spam plugin uses a couple of custom database tables for storage; wp_zerospam_blocked_ips Wp_zerospam_log Suppose the custom database tables from the Zero Spam plugin are not automatically deleted when you uninstall it. In that case, you can use the WP-Optimize plugin or phpMyAdmin to locate them. By using any of them, you can delete the left-over

Sebastian Moran March 8, 2023 No Comments
Remove Loginizer Unused Data
Tips & Tricks
Sebastian Moran

How to Remove Loginizer Plugin Data on Your WordPress Website

The Loginizer plugin is commonly used for brute force protection, failed login attempt logs, and IP control on your WordPress site. The custom database tables that the Loginizer plugin uses are; wp_loginizer_logs loginizer_csrf_promo_time loginizer_backuply_promo_time loginizer_promo_time loginizer_ins_time Loginizer_2fa_whitelist The plugin should remove all stored option values from the site’s database during uninstallation. To delete the database tables, get into your database administrator, such as phpMyAdmin, and look for; loginizer_ When you uninstall a plugin in WordPress, deleting the database tables it created is a good idea. This practice has several benefits: Reduce Database Clutter: Database tables no longer in use can

Sebastian Moran March 6, 2023 No Comments
2fa - WooCommerce Store
Tips & Tricks
Sebastian Moran

How to Enable Two Factor Authentication in WooCommerce

Two-factor authentication (2FA) is an important security feature that adds an extra layer of protection to your WooCommerce store. With 2FA enabled, a user must provide two forms of identification to log in: their password and a unique verification code generated by an authentication app, sent via SMS, or provided by a hardware token. Securing the login for WooCommerce has become easy with the availability of multiple free plugins on the WordPress.org repository. Wordfence If you are using either the Wordfence plugin or the Wordfence Login Security plugin you can now take advantage of the WooCommerce two-factor authentication feature. To

Sebastian Moran March 1, 2023 No Comments
Scan & Remove Files That Should Not Be On Your WordPress Install
Tips & Tricks
Sebastian Moran

How to Scan for Files That Should Not Be In Your WordPress Install

Backup files such as MySQL dumps, and wp-config.php backup files should not be stored in your WordPress install’s public_html (root folder). It’s important to note that the backup wp-config.php file can provide an easy way for a site attacker to find the database credentials. These credentials can then be used to directly connect to your site to insert content in the site’s database or to create an admin user to install and deploy malicious content to your site from plugin installs. One of the easiest security plugins to scan for those types of files is Wordfence. To ensure that files

Sebastian Moran February 15, 2023 No Comments
Fix Mixed Content Error - WordPress
Tips & Tricks
Sebastian Moran

How to Correctly Fix Mix Content Issues on WordPress

Dealing with mixed content issues on WordPress sites can be a pain. The ideal way to solve mixed content issues is to solve those at the database level, so it does not need another plugin dependency to fix mixed content on the site’s front end. If you want a plugin-only solution, then the Better Search Replace plugin will help run a search and replace any HTTP references in the site’s database and change those to HTTPS. Depending on the number of references that need to be changed, the Better Search Replace plugin might take a while to complete the changes.

Sebastian Moran February 9, 2023 No Comments
Change Debug Log Location - WordPress
Tips & Tricks
Sebastian Moran

How to Change the debug.log Storage Location

It is beneficial if you temporarily enable debugging on your WordPress site to run down any issues happening with the site from active themes, WordPress core version, or active plugins. The default location to store the debug.log file is /wp-content/debug.log, but if you want to change the path where the debug.log file should be stored, add the following snippet into the wp-config.php file replacing the /tmp/ with your folder preference. define( ‘WP_DEBUG_LOG’, ‘/tmp/wp-errors.log’ ); If you are uncomfortable editing the wp-config file, you can use the plugin “Change Debug Log Location” If you are using the Really Simple SSL plugin

Sebastian Moran February 1, 2023 No Comments
Remove Unused All in One SEO Plugin Data
Tips & Tricks
Sebastian Moran

How to Remove the All in One SEO Plugin Data on Your WordPress Website

The All in One SEO is a commonly used SEO plugin with 3+ million active installs. If you want to migrate to a different SEO plugin, you should migrate the existing SEO and delete the previous plugin’s stored data. If you are migrating to the Rank Math SEO plugin, it supports the All in One SEO plugin data migration. The All in One SEO plugin uses the following database tables for data storage; wp_aioseo_cache wp_aioseo_notifications wp_aioseo_posts All in One SEO plugin allows you to remove ALL AIOSEO data upon plugin deletion. Make sure the “Uninstall AIOSEO” is enabled before deleting

Sebastian Moran January 25, 2023 No Comments
Remove Unused WPForms Plugin Data
Tips & Tricks
Sebastian Moran

How to Remove WPForms Plugin Data on Your WordPress Site

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 When you deactivate and delete the WPForms plugin, all the data it uses will be deleted without needing to manually

Sebastian Moran January 18, 2023 No Comments

Administrators Love MainWP

I have been using MainWP for many years now and have managed over 300 websites with it. It saved me countless hours and headaches. Well worth investing in it, and setting it up is quite... Read More...

Wouter van Nierop

Co-Owner at Agencia Kit Digital

Our clients at Ultimate WP Help count on us to keep their sites updated, running smoothly and most of all, secure. Having complete control with the MainWP Dashboard means we can do this with ease. We own... Read More...

Jill Sessa

Chief Site Savior at Ultimate WP Help

I discovered MainWP sometime back in December 2014! I couldn't believe that such a tool existed and was for free. I quickly signed up and have never regretted it and went on to purchase... Read More...

Theresa Mhlanga

Director at Angel & Walt Hosting

Read more MainWP Testimonials

MainWP Affiliate Disclosure: Some of the links contained in the post or pages are “affiliate links.” This means if you click on the link and purchase or subscribe to a recommended item, We will receive an affiliate commission. We only recommend products or services we believe have value to MainWP users and readers. This is disclosed in accordance with the Federal Trade Commission’s 16 CFR, Part 255: “Guides Concerning the Use of Endorsements and Testimonials in Advertising.
© MainWP - WordPress Management without the SaaS! 2014 - 2024 - Terms of Service - Privacy Policy - Cookie Policy - Support Policy - Refund Policy - MainWP Domain Use - DPA
Facebook Twitter Trello Users

Looking for something?

Search MainWP support and documentation.

Privacy laws apply to businesses that collect personal information. Since no personal information is collected by the MainWP plugins, no privacy laws apply to the MainWP plugins. This includes GDPR, UK DPA 2018, PIPEDA, Australia Privacy Act 1988, LGPD, PIPL, and other privacy laws.
Donata Stroink-Skillrud
Donata Stroink-Skillrud
President of Agency Attorneys

Your Download Is Just One Click Away

…or just download the plugin.

By entering your email, you agree to our Terms of Service and Privacy Policy.