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.
I upgraded the software fogbugz from v5 to v6.
So first I had the v6 database created, I then copied the v5 to the data dir of fogbugz. Some files got overwritten.
Maybe one of the files holds a record of what files (.frms) belong to the database fogbugz?
The file belongs to root. I think your mysqld is running as user mysql. So mysqld cant read the file.
After untaring (as root?!) you should do a chown (or chmod, first preferred) on the files.