MySQL MariaDB

Disable MySQL Replication on Slave

To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql folder, remove entries like

phpmyadmin export XML

Export MySQL Database table as an XML Document

To export a MySQL database table as an XML document, you can use mysqldump command like phpMyAdmin table export feature

MySQL MariaDB

MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full

When restoring a MySQL database, I get the following error How to fix ERROR 1114 (HY000) table is full? First,

MySQL MariaDB

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

When deleting a table in a MySQL database, I get the following error message To fix the error, run Now

MySQL

MySQL show processlist

To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command To see

MySQL

MySQL Backup

MySQL backup all databases Split mysqldump backup file into tables Extract Backup of one database from mysqldump all databases MySQL

MySQL

MySQL backup all databases

To backup all databases on a MySQL server, run This will create sql backup file for each database in your

MySQL

bash: mysql_safe: command not found

On CentOS 7 server running MySQL 5.7, when trying to reset MySQL root password, I get an error This is

MySQL

CentOS 7 MySQL 5.7 root password reset

To reset MySQL 5.7 root password on CentOS 7 server, do the following Stop MySQL Server Set the MySQL MYSQLD_OPTS

ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded

ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded

When I try to connect to a MySQL 8 server, I get the following error This is because of MySQL

Magento catalog_product_relation MySQL Error

Magento catalog_product_relation MySQL Error

On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error SQL Strict

MySQL Cluster

MySQL Cluster

MariaDB Replication MariaDB galera cluster https://www.percona.com/software/mysql-database/percona-xtradb-cluster Disable MySQL Replication on Slave