How to clean huge wp_options in SQL - Transients, wpseo_sitemap_cache_validator

WordPress Blocks Hero 1

WordPress is a fairly light CMS for web servers. Minimum hardware resource requirements and a web server with HTTPS support that we have installed: PHP, MySQL, NGINX or Apache. Problems in WordPress may occur when we use various modules (plugins) that have security breaches or are not optimized affect the base… Read More

Fix Error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress

mysql Hero 1

“Your PHP installation appears to be missing the MySQL extension which is required by WordPress”Is an error encountered by many blog and website owners with WordPress.It's not a cause for concern. The lack of a MySQL extension in PHP is typical of operating systems installed from scratch, VPS or dedicated servers, where PHP extensions do not Read More

Import .SQL File Error - MySQL server has gone away

mysql Hero 1

When we import large .SQL files into a database, the classic method via phpMyAdmin it is not a very good solution. Most of the time we run into a "reqest timeout". The easiest way is to connect SSH / console to the server that holds the database, to upload to… Read More

Fix phpMyAdmin Import SQL - Unknown collation: 'utf8mb4_unicode_520_ci'

WordPress Hero 3

The import problem via phpMyAdmin or from SSH (with command line for import) databases or archives, which occurs especially when moving a database from one server to another, which does not use the same encoding settings or are different versions with settings specific in MySQL. ⁇ Read More

[Fix phpMyAdmin] The configuration file now needs a secret passphrase (blowfish_secret)

PHP Hero 1

Regardless of whether phpMy is installedAdmin on an Ubuntu server, CentOS or etc. Fedora distribution, the message “The configuration file now needs a secret passphrase (blowfish_secret) ”in red at the bottom of the index, nods. Especially when configured correctly in "/ etc / phpMyAdmin/ ". Of course, the path may vary from one configuration to another, but on CentOS… Read More

WordPress wp_options table corrupted / Error establishing a database connection.

WordPress Hero 3

I haven't heard of a virus or SQL exploit in 2015 that could bring hundreds of sites and blogs to the ground. WordPress, as it was in the past years, but for about a month strange things have been happening. I came across several sites that seemed to have lost their connection to the base… Read More

Import large databases (.SQL) by changing upload size limit (2048 KiB) from phpMyAdmin.

mysql Hero 1

When we work with databases, the most handy is phpMyAdmin, which provides us with support admindatabase management via the web interface. This phpMyAdmin we can make any changes we want to a database that we have access to. We can add databases, create, delete and edit tables in databases… Read More

MySQL Server - How to change / set the root user password via SSH.

SQL Hero 2

How can we set or change the MySQL password for the root user. After installing MySQL server on Linux, FreeBSD, OpenBSD, UNIX etc., the first thing we should do is set a password for the "root" user. This user "comes" with MySQL, it has nothing to do with the "root" user… Read More

Show database queries total, memory usage & execution time (WordPress)

WordPress Hero 2

WordPress is a platform that needs no comment. As it is WordPressflexible, it can require a lot of CPU / RAM resources if too many plugins or functions are used. For blogs and sites created on WordPress which has to withstand a lot of user traffic, it is very Read More