Error Renaming MySQL Table During ALTER TABLE

  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

I'm at a bit of a loss what this error means. My best guess is that it's a permission issue somewhere, perhaps a garbage collection issue, maybe MySQL is leaving behind a bunch of temp files. This is the result of a cron job that runs every day.

Code: [ Select ]
Error on rename of './dbname/table_name@002dwp.MYI' to './dbname/#sql2-1a97-12c684.MYI' (Errcode: 2)

Here's the query that produces the error.

Code: [ Select ]
$sql = 'ALTER TABLE table_name ORDER BY insert_order';
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 679
  • Loc: Conroe, Texas

Post 3+ Months Ago

looks like a permission....
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8399
  • Loc: USA

Post 3+ Months Ago

This error seems to be very similar to the problem you are having...

A google search for MySQL Errorcode: 2 talks about creating/writing to file.

perror - The "Explain Error Codes" Utility

Hope this at least leads you in the right direction.

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 104 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.