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: [INDENT] Error Code: 1932. Table ‘mydb.mytable’ doesn’t exist in engine
[/INDENT] 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 ([url]https://launchpad.net/percona-data-recovery-tool-for-innodb[/url]) 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.