[rt-users] Proper way to backup RT Database

2013-05-23 Thread Cena, Stephen (ext. 300)
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

Re: [rt-users] Proper way to backup RT Database

2013-05-23 Thread Jim Brandt
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

Re: [rt-users] Proper way to backup RT Database

2013-05-23 Thread Cena, Stephen (ext. 300)
-users@lists.bestpractical.com Subject: Re: [rt-users] Proper way to backup RT Database Message-ID: 519e37eb.7030...@bestpractical.com Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 5/23/13 11:05 AM, Cena, Stephen (ext. 300) wrote: I just lost my Service Desk database. I did a test

Re: [rt-users] Proper way to backup RT Database

2013-05-23 Thread John Buell
, 2013 10:38 AM To: rt-users@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

Re: [rt-users] Proper way to backup RT Database

2013-05-23 Thread Thomas Sibley
On 05/23/2013 11:16 AM, John Buell wrote: 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

Re: [rt-users] Proper way to backup RT Database (Jim Brandt)

2013-05-23 Thread Cena, Stephen (ext. 300)
Fixed the issue. PEBKAC. It helps if you actually back up the RT database not something else. Looks like I'm set. Stephen Cena QVII MIS/IT Dept 850 Hudson Ave. Rochester, NY. 14620 585-544-0450 x300 s...@qvii.com Thank you for helping us help you help us all. --For email related issues, please