How to clean huge wp_options in SQL – Transients, wpseo_sitemap _cache_validator
A very useful tutorial if you have a website on WordPress whose SQL WP_OPTIONS table is very large. Clean Huge WP_OPTIONS IN SQL. WordPress is …
MySQL
Tutoriale MySQL
Learn how you can work with MySQL databases for the web, the most effective ways to increase performance and security.
Fix Error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress
“Your PHP installation appears to be missing the MySQL extension which is required by WordPress” It is an error encountered by many blog holders and …
Import .SQL File Error – MySQL server has gone away
This tutorial solves the error that appears when importing through the order line of files .SQL. Import .SQL File Error – MySQL server has gone away. …
Fix phpMyAdmin Import SQL – Unknown collation: ‘utf8mb4_unicode_520_ci’
An import problem via Phpmyadmin or SSH (with import or archived base lines), which occurs in particular …
[Fix phpMyAdmin] The configuration file now needs a secret passphrase (blowfish_secret)
Whether PHPMYADMIN is installed on a Ubuntu, Centos or Fedora Distribution server, the message “The configuration file now needs a secret passphrase (blowfish_secret)” with red …
WordPress wp_options table corrupted / Error establishing a database connection.
Until now, in 2015, I have not heard that there was any virus or SQL exploit that would put “to the ground” hundreds of sites and …
Change Upload Size Limit SQL file in phpMyAdmin
Tutorial that teaches you step by step how to change the size limit accepted for the import of SQL files into phpmyadmin. Help when you have …
How to recover the password for the user root of a SQL server
Tutorial step by step in which you learn how to recover the password for the user root of a SQL server. The most important user of a mysql server …
How to change mysql root password to Linux (SSH)
If you are in the situation where you want to change mysql's root password to linux, from this tutorial you learn step by step how you can …
Show database queries total, memory usage & execution time (WordPress)
WordPress is a platform that no longer needs comments. As much as the flexible wordpress is so much it can request a lot of resources …
