[rt-users] Ready to roll?

Thomas Sibley trs at bestpractical.com
Wed Feb 27 15:41:13 EST 2013

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

More information about the rt-users mailing list