[rt-users] Ready to roll?

[Thomas Sibley]

On 02/27/2013 09:14 AM, John Buell wrote:
> Hm, thanks for pointing that out Kevin. I had been using: Mysqldump
> --opt --add-drop-table --single-transaction -u rt_user -pPassword -h
> localhost rt4 > rt4-mysql-backup-`date %Y%m%d`
> 
> I see the sense in doing the backup on the page that you linked to,
> but when I do it that way, I'm getting 'error 1044: Access denied for
> user 'rt_user'@'localhost' to database 'rt4' when doing LOCK TABLES.
> 
> So is there something else I'm missing, or might someone have just
> been active in a session?

The database user RT creates (rt_user by default) isn't granted the
ability to issue LOCK TABLE commands.  Backups should be made by a full
privileged database user, such as "root" by default on MySQL.  If you
must use the database user which RT uses, you will need to grant it more
rights.