Ole, Thank you so much. I haven't used my skills with computers in quite awhile and I never was really a MySQL guru, so no, your idea isn't below my level. I understood every word Drew said, but had no idea how to do it.
I will go through and practice with the tutorial before I mess with the real one. I'd read through the MAN and Docs for MySQL, but somehow missed that tutorial. I really do appreciate the help you've given. Regards, John --- Ole Craig <[EMAIL PROTECTED]> wrote: > 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 > > ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.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
