ben_ Posted October 17, 2003 Share Posted October 17, 2003 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 Quote Link to comment Share on other sites More sharing options...
effigy Posted October 17, 2003 Share Posted October 17, 2003 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 * Quote Link to comment Share on other sites More sharing options...
ben_ Posted October 18, 2003 Author Share Posted October 18, 2003 thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.