Reply to thread

Message

No - they are all InnoDB - well - it does something (if teh tables are locked for example) but you are right - compared to myisam it does - nothing ....

Most of the time it's that the frm and the ibd are both present but MySQL complains that there is no database (last time after a forcfully restart with progams) so MySQL would even start up so you either need to change teh startup paramter or remove the false file and start MySQL afterwards and move it back and chek if the repair task is telling you something about teh issue (at least this is showing up when you run it)

If there would be any automated repair I would be happy but couldn't find anything.

I attach the err file - so you see what I mean

<blockquote data-quote="pur_berger" data-source="post: 1122710" data-attributes="member: 50701">No - they are all InnoDB - well - it does something (if teh tables are locked for example) but you are right - compared to myisam it does - nothing .... Most of the time it's that the frm and the ibd are both present but MySQL complains that there is no database (last time after a forcfully restart with progams) so MySQL would even start up so you either need to change teh startup paramter or remove the false file and start MySQL afterwards and move it back and chek if the repair task is telling you something about teh issue (at least this is showing up when you run it)If there would be any automated repair I would be happy but couldn't find anything.I attach the err file - so you see what I mean <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="pur_berger, post: 1122710, member: 50701"] No - they are all InnoDB - well - it does something (if teh tables are locked for example) but you are right - compared to myisam it does - nothing .... Most of the time it's that the frm and the ibd are both present but MySQL complains that there is no database (last time after a forcfully restart with progams) so MySQL would even start up so you either need to change teh startup paramter or remove the false file and start MySQL afterwards and move it back and chek if the repair task is telling you something about teh issue (at least this is showing up when you run it) If there would be any automated repair I would be happy but couldn't find anything. I attach the err file - so you see what I mean :) [/QUOTE]