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 `mssql-cli` sqlcmd command line utility. Testing Connectivity using sqlcmd
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 query using the command line: Use -e to execute the command. Here is what that will look like: mysql -u
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
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
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
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
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
Copyright 2024 © All rights Reserved