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 permissions (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.
We hope you find this helpful! If you need any further assistance, please contact us and we'll be more than glad to help you out.