mysqldumpall
mysqldumpall is meant as a non-interactive mysql dumping tool. MySQL has a neat database type called InnoDB. This has one minor drawback, it stores all data stuff of the InnoDB kind in one file, even if it the server has multiple databases. Which makes restoring that much more interesting. The most common solution is: “dump the database locally and backup that file”.Another gripe I have with flat dumping is that dumping the mysql database yields “all” the data in that database, but I am only interested in the grants. And in most cases only the grants of specific users/databases. Preferable in a format I can use.
Also on some locations I use rsnapshot and I'd like my database dumps to be workable in rsnapshot.
So I cooked this script up.