tags:

views:

34

answers:

1

hello i had to recover my mysql databases by moving old mysql data file into a new installation of mysql(e.g. mysql 5.1/data/[database]).

all the databases are accounted for, but some of the tables are not showing up in phpmyadmin. it would say 11 tables in the dropdown but only show 7. anyone have any idea? thank you

when i run

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck.exe -u root -p -r [database]

i get

database.activities
Error    : Table 'database.activities' doesn't exist
status   : Operation failed
database.categories                                   OK
database.category_image
Error    : Table 'database.category_image' doesn't exist
status   : Operation failed
database.pages                                        OK
database.pictures                                     OK
database.products                                     OK
A: 

Hmm, this is strange. When you run "show tables", does the output show all the tables or only the subset you mentioned?

malonso
and if you run create table, does it say table exists?
Don
i checked my databases again. some myi and myd files are missing
Funky Dude