I have spent three days investigating how to recover my database. I have the ibdata1, the FRM, and the ib_logfile0 and ib_logfile1 files (It seems I don't have the ibd files since my configuration is as default: innodb_file_per_table = OFF)
The problem is that most of the recommendations on internet speak about the case when you have the ibd files, but, for my case (with the files I have), the possible solutions are downloading SW that is not available.
Please, I really need help to match the data so I can access the info. I'll appreciate your help.
When I start the mysqld, there is no error messages at mysqld.log.
When it appears is when I try to access one of the InnoDB tables:
191008 15:17:13 [ERROR] Cannot find or open table DecopBD/acciones from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html how you can resolve the problem.
Note that the DB has MyISAM and InnoDB tables. The problem is just in the InnoDB.