After eventually managing to upgrade my debian virtual server from etch to lenny. (Read here for the full story: http://serverfault.com/questions/168808/debian-upgrade-from-etch-to-lenny-fails)
I now lost the data (including all tables) from my MySQL DB. The files are still present on the hard drive and phpMyAdmin (further referenced to as PMA) still shows me all the database names but without any tables. 'mysql' and ''information_schema' databases still have their tables. But accessing e.g. 'mysql.user' gives me the following error:
#1017 - Can't find file: './mysql/user.frm' (errno: 13)
Of course (as any 1337 PEBKAC does) I don't have a mySQL dump file. (using the F-word multiple times)
Does anyone know of a tool that could restore the lost data from the file structure?
Thanks in advance for any help granted to that layer-8 problem a.k.a. me