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
Databases
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 `mssql-cli` sqlcmd command line utility. Testing Connectivity using sqlcmd
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
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 install Microsoft’s SQL PHP PDO and so on drivers for Linux NGINX – Tested
Background Microsoft has made massive strides in supporting PHP on Linux in the last few years. A common need in a PHP application might be
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