Not the answer you need?
Register and ask your own question!

Percona Data Recovery Tool for InnoDB

Bender RodriguezBender Rodriguez EntrantInactive User Role Beginner
Hi,

I am a newbie to Mysql/Mac OS. Yesterday I turned my laptop (Yosemite 10.10.5) on and found that mysql workbench 6.3 was complaining when retrieving data from one of my tables:
Error Code: 1932. Table 'mydb.mytable' doesn't exist in engine
I cant think why this would suddenly start happening. The ibd file is 2.4GB but I guess that makes no difference.
The table is stored in INNODB format.
All I need to do is get the data, even if its in a text file or something, I dont care about relinking the data back into MySQL. At this stage all I care about is the data.
I got the code for the PERCONA innodb recovery tool (https://launchpad.net/percona-data-recovery-tool-for-innodb) but i couldnt get it to compile.

These are the errors I got:


3 warnings generated.
Undefined symbols for architecture x86_64:
"_check_for_a_record", referenced from:
_process_ibpage in constraints_parser-9aa692.o
"_error", referenced from:
_process_ibfile in constraints_parser-9aa692.o
_open_ibfile in constraints_parser-9aa692.o
_set_filter_id in constraints_parser-9aa692.o
_usage in constraints_parser-9aa692.o
_main in constraints_parser-9aa692.o
"_make_longlong", referenced from:
_print_field_value in print_data.o
"_make_ulonglong", referenced from:
_get_uint_value in print_data.o
_get_int_value in print_data.o
_print_field_value in print_data.o
"_print_decimal", referenced from:
_print_field_value in print_data.o
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make: *** [constraints_parser] Error 1


gcc --version says this:

Configured with: --prefix=/Library/Developer/CommandLineTools/usr --with-gxx-include-dir=/usr/include/c++/4.2.1
Apple LLVM version 7.0.0 (clang-700.0.72)
Target: x86_64-apple-darwin14.5.0
Thread model: posix


I'm at my wits end. Is there any way to get my data back? Any advice much appreciated.

Thanks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.