[rt-users] Proper way to backup RT Database

[John Buell]

Does the interpretation of %M vs %m vary from Linux to Linux (or between Linux and other *nixes)? 

When I first set up my backups I found that following the linked page to the letter I got timestamps with YearMinuteDate instead of YearMonthDate. I do a nightly SQL backup, followed by a backup of everything I've customized for Apache and Postfix, and use `date +%Y%m%d%H%M` to do a date and time stamp on my files.

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jim Brandt
Sent: Thursday, May 23, 2013 10:38 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Proper way to backup RT Database


On 5/23/13 11:05 AM, Cena, Stephen (ext. 300) wrote:
> I just lost my Service Desk database. I did a test creating a ticket, 
> saw what I wanted, then restored the database previously. It didn't 
> restore. So I dropped all tables, did a restore. RT broke. I checked 
> the tables restored & it only did 45 out of 68.
> So now I get to rebuild the RT configuration again (not that bad).
> The command I'm using to backup my RT databases is:
> mysqldump -u root -p<PASSWORD> --result-file=G:\BACKUPS\RT-<DATE>.sql
> Is this how the database should get backed up? Why did it only back up 
> some tables but not all? I've already got one RT system with a borked 
> database I haven't been able to get help with yet. With the scale of 
> the one I'm going to be launching I CANNOT afford for backups/restores 
> to not work.

There are docs on backups here that might help:

http://bestpractical.com/rt/docs/latest/backups.html

Those dump just the RT database.

Also, maybe show the command you used to restore from the backup? Any errors during the dump or restore?


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training