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. -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
