Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Thu Dec 25, 2014 4:24 am 
Offline
Senior Member

Joined: Tue Sep 28, 2010 12:05 pm
Posts: 90
Website: http://www.theatereleven.com
AOL: theatereleven
Location: Santa Monica, CA
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.

_________________
kyler d. boudreau
theatereleven.com


Top
   
PostPosted: Thu Dec 25, 2014 4:56 am 
Offline
Linode Staff

Joined: Mon Aug 18, 2014 2:43 pm
Posts: 35
Website: https://levlaz.org
Location: Absecon, NJ
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

Let me know if you have any questions.

Best,
Lev

_________________
Best,
Lev
https://levlaz.org


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 1 guest


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

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group