On Mon, 2 Apr 2001, Anonymous Individual wrote:
> 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!.
It sounds like you did not loose your data at all, only mysql. Database
mysql only contains user privileges. so it's
okay. you can grant new user to your database. Not a big problem.
>
> 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
>
---------------------------------------------------------------------
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
