I had MySql 4.0.9 installed on a linux machine but i messed up the server while upgrading a new kernel. Fortunately, I had a backup of the entire mysql installation directory. So I copied it over to a different machine and this machine has MySql 4.1.0 installed. I assume that since I have the "data" directory, all the database I have been using can be recovered. The problem is I cant seem to find any information about how to go about this. I would really appreciate if any1 can tell me where i can look for how to do this. Many thanks to you all!

It seems copying the data directory into new installation's data directory brings databases back. but when I try to use it(use backupDB1), it is says,


mysql> show databases;
+----------+
| Database |
+----------+
| backupDB1 |
| mysql |
| test |
+----------+

mysql> use backupDB1
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'table01'
Didn't find any fields in table 'table02'
Didn't find any fields in table 'table03'
Database changed
mysql>

Any help would be appreciated!

haha stupid me.. i turns out the problem was directory permission. once i changed it, it read the tables correctly.