Results suggest database corrupted; how to deal with it?

Results suggest database corrupted; how to deal with it?

am 13.07.2006 19:57:58 von Richard

Hi All,

I'm running MySQL 5.0.15-nt running over WinXP-Pro/SP2. The following
group of commands and responses suggests to me that my installation of
MySQL is corrupted. Is there anyway I can get rid of the offending
database "depot_test" short of un/reinstalling MySQL?

Thanks in Advance,
Richard

mysql> use depot_test;
Database changed
mysql> alter table products rename xxx;
ERROR 1146 (42S02): Table 'depot_test.products' doesn't exist
mysql> show tables
-> ;
+----------------------+
| Tables_in_depot_test |
+----------------------+
| products |
+----------------------+
1 row in set (0.00 sec)

mysql> drop table products;
ERROR 1051 (42S02): Unknown table 'products'
mysql>

Re: Results suggest database corrupted; how to deal with it?

am 14.07.2006 01:09:05 von Richard

I forgot to mention that I first tried to drop the database:

mysql> drop database depot_test;
ERROR 1051 (42S02): Unknown table 'products'
mysql>

That's what got me started on trying to remove the products table from
the database.

Re: Results suggest database corrupted; how to deal with it?

am 14.07.2006 01:50:55 von Richard

OK, I found the databases in the data folder of my MySQL installation
and deleted them with Windows Explorer command. My system seems
healthy now.