If you want to create a special user for use with Ottomatik and are wondering what permissions are needed here they are.
mysql backup permissions:
GRANT SELECT, USAGE, LOCK TABLES, SHOW VIEW, RELOAD, EVENT, TRIGGER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'dump'@'%' IDENTIFIED BY 'YOUR_PW_HERE';
restore premissions (super required to disable / enable binary logging during restore):
GRANT SUPER, DROP, CREATE, UPDATE, ALTER, INDEX, CREATE ROUTINE, ALTER ROUTINE, INSERT ON *.* TO 'dump'@'%' IDENTIFIED BY 'YOUR_PW_HERE';
Note that the "dump"@"%" user / host is just an example, you can set that to whatever fits your needs.