I really don't know why /tmp/backups was chosen as default backups location.
Looks like author of this module was expecting a user to override this path with his own.
Anyway it doesn't matter because we don't use mysql::backup.