DISQUS

DISQUS Hello!  The comments on this profile are unclaimed and thus are unverified.

Do they belong to you? Claim these comments.

muthu's picture

Unregistered

Feeds

aliases

  • muthu

muthu

1 year ago

in InnoDB Recovery toolset Version 0.3 Released on Homo-Adminus Blog
I am trying to use your innodb recovery tools to recover data from a MySQL database , here is my scenario ,

* The tables in the database where dropped and re created - new tables does not have any data

I want to get back my old data which was deleted , my ibdata file is around 500 MB in size and the tables have DECIMAL data types , i was able to get back data belonging to couple of tables but the time taken to scan the whole ibdata file is too huge ( since the tables were dropped i don't know the page numbers to scan hence the whole table space scan ) and also the create_defs.pl seem to treat decimal types as char and not numeric ( it is FT_CHAR and not FT_DECIMAL ) , even if i manually change to FT_DECIMAL still i am not able to get the data , my questions are how to speed up the time taken to scan the table space and how to recover decimal data types , please help
Returning? Login