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?


1 Answer 1


I would put the whole backup file onto a testserver, is that possible for you? And then do: mysqldump -u root -p test1 catalog_product_index_price > dump_catalog_product_index_price.sql

  • Yes this worked, thanks. I created a test server locally with MAMP and copied all the files over to /Applications/MAMP/db/mysql/. Finally restored my table and restarted MySQL
    – Hector
    Commented Feb 5, 2018 at 2:49
  • 1
    Sweet! Glad i could help. How about an upvote then? ;-) Commented Feb 5, 2018 at 22:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.