The blog title says it all: Do we need a MySQL Cookbook? I tend
to think so.
This seems to be something that is missing with current MySQL
documentation. There is lots of information available but finding
the appropriate bit can be quite tedious and it often requires
looking in multiple places.
A lot of other software has such books, but for some reason MySQL
seems to be missing one.
A recent example comes from a “documentation feature request” I
posted today: http://bugs.mysql.com/bug.php?id=68171. MySQL 5.6
provides a way to “move InnoDB tables” from one server to
another. There are many reasons why you may want to do it, but
the documentation is currently rather sparse. A simple “example
recipe” for this would be good, as would an equivalent recipe for
other engines where you can do this such as MyISAM. This is just
an isolated …[Read more]