My Windows development machine MySQL occasionally got corrupted.
The data inside is useless to me, so I just seek for fastest method to get MySQL up and running again.
Continue reading “[Windows] Reinitialize corrupted MySQL installation”
Tag: mysql
MySQL Percona Galera Cluster with phpMyAdmin export
Galera Cluster have some limitations, for example all tables MUST have primary key.
In recent version, pxc_strict_mode is introduced to avoid unsupported features that can risk your data and server stability
One common trap is that SQL file exported with phpMyAdmin create index AFTER creating the table and inserting data.
During import, there is a transit state that table have no primary key and data need to insert to table, thus trigger the pxc_strict_mode error.
#1105 - Percona-XtraDB-Cluster prohibits use of DML command on a table (database.table) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
Continue reading “MySQL Percona Galera Cluster with phpMyAdmin export”
MySQL Backup and Restore (mysqldump)
Just for my own quick reference
Official Document: https://mariadb.com/kb/en/mariadb/mysqldump/