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
Background Installing phpMyAdmin on a Laravel Forge server can be an enormous challenge. One would image you can just specify phpmyadmin/phpmyadmin as the repo and
Copyright 2022 © All rights Reserved