MySQL Forums
Forum List  »  InnoDB

innoDB errno 121
Posted by: david
Date: July 10, 2005 10:19AM

I Created a bit of a mess and can not figure out how to resolve it.

1) Not thinking I had any innodb tables, I added "skip-innodb" to /etc/my.cnf and restarted mysql.

2) Next day a backup script reported:

/usr/bin/mysqldump: Got error: 1017: Can't find file: 'users_tab.MYI' (errno: 2) when using LOCK TABLES

3) I looked around, could not figure out the problem, so I decided to drop the problem and restore the table using an earlier backup.

4) After looking at the sql to restore the table, realized it was innodb :oops: Unfortunately, I had already dropped the table.

5) Removed "skip-innodb" to /etc/my.cnf and restarted mysql.

6) When I try to recreate the table, it reports that it can not create users_tab.FRM, errno: 121.

7) I can create a users_tab table if I do not specify TYPE=InnoDB.

8) I can create a test table with TYPE=InnoDB. So, it is just that I can not recreate the table that was previously dropped as InnoDB.

How do I clean this up?

TIA!

Options: ReplyQuote


Subject
Views
Written By
Posted
innoDB errno 121
15034
July 10, 2005 10:19AM
6281
July 31, 2005 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.