Jump to content

Archived

This topic is now archived and is closed to further replies.

ben_

all my tables are marked as "in use" in phpmyadmin

Recommended Posts

all my tables are marked as \"in use\" in phpmyadmin??

 

and I get this error when I try and view a table:

 

Can\'t find file: \'./undergroundhouse_net/phpbb_posts.frm\' (errno: 13) 



Error 



SQL-query : 



SHOW KEYS FROM `phpbb_posts` 



MySQL said: 





Can\'t find file: \'./undergroundhouse_net/phpbb_posts.frm\' (errno: 13)

 

I\'m thinking it could be a rights issue? if so how can I correct this?

 

this occurred after restoring a backup

 

thanks in advance

 

 

Ben

Share this post


Link to post
Share on other sites

the files may be owned by root... if you\'re on linux run:

 

% su

(enter)

# cd /path/to/mysql/data

# chown -R mysql.mysql name_of_database

# cd name_of_database

# chmod 660 *

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.