InnoDB Recovery Tutorial June 17, 2009

A three-part InnoDB recovery tutorial using innodb-tools 0.3

Part 1 of 3:

Part 2 of 3:

Part 3 of 3:

2 Comments
Alfredo Herrejon August 21st, 2009

Hello Ryan, First of all thank you very much it was so helpful for me I truncated a production table so I am in serious problems, i followed all your steps, before .configure all was ok, also ./configure showed me the thanks message but the problem was when i made the make command after the ./configure i got some warnings like

constraints_parser.c:88: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘ulint’
constraints_parser.c: In function ‘check_fields_sizes’:
constraints_parser.c:130: warning: format ‘%u’ expects type ‘unsigned int’, but argument 2 has type ‘ulint’
constraints_parser.c:144: warning: format ‘%u’ expects type ‘unsigned int’, but argument 2 has type ‘ulint’
constraints_parser.c:144: warning: format ‘%u’ expects type ‘unsigned int’, but argument 4 has type ‘ulint’
constraints_parser.c: In function ‘ibrec_init_offsets_new’:
constraints_parser.c:231: warning: format ‘%i’ expects type ‘int’, but argument 2 has type ‘ulint’
constraints_parser.c: In function ‘ibrec_init_offsets_old’:
constraints_parser.c:265: warning: format ‘%i’ expects type ‘int’, but argument 2 has type ‘ulint’
constraints_parser.c:288: warning: format ‘%i’ expects type ‘int’, but argument 2 has type ‘ulint’
constraints_parser.c: In function ‘check_for_a_record’:
constraints_parser.c:320: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 3 has type ‘int’
constraints_parser.c:324: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 3 has type ‘int’
gcc -DHAVE_OFFSET64_T -D_FILE_OFFSET_BITS=64 -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -g -I include -I mysql-source/include -I mysql-source/innobase/include -o page_parser page_parser.c lib/tables_dict.o lib/libut.a
page_parser.c: In function ‘process_ibpage’:
page_parser.c:42: warning: format ‘%u’ expects type ‘unsigned int’, but argument 3 has type ‘time_t’
page_parser.c:46: warning: format ‘%u’ expects type ‘unsigned int’, but argument 3 has type ‘time_t’
page_parser.c: In function ‘process_ibfile’:
page_parser.c:72: warning: format ‘%u’ expects type ‘unsigned int’, but argument 3 has type ‘time_t’

at first I ignored that but when i made the page_parser with my ibdata1 file and got all the pages whe i used the constrains_parsers i am getting empty rows totally empty, do you know if the warning are causing the error, or what could i made wrong? Thanks in advance Alfredo Herrejon

UZCANGA February 18th, 2010

Hi.

I try for excute the create_defs.pl command but no get anything in my table_defs-h file. This file contains only de standar info just llike the create_defs.pl file.

Any sugestion?

Thanks

Leave a Reply