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: [email protected] [mailto:[email protected]] On Behalf Of Jim Brandt Sent: Thursday, May 23, 2013 10:38 AM To: [email protected] 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 -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
