Ran out of space -- Did this corrupt MySQL Databases?

I'm not a DB admin, and not good at working with MySQL besides creating and dropping databases and tweaking the my.cnf file.

My Linode ran out of space, and I didn't know it until funky things were happening on my WordPress sites. Then finally one of the sites gave a database connection error when I rebooted the Linode. Finally hit me what was going on.

So, with that said, now that the space thing is fixed, are my databases screwed up? I'm on Debian 7.4 and whatever version of MySQL came with that.

Is there a command I can type in to repair all innodb and isam tables? I have no idea if anything is corrupted. Sites seem fine right now, but I'm worried that something is gonna creep up on me.

THANKS!!!!

PS. Merry Christmas too.

1 Reply

Hello,

You should be in good shape. However just to be on the safe side you can run some checks using some of the commands that are well documented in this article:

http://www.databasejournal.com/features … -MySQL.htm">http://www.databasejournal.com/features/mysql/article.php/3300511/Repairing-Database-Corruption-in-MySQL.htm

Let me know if you have any questions.

Best,

Lev

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct