MySQL and MariaDB guides for configuration, recovery, performance and common database errors.
Just like caching the front-end static files play an important role in improving the site speed. Similarly, we need to cache the backend for enhancing server performance.
This blog explains how to change the wordpress site and home URL using both command line and phpMyAdmin methods.
This blog explains how to disable strict sql_mode on a Linux server via command line. 1.The temporary method by command line: In order to disable or enable the strict mode, […]
A detailed InnoDB recovery workflow covering diagnosis, offline preservation, forced startup, logical extraction, partial-table salvage and clean restoration.
Error 1053 usually means MySQL has stopped accepting work because a shutdown is already underway. The safest response is to identify whether it is completing, stuck or repeatedly crashing.
Install and Configure phpMyAdmin on Ubuntu: In most production servers the phpMyAdmin is an important utility, we can install and configure phpMyAdmin on your server.
MySQL throws the error “Got a packet bigger than ‘max_allowed_packet’ bytes” when the server receives a query larger than the configured packet size.
The mysql.plugin error usually points to an incomplete upgrade, the wrong data directory or missing system tables. The correct repair depends on whether the server runs MySQL or MariaDB.
