Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

HELP! THE WORLD IS ENDING!

share|improve this question
add comment

1 Answer

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
add comment

Your Answer

 
discard

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