Thread: Server outrages
View Single Post
Old 2020-02-21, 19:44   #564
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

22×3×5×41 Posts
Default

Hey Guys, now Iam affected after windows 10 has decided to give me a bluescreen, I cant take further actions, stucking at:


mysqldump: Got error: 1146: Table 'sr5.app' doesn't exist when using LOCK TABLES


Looks like a lot of tables are bad, enable skip lock tables doesnt help.


Any hints?


Update log:
[ERROR] Cannot find or open table sr5/app 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.


I think the files are lost.

Last fiddled with by rebirther on 2020-02-21 at 19:49
rebirther is offline   Reply With Quote