UPDATE:
I got it to work, but now i can't SELECT any data from the most important database I needed . I get table doesn't exist.
I copied the databases and now they exist. MySQL users are back and can log in successfully.
All the other databases are fine, but with mine I see all the tables with "show tables" but I can't describe or select anything from them. I get table does not exist.
Why didn't mine get copied with the other ones.
The *.frm files are there and they have the right file sizes, but there isn't any MYD and MYI for each of the tables like I noticed on the other database that DO work.
But why did this work with my last install? There were no MYD and MYI files for this database on the last working install.
any help?
-Dan
UPDATE:
here's what I get when I try to repair a table.
Code: ( text )
mysql> REPAIR TABLE news;
+----------+--------+----------+--------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------+--------+----------+--------------------------------+
| dmc.news | repair | Error | Table 'dmc.news' doesn't exist |
| dmc.news | repair | error | Corrupt |
+----------+--------+----------+--------------------------------+
2 rows in set (0.00 sec)
