I have a rather weird problem.
mysql> use fogbugz;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> SHOW INDEX FROM FragmentCache;
ERROR 1017 (HY000): Can’t find file: ‘./fogbugz/FragmentCache.frm’ (errno: 13)
-rw-r----- 1 root root 8694 2008-04-02 18:26 /var/lib/mysql/fogbugz/FragmentCache.frm
datadir = /var/lib/mysql
What I did was stop another mysqld, tar the whole fogbugz/, stopped the new mysqld and unpacked the tar.
Permissions on all files in fogbugz/ are 640 (except fogbugz/ which is 750).
Got any tips?
FYI; Reason I did not do a proper mysqldump is because I could not import it… client hangs.