[rt-users] RT - Restoring the DB

[Ben Browning]

At 09:03 AM 9/27/2002, Odhiambo Washington wrote:
>I have lost the full functioanlity of rt2 after I migrated my /var partition
>to a larger disk.

UGH. I just went through this.

>I however have a backup of /var/db/mysql/rt2 from last Friday. What do I need
>to do to get rt to use this properly?

OK, heres the drill:
  1 Shut down httpd and sendmail (sendmail will bounce messages, so it is 
better to have them spool on a secondary MX somewhere)
  2 Shut down MySQL
  3 Copy your old files into the directory (in this instance, 
/var/db/mysql/rt2)
  4 Start MySQL
  5 Run mysqlcheck on the DB
  6 Cross fingers

>1. I cannot get the dropdown users list.
>2. When I search for a users id (withing rt) it gives null result - user 
>doesn't exist.
>    However, when I do an SQL query I see the users.
>3. I see tickets but not the bodies

Sounds like only a few tables got hosed. Before trying the above I would 
give mysqlcheck a chance. Worst case it blows your DB into little bits and 
you go to using Fridays backup anyway :)

~Ben
(who speaks for himself alone, here)


>I am not sure how to go about this...
>
>Thanks in advance.
>
>
>
>
>         cheers
>        - wash
>+----------------------------------+-----------------------------------------+
>Odhiambo Washington, wash at wananchi.com  . WANANCHI ONLINE LTD (Nairobi, KE)  |
>http://ns2.wananchi.com/~wash/          . 1ere Etage, Loita Hse, Loita St.,  |
>GSM: (+254) 722 743 223                 . # 10286, 00100 NAIROBI             |
>+---------------------------------+------------------------------------------+
>"Oh My God! They killed init! You Bastards!"
>                                                 --from a /. post
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

---
    Ben Browning <benb at theriver.com>
       The River Internet Access Co.
              Network Operations
1-877-88-RIVER  http://www.theriver.com