Mysql database recovery error "Can't find file" and won't work in phpmyadmin and phpbb

[RolfH]

Ubuntu 12.04 LTS.

My server crashed (lightning) and linux-installation would not start properly. I had a cloned drive. It has my Mysql-databases all accept a new one. They all work. I want the new one back as well. I have access to the old drive and have copied the /var/lib/mysql/ereb_altor (that's the database-name). When I go into phpmyadmin I can see the database and the tables but when I click a file it says it can't find a file.
1017 - Can't find file: './ereb_altor/phpbb_config.frm' (errno: 13)

 

PhpBB reports the same thing.

The directory has drw------- and owned by mysql.mysql
The files are all -rw-rw---- owned by mysql.mysql

if I change the directory to drwx------- the database has no tables in phpmyadmin.

All my other (working) databases are
directory drwx------ mysql.mysql
files -rw-rw---- mysql.mysql

Screenshots: pappy.homenet.org/bilder/mysql-error/

Files are all there and the right permissions (?)

Am I missing something?

Best regards

[Jacques1]

The directory needs execute permissions, otherwise it cannot be entered. Of course there may still be other problems, but this is where you start.

 

You should also forget about phpmyadmin for now and use the command line directly. If you still cannot access any tables, use mysqlcheck to check the database for errors.