Drew's right, if it's only the sessions table that's gone you're in luck, since that only tracks things related to who's currently logged in.
And (since I well remember my first attempt to do something with mysql administration that was not scripted by an RPM installer... :-) before you do that, it'd probably be worthwhile to run through the "Creating and Using a Database" tutorial at http://dev.mysql.com/doc/refman/5.1/en/database-use.html -- then you'll have a handle on what Drew means by "dropping the table and recreating it from the definitions". Apologies if you're already beyond this level. Good luck, Ole On Fri, 2007-07-13 at 11:59 -0400, Drew Barnes wrote: > Since it seems it is only the sessions table that is borked, you could > try dropping that table and recreating from the definitions in the RT > package you grab from BP's website. > > > John Schubert wrote: > > Are there any resources you've seen that were written > > well and described MySQL DB recovery? I've been > > digging through the MySQL documentation and > > Yahoo/Googled for "How-To" articles, but most seem to > > assume a certain level of knowledge I don't possess. > > > > I feel dumb. I can compile, run and maintain Apache, > > and admin Solaris, but I can't seem to get my hands > > around managing a simple DB. > > -- /Ole Craig Security Engineer Team lead, customer support [EMAIL PROTECTED] 303-381-3824 direct 303-381-3802 support 303-381-3880 fax www.stillsecure.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com