What defines small medium large and huge on a Virtualmin MySQL installation?
Background When installing Virtualmin, the system will prompt for small, medium, large and huge. The question is how are these parameters defined? By examining the
mysql
MySQL Invalid default value for XXX datetime based field
Working servers suddenly start giving the error below when restoring a MySQL database that contains datetime fields with 0000-00-00 defaults: user@server:/tmp# mysql -uuser -ppassword database_name
Whilst restoring a MariaDB Backup from one Virtualmin server to another, MySQL create and grant errors
Background On a legacy server with an older version of MariaDB, restoring to a newer Virtualmin server that run MySQL 8 might be problematic. The
WHMCS Installation Requirement of MySQL Strict Mode
WHMCS has a requirement of MySQL Strict Mode. The official documentation provides instructions on how to do this with WHM/cPanel. This article documents the process
How to run a MySQL command from the command line
How to run a MySQL query using the command line: Use -e to execute the command. Here is what that will look like: mysql -u
Can’t login as root to PHPMyAdmin on new server install
Background After installing a new server, or doing a server migration, you find you can’t suddenly can’t log into PHPMyAdmin as root anymore. The errors
MySQL Errcode: 122 restoring database on Virtualmin server after fresh install
Background You might experience the following MySQL error whilst trying to restore a Virtualmin database: #3 – Error writing file ‘./DB_NAME/TABLE_NAME.frm’ (Errcode: 122) Solution Check
How to truncate a MySQL table in spite of a foreign key
This can be done by disabling index checks. Yes you can: SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table1; TRUNCATE table2; SET FOREIGN_KEY_CHECKS = 1; With these
How to display the size of all MySQL tables using the command line
Background Issue the following command if you want to see in Megabytes the size of all MySQL tables from the command line: SELECT table_name AS
How to drop all MySQL tables from a MySQL database
Background Under certain circumstances you might want to trash all the databases you have on a server. This article explains how to do it. Please