MainWP Blog - Tips & Tricks

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 Continue reading the post...

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 Continue reading the post...

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 Continue reading the post...

ManageWP is a Software as a Service (SaaS) platform for managing multiple sites, whereas MainWP is an open-source, self-hosted solution that prioritizes privacy for you and your clients when handling multiple websites from a centralized dashboard. Learn: Why Privacy for Your Clients is Important! Before moving forward, let’s learn a bit about the MainWP system. MainWP is a set of two plugins, “MainWP Dashboard” & “MainWP Child”. The MainWP Dashboard plugin is installed on a WordPress website from where you Continue reading the post...

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 Continue reading the post...

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 Continue reading the post...

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 Continue reading the post...

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 Continue reading the post...

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...

If you want to migrate from the Yoast SEO plugin to alternative plugins, it is also worth making sure that any Yoast SEO plugin data is deleted from the site’s database. The custom database tables that the Yoast SEO plugin creates; wp_yoast_indexable wp_yoast_indexable_hierarchy wp_yoast_migrations wp_yoast_primary_term wp_yoast_prominent_words(note: only available in the Yoast SEO Premium plugin) wp_yoast_seo_links The option names that the Yoast SEO plugin uses; _transient_wpseo_unindexed_post_link_count _transient_timeout_wpseo_unindexed_post_link_count _transient_wpseo_unindexed_term_link_count _transient_timeout_wpseo_unindexed_term_link_count _transient_wpseo_total_unindexed_general_items _transient_timeout_wpseo_total_unindexed_general_items _transient_wpseo_total_unindexed_post_type_archives _transient_timeout_wpseo_total_unindexed_post_type_archives _transient_yoast_i18n_wordpress-seo_promo_hide wpseo_social wpseo_titles wpseo yoast_migrations_free Wpseo_taxonomy_meta If you Continue reading the post...