Is there a preferred way to back up a config database in MySQL?
I'm talking about a schema with ~160 tables where most of the tables have less than 100 rows of data. Only one or two tables change in any given month. Restores; when they need to happen, are usually just one table.
The current method is to back up the whole database every night.
If there an easy way to dump out the tables one by one into a directory tree that could then be added to source code control?