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
Databases
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: [email protected]:/tmp# mysql -uuser -ppassword database_name
Tenancy for Laravel General error: 1615 Prepared statement needs to be re-prepared
There are two ways of fixing this problem: First confirm this value: show global variables like ‘%table_definition_cache%’; Then increase the value: set global table_definition_cache =
Beginning MongoDB
MongoDB is a weird little database but seems really popular and works nicely with low overhead Javascript applications. This article highlights a few key pointers
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
How to handle [ERROR] mysqldump: Couldn’t execute ‘show create table `wp_options`’: Table ‘./site_wordpress/wp_options’ is marked as crashed and should be repaired (145)
When performing certain MySQL backup operations you might end up with the following message: [ERROR] mysqldump: Couldn’t execute ‘show create table `wp_options`’: Table ‘./site_wordpress/wp_options’ is
After Ubuntu 18.04 to 20.04 upgrade, MySQL stops working with “Server upgrade in progress”
Background After upgrading from Ubuntu 18.04 to Ubuntu 20.04, MySQL isn’t working and systemctl status mysql.service show there are problems. You see this line lurking
How to test connectivity to a Microsoft SQL database using the Linux command line
Here are some useful commands when working with Microsoft SQL and Linux, specifically pertaining to the `sqlcmd` mssql-cli utility. Update 16 July 2021 It appears
phpMyAdmin stops working after upgrade to MySQL version 8
After an upgrade to MySQL version 8 the users can’t login to phpMyAdmin anymore. In troubleshooting the problem, you issue the following command: mysql> grant
How to run a MySQL command from the command line
Summary Use -e to execute the command. Here is what that will look like: mysql -u -p -e “create database database_name” Reference Run a single