Jump to content


Photo

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


  • Please log in to reply
2 replies to this topic

#1 ben_

ben_
  • New Members
  • Pip
  • Newbie
  • 2 posts
  • Locationmanchester, uk

Posted 17 October 2003 - 02:38 PM

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
www.undergroundhouse.net

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 17 October 2003 - 05:17 PM

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 *


Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 ben_

ben_
  • New Members
  • Pip
  • Newbie
  • 2 posts
  • Locationmanchester, uk

Posted 18 October 2003 - 02:16 PM

thanks!
www.undergroundhouse.net




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users