in response to a query from André Simões (also known as ITXpander), I slapped together a MySQL script that outputs
mysqldump commands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge. How it works
The script works by querying the