How to save data after editing MySQL config

Question

MySQL

Corrected MySQL configs on VDS. All databases immediately collapsed, MySQL cursed at incorrect data in frm files. I read that this is normal, it was necessary to immediately configure it as needed, now only dump-import.
I would like to ask those who know how it is possible to restore the bases without unnecessary gestures? It’s kind of reluctant to manually dump 30+ databases and then import it back. Any tips?

Answer 1

hubpages.com/hub/Incorrect-Information-in-FRM-File-of-InnoDB-Table

Answer 2

Well, you can not manually, but with a script. Because practice shows that REPAIR TABLE does not always work.

Answer 3

try mysqlcheck database_name
.
About manual work ... You need to write a script, no more ...

Answer 4

Corrected MySQL configs on VDS. All databases immediately collapsed
A good administrator, before changing something, first makes a backup.
A good rule - very often helped (!!!) ...