New answers tagged corruption
0
You cannot run OPTIMIZE TABLE against a View. I can see why the error message would be Corrupt
In mysql, a view is represented as a table in INFORMATION_SCHEMA.TABLES.
I have discussed views in this light before
However, a View in INFORMATION_SCHEMA.TABLES has NULL as a Storage Engine.
Mar 21, 2012 : How do I get the execution plan for a view?
Nov 23, ...
1
Can you define "corruption" and explain exactly what happened to the files?
If the data is really valuable (in which case you'll hopefully be investing a lot more in your backup and recovery to make sure that you can't lose your database and all your backups simultaneously), there are tools that may be able to salvage some of your data. Oracle Consulting ...
Top 50 recent answers are included
