… or what I should keep in mind in case of disaster
To retrieve and maintain in SQL format the definition of all
tables in a database, is a best practice that we all should
adopt. To have that under version control is also another best
practice to keep in mind.
While doing that may seem redundant, it can become a life saver
in several situations. From the need to review what has
historically changed in a table, to knowing who changed what and
why… to when you need to recover your data and have your beloved
MySQL instance not start…
But let’s be honest, only a few do the right thing, and even
fewer keep that information up to date. Given that’s the
case, what can we do when we have the need to discover/recover
the table structure?
From the beginning, MySQL has used some external files to
describe its internal structure.
For instance, if I have a schema named windmills and a table …[Read more]