Tag Info

New answers tagged


I thought I'd add something interesting. Based on some testing I found that the engine is NULL for MyISAM tables if they are corrupted: mysql> repair table TEST.test_myisam; ^CCtrl-C -- sending "KILL QUERY 10" to server ... Ctrl-C -- query aborted. +---------------------+--------+----------+------------------------------+ | Table | Op | ...


You need to disable foreign key checks and unique checks #!/bin/bash DATABASES=$(mysql -u XXXXX -pXXXXX --skip-column-names -e 'select distinct(table_schema) from information_schema.tables where table_schema not in ("mysql","information_schema","performance_schema")') for D in $DATABASES do TABLES=$(mysql -u XXXXX -pXXXXX --skip-column-names -e 'select ...

Top 50 recent answers are included