Hi,
Its called your backup tape.
Quentin
-----Original Message-----
From: Anonymous Individual [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 3 April 2001 4:16 p.m.
To: [EMAIL PROTECTED]
Subject: How to recover from accidental 'drop database mysql'
Greetings:
I accidently dropped (my thunderous stupidity!!!) our mysql
database. There were a few usernames and other databases.
I expected hell to break loose (it may still happen!), but
strangely enough, I noticed that I was still able to login,
probably because mysql server caches usernames, passwords, etc ??
I quickly backed up the remaining databases using mysqldump.
I did a make install to update the database and everything still
seems ok.
Now, anyone know if there is any way to create or repair my existing
mysql database with the information that is currently cached in
the server ?
For example, if I do "show databases", I see all the databases that
should exist, but when I do a "select * from mysql.db", I only see
the "test" database!.
Any ideas will be gratefully appreciated and accepted !!!!!!!!!
------------------------------------------------------------
--== Sent via Deja.com ==--
http://www.deja.com/
---------------------------------------------------------------------
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
