Resetting users table

I have what seems to be a hosed users table. No, actually I know it’s
hosed. If anyone knows how a mysql .MYI could disappear just let me know
(but that’s another story).

What I need to do is create the users table again from scratch. Any
hints?

Thanks

This should probably work:

  1. either a) migrate the user/login engines down to version 0, or b)
    edit the engine_schema_info table directly
  2. re-migrate the engines to recreate the tables
  • j

On 11 May 2006 22:59:36 -0000, steve ross