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 Link to comment https://forums.phpfreaks.com/topic/1176-all-my-tables-are-marked-as-in-use-in-phpmyadmin/ 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 * Link to comment https://forums.phpfreaks.com/topic/1176-all-my-tables-are-marked-as-in-use-in-phpmyadmin/#findComment-3952 Share on other sites More sharing options...
ben_ Posted October 18, 2003 Author Share Posted October 18, 2003 thanks! Link to comment https://forums.phpfreaks.com/topic/1176-all-my-tables-are-marked-as-in-use-in-phpmyadmin/#findComment-3962 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.