How to get the size of a MySQL database?

From the control panel interface If you have access to a control panel like cPanel, DirectAdmin etc, the easiest way is to check the MySQL section. For example, in cPanel, simply navigate to MySQL® Databases section and you will see…

Continue Reading How to get the size of a MySQL database?

Error while sending QUERY packet

This error means that the MySQL/MariaDB server is not able to process the request. You will see in the error_log files entries like: [21-Feb-2020 21:34:00 UTC] PHP Warning: Error while sending QUERY packet. PID=4697 in /home/flighting/public_html/wp-includes/wp-db.php on line 2030 [21-Feb-2020…

Continue Reading Error while sending QUERY packet

Export a MySQL/MariaDB database

Exporting a database can be done very easily from phpMyAdmin/ from your web hosting control panel (cPanel, DirectAdmin, VestaCP etc). But you can also export databases from the command line with the mysqldump utility. With mysqldump you can export a…

Continue Reading Export a MySQL/MariaDB database

Database only backups in WHM

 Some clients asked us if you can set up only database backups in WHM. For some, this will sound strange, but there are users who want such a feature.  You can access WHM backup settings via WHM->Backup->Backup Configuration. Unfortunately, there is…

Continue Reading Database only backups in WHM

How to find when MySQL/MariaDB server was started

We will show you here how you can get the MySQL/MariaDB server started date on a CentOS server. This can be useful for server statistics etc. 1. Use the select now() - interval variable_value second from information_schema.global_status where variable_name='Uptime'; command…

Continue Reading How to find when MySQL/MariaDB server was started