Backing up MySQL database on restricted user account

I know that backing up databases is a job for a sysdamin. I know that I shouldn’t do that because I’m a stupid developer. I know that. I just couldn’t resist… And then I came across a strange error that sysadmin never encounters (you know… mysqldump -u root…). I couldn’t dump this db due to events error. So here is a quick solution for that.

The error:

1	mysqldump: Couldn't execute 'show events': Access denied for user 'user'@'some-host' to database 'dbname' (1044)

Below lines are solving that. The magic option here is –skip-events

MyISAM:

1	mysqldump -u usernam -p --skip-events --databases dbname > dbname_dump.sql

InnoDB:

1	mysqldump -u usernam -p --skip-events --single-transaction --databases dbname > dbname_dump.sql