Comments - Backup MariaDb

Hi,

I've been using OpenStack which use mariadb behind it. Somehow the CINDER database has been dropped which i came to know after few daty when volume details were not showing on GUI.

I've old ibdata1, ib_logfile0, and ib_logfile1 files of my existing mariadb. I tried to restore and recover it from these files. However, i got the following errors when i try to fetch detail from any tables.

MariaDB [cinder]> select * from volumes; ERROR 1932 (42S02): Table 'cinder.volumes' doesn't exist in engine

[root@kll7015 lib]# mysqlcheck --all-database -a | more Info: Using unique option prefix 'all-database' is error-prone and can break in the future. Please use the full name 'all-databases' instead. cinder.attachment_specs Error : Table 'cinder.attachment_specs' doesn't exist in engine status : Operation failed cinder.backup_metadata Error : Table 'cinder.backup_metadata' doesn't exist in engine status : Operation failed cinder.backups Error : Table 'cinder.backups' doesn't exist in engine status : Operation failed cinder.cgsnapshots Error : Table 'cinder.cgsnapshots' doesn't exist in engine status : Operation failed cinder.clusters Error : Table 'cinder.clusters' doesn't exist in engine status : Operation failed cinder.consistencygroups Error : Table 'cinder.consistencygroups' doesn't exist in engine status : Operation failed cinder.driver_initiator_data Error : Table 'cinder.driver_initiator_data' doesn't exist in engine status : Operation failed cinder.encryption Error : Table 'cinder.encryption' doesn't exist in engine status : Operation failed cinder.group_snapshots

mysqldump --database cinder > cinder.sql Info: Using unique option prefix 'database' is error-prone and can break in the future. Please use the full name 'databases' instead. mysqldump: Got error: 1932: "Table 'cinder.attachment_specs' doesn't exist in engine" when using LOCK TABLES

i don't know how to recover data from here. Can anyone please help us here.

Thanks, Pradeep