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? I also didn't have logging turned on, but I found the page on the wiki that described that and enabled it. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Falcone Sent: Tuesday, February 26, 2013 11:35 AM To: [email protected] Subject: Re: [rt-users] Ready to roll? On Tue, Feb 26, 2013 at 02:56:28PM +0000, John Buell wrote: > Am 26.02.2013 01:09, schrieb John Buell: > > Ok, I have users set up, groups set up (company departments), queues > > set up.... The RT box seems to be sending messages back and forth to > > our main Exchange box with no trouble at all.... The RT web > > interface itself is only viewable from within our network, but I > > don't personally see that as a problem.... I JUST got the RT book > > today and implemented the backups for MySQL (and copying a few .pm > > files) onto a removable USB drive with no issue, and now scheduled > > that to run via cron every night at midnight.... Are there any other > > last second gotchas I should beware of before I unleash all of my users > > onto RT? On the topic of backups, I assume you've seen the new backups documentation? http://bestpractical.com/rt/docs/latest/backups.html Other common things - make sure you have monitoring in place on the machine, otherwise when you start to run low on space or have a load spike you'll have no way to triage what happened. -kevin -- 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
