1

My issue is similar to this question:

ALTER TABLE error

My message is:

#1025 - Error on rename of './balance/#A' to './balance/#B' (errno: -1)

Anytime I want to alter the table I get a cryptic message that it can't be done (like the above question).

All the research I've done points to an issue with foreign keys referencing the table in question. My table has no foreign keys and is quite simple, just a unique primary key.

MySQL documentation for this issue is spartan and does not give any details. I've had an issue in the past with permissions, and I couldn't even see the contents of innoDB tables, but I resolved that. I wonder if this could be some sort of permission issue. Using MySQL 5.5.15-log.

This issue was resolved. In my case it had to with with having forced recovery for my innodb tables enabled. I found it by looking in my log. When forced recovery is on, apparently no changes are allowed to the DB.

Now, the fact that it generated a foreign key error in my InnoDB engine log with no FKs is another issue.....I posted it as a bug to MySQL.

Community
  • 1
  • 1
Len
  • 542
  • 1
  • 5
  • 11
  • 1
    Can you send the exact command you're trying to execute? – Doug Aug 22 '11 at 01:38
  • RENAME TABLE `x`.`y` TO `x`.`z` ; MySQL said: Documentation #1025 - Error on rename of './x/y' to './x/z' (errno: -1) – Len Aug 22 '11 at 02:28
  • "MySQL documentation for this issue is **spartan** and does not give any details" - I agree, THIS IS MADNESS!!!! – Adam Prax Aug 23 '11 at 17:47

0 Answers0