I currently have a corrupt database on my live site, because a single Table that has gone missing.
Table 'test1.catalog_product_index_price' doesn't exist
I logged onto my server and downloaded a compressed backup file "/backup/2018-02-03/system/dirs/_var_lib_mysql_.tar.gz"
Once i extracted it locally I noticed ibdata1 file, and this would be my first time trying to work with this type of file.
I only need to recover a single table from the "test1" database. How can I go about exporting this table using the ibdata1 file?