Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a MySQL database on my server and I"m pretty sure it's an int over flow on one table with an auto_increment field that's crashing it.

I can delete the table, it's not very important, but I can't get into the server.

Is there anyway to delete that database from the file system or without logging into MySQL?


share|improve this question

Yes, if your MySQL is installed from a package, just go to /var/lib/mysql (or something like that, not sure what distro you are running). You will see a bunch of folders. Those folders have your table files in them. You can just more the one thats not working outside of /var/lib/mysql. Just stop MySQL before you do that.

share|improve this answer
It's a windows 2008 box. Should I just delete the directory with the offending database? – Ryan Smith May 13 '10 at 3:28
You don't have to delete it, just move it out of that folder. – solefald May 13 '10 at 3:36
That killed the server. Had to move back to a snap shot after I deleted the file. – Ryan Smith May 13 '10 at 3:38
MySQL server? Did you stop it before removing the directory? I have done it many times before, and never experienced a single issue. I suppose something is different with Windows version of MySQL.... – solefald May 13 '10 at 3:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.