table problems after reinstall of mysql

[dvil]

I copied a mysql XXdb with several usable yytables from the mysql server 5.0/data/xxdb folder to an outside folder in W2k and re installed mysql. I then moved the xxdb folder back into the reinstalled mysql server5.0/data/xxdb.
the mysql>describe yytable: returns error 1146 (42S02): table "xxdb.yytable doesn't exist.
I am not sure if I reinstalled the same vs of mysql.
the other vs could have been 4.1 and the present one is 5.0

mysql 5.0 works ok cuz i created other db with tables that work fine.

How can I recover the outside folder tables?
any help would be appreciated by this new newbie.

 

[TonyGroves]

As far as I know the table file formats do not change between versions, but in any event the most reliable way to dump and reimport tables is to use "mysqldump" to produce a dump file and then use "mysql" to import the file into the new database.

 

[KarveR]

If they are innodb tables, you'd need to have copied the ibdata1 file (and possible a couple of others) from the mysql directory.


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[dvil]

copy the ibdat1 file with the data file before uninstalling?
so it is too late since it was not copied. so will try to use msysqldump.
thanks