# Resetting users table

**URL:** <https://www.ruby-forum.com/t/resetting-users-table/60315>\
**Category:** Engines\
**Created:** [May 12, 2006, 1:00am UTC](https://www.ruby-forum.com/t/resetting-users-table/60315 "2006-05-12T01:00:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![steve\_ross](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3d9bf3/32.png) [@steve\_ross](https://www.ruby-forum.com/u/steve_ross)\
**Post date:** [May 12, 2006, 1:00am UTC](https://www.ruby-forum.com/t/resetting-users-table/60315/1 "2006-05-12T01:00:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![steve\_ross](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3d9bf3/32.png) [@steve\_ross](https://www.ruby-forum.com/u/steve_ross)\
**Post date:** [May 15, 2006, 12:10am UTC](https://www.ruby-forum.com/t/resetting-users-table/60315/2 "2006-05-15T00:10:37Z")

</div>

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