By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Results suggest database corrupted; how to deal with it?

P: n/a
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

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

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

Jul 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I forgot to mention that I first tried to drop the database:

mysqldrop 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.

Jul 13 '06 #2

P: n/a
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.

Jul 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.