Thanks for all the responses I've received. I managed to fix it just before the first response arrived :-)
I untar'd an old backup I had just to get mysql seeing the tables and fields again, then used mysqldump. After restarting mysql, I loaded the dumped database back into mysql and all worked fine. Cheers John > -----Original Message----- > From: John Parsons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 9:52 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: DESPERATE NEED FOR HELP!!!!! > > > I have just been a complete muppet and trashed the tables in > my database and > don't have a recent backup. > > The database is used for the phpBB system and still functions > when I visit > the site via a web browser since the database is still > cached. Is there any > way I can recover the database using the mysql cache? > > I would really appreciate some quick responses here. > > Cheers > > John 'the muppet' > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php