RT - Restoring the DB

RT Users
1

Hello,

I have lost the full functioanlity of rt2 after I migrated my /var partition
to a larger disk.

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?

I have literally put those backup files in place but while users can login to
rt, the following does not happen:

  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

I am not sure how to go about this…

Thanks in advance.

    cheers
   - wash

Odhiambo Washington, wash@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

2

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 :slight_smile:

~Ben
(who speaks for himself alone, here)

I am not sure how to go about this…

Thanks in advance.

    cheers
   - wash

±---------------------------------±----------------------------------------+
Odhiambo Washington, wash@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@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@theriver.com>
   The River Internet Access Co.
          Network Operations

1-877-88-RIVER http://www.theriver.com

3

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.

:wink:

I am not alone. Gives me reason to smile even in the face of trouble like this.

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

[root@ns2]#mysqlcheck rt2
rt2.ACL OK
rt2.Attachments OK
rt2.GroupMembers OK
rt2.Groups OK
rt2.KeywordSelects OK
rt2.Keywords OK
rt2.Links OK
rt2.ObjectKeywords OK
rt2.Queues OK
rt2.ScripActions OK
rt2.ScripConditions OK
rt2.Scrips OK
rt2.Templates OK
rt2.Tickets OK
rt2.Transactions OK
rt2.Users OK
rt2.Watchers OK

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 :slight_smile:

The situation is still the same, even after this.

-Wash

Odhiambo Washington wash@wananchi.com “The box said ‘Requires
Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,’
Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD.”
GSM: +254 72 743223 +254 733 744121 This sig is McQ! :slight_smile:

“I’d love to go out with you, but I’ve been scheduled for a karma
transplant.”