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
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
Background Under certain circumstances you might want to trash all the databases you have on a server. This article explains how to do it. Please
Background Having a broken MySQL / MariaDB database is no fun. Broken tables can also lead to half complete backups really compounding the situation. If
Whilst trying to install or use PHPMyAdmin, you might encounter the following errors: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect():
How to detach/release and re-attach a database in Virtualmin Sometimes a database gets orphaned in Virtualmin. It’s still there, but it’s not attached to a
This quick guide will show you how to set up an NGINX and UncomplicatedFirewall on an Ubuntu Server Update Packages to bring your system up
Port Number The port number for MySQL is TCP port 3306. See where it’s listening How can you see if it’s listening on more than
Backing Up To backup a MySQL database from the command line, use the mysqldump command and pip the output to a file. For example: mysqldump
Background You have some sticky queries but you can’t see what’s happening. On certain website actions pages are just slow and you fully suspect the