472,127 Members | 2,043 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

Results suggest database corrupted; how to deal with it?

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
2 4646
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
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.

Similar topics

3 posts views Thread by Ken Davis via AccessMonster.com | last post: by
6 posts views Thread by Gary | last post: by
32 posts views Thread by Clunixchit | last post: by
4 posts views Thread by jaYPee | last post: by
9 posts views Thread by advance scout | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.