Tag Info

New answers tagged

3

In general case once InnoDB tablespace is corrupt you need to re-create tablespaces from scratch. This is the safest way especially if you're not familiar with InnoDB files/format. In some cases InnoDB writes to the error log file information about corrupted page number and index it belongs to. For example, InnoDB: Page may be an index page where index id ...


0

ok, i best solution which suited me well. for being cautious in choosing the above solutions provided in my question above.. (cuz the solutions didn't guarantee 100% that my data would be intact), i made a backup for my drupal database folder just in case. chose solution (2), which is adding the force_recovery..but no luck in fixing the problem.. so i ...


1

I'd say this is a good security practice to restrict OS access to your DB files. First you should definitely restrict write privileges to DB files at the OS level, if not already configured that way. Don't allow anyone other than the OS user that runs the DB to write to the DB files. Practically any DB software I can think of restricts this by default. ...



Top 50 recent answers are included