- when upgrading a kolla-ansible powered OpenStack Environment from a single node mariadb to a Galera Cluster, the database gots somehow corrupted (I'm no database expert). All nodes were corrupted or not even running. (Yes, there wasn't a backup) This led finally to the challenge, to recover the database from the still existing ibd-Files
- modern MySQL/MariaDB distributions with InnoDB does allow import of Tables from ibd-Files. It's recommended to also import the associated cfg-File of each table which doesn't exist in my case
- without these cfg-Files an error will be raised
Internal error: Drop all secondary indexes before importing table <tablename> when .cfg file is missing
and this leads to my approach to seperate the primary index statements from the secondary indexes and add them after the Tablespace gets imported successfully
- without these cfg-Files an error will be raised
- Create SQL Dump of a working fresh opensstack mariadb and store it for later: