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
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
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
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 =
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
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
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
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
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
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
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