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>