WPXSS CLANCI - wp_actionscheduler_actions & wp_actionscheduler_logs tables

wp_actionscheduler_actions & wp_actionscheduler_logs tables

WooCommerce plugin uses the wp_actionsscheduler_actions table in the database to log scheduled actions such as cron’s running, product synchronization, upgrade, etc. These actions should be deleted once they are executed but this doesn’t always happen, in most cases, this table uses an InnoDB database engine with a row-level locking feature meaning that multiple queries can … Read more

wpcli export specific tables wordpress - Dumping specific tables using mysqldump or WP-CLI

Dumping specific tables using mysqldump or WP-CLI

For high-traffic websites, I advise developing a stagging website if you make significant updates or even switch the WordPress theme entirely. But one significant problem I encountered while moving from the staging site to the live one is that all database tables are updated, which could result in financial loss if the website receives multiple … Read more

mysql remove data from wordpress plugin - How to safely remove database tables after plugin deactivation

How to safely remove database tables after plugin deactivation

After a plugin is deinstalled from a WordPress website it will either remove all its data from the database or leave it in case the plugin is installed again. Upon deactivation, if the plugin’s data isn’t removed from the database you should manually remove it in order to optimize the database and get rid of … Read more

max connections - ⚠️ User already has more than 'max_user_connections' active connections [✅ SOLVED]

⚠️ User already has more than ‘max_user_connections’ active connections [✅ SOLVED]

Noticed a lot of Crawler errors on the Google Adsense console: So I enabled the WP_DEBUG and run a stress test with vegeta on the website: the website became unavailable and the following error was shown: User already has more than ‘max_user_connections’ active connections This explains the errors in Google SC because the crawler most … Read more

wp sqli - What is 💉 SQL injection and How to prevent WordPress SQLi attacks

What is 💉 SQL injection and How to prevent WordPress SQLi attacks

SQL (Structured Query Language) is a language that allows code to interact with databases. Injecting SQL commands into a vulnerable user input section on your WordPress website such as a contact form or search box is considered an SQL Injection attack. Depending on the actual SQL command, this could purge the database, send the data … Read more

WordPress database error Table .dbwp options is marked as crashed and should be repaired - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]

WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired [✔️ SOLVED]

Here are 4 different methods to fix the scary-looking error: “WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired”. NOTE: It is critically important that you backup your database before performing any of the following suggestions. You’re fully responsible for undertaking this yourself, I can’t be held responsible if you break … Read more

Delete Expired WordPress Transients - Delete Expired WordPress Transients 🚮

Delete Expired WordPress Transients 🚮

WordPress uses transients to temporarily store data for its plugins and themes. By managing transients you can optimize your website for speed and make sure your website is always functioning properly. Here are a few methods how to safely delete expired WordPress transients: Delete Expired WordPress Transients using WPCLI To delete only expired transients use: … Read more

SAVEQUERIES 0Awp content constant - Save Database Queries for Analysis in WordPress

Save Database Queries for Analysis in WordPress

The SAVEQUERIES wp-config constant saves database queries to an array and We can use that array to display queries. The information saves each query, what function called it, and how long that query took to execute. To enable SAVEQUERIES add this to the wp-config.php file: Then in the footer of your theme put this: <?php … Read more

How to Reset WordPress Password from phpMyAdmin Database - How to Reset WordPress Password from phpMyAdmin Database

How to Reset WordPress Password from phpMyAdmin Database

Locked out of your wp-admin area? Forgot the password? No problem, the easiest way to regain access is to reset your admin password from your database via phpMyAdmin. Step 1. Open PHPMyAdmin The first step is to log into your cPanel and under Databases select phpMyAdmin. Step 2. Select your database name From the left … Read more