[rt-users] Can't find file: 'Users'

[Alex Vandiver]

On Thu, 2006-03-16 at 10:39 -0800, Rob Walker wrote:
> I cannot log into RT this morning.
> [snip]
> mysql> select * from Users;
> ERROR 1017 (HY000): Can't find file: 'Users' (errno: 2)
Looks like mysql is the one unhappy with you, not RT, yes.

> Odd, so I went and looked at /var/lib/mysql/* , and found that in the
> rt34db directory there is only .frm files, and no .MYD or .MYI files,
> as there are in the mysql directory.
RT uses InnoDB tables, which don't produce .MYD or .MYI files.  Is there
a Users.frm file?

> So, is my dataset hosed?  Do I need to figure out mysql restores?
> Do I need to beat someone over the head for not doing regular backups?
Probably.
 - Alex