Blogiversity.org

Welcome to Blogiversity.org Sign in | Join | Help
in Search
Blogiversity Links - fast online loans from America One : offering Life Lock discount

Grey's Music

MySQL: Repairing Tables

So my blog's been down for a few days because I've been working on other projects and did not realize greysmusic had lost touch with the database. I only noticed last night because I hadn't made any money with AdSense. Lo and behold everything is down. I log into PHPMyAdmin (if you don't have it, get it) and Pow(!) `greysmusic_entries.myi` is corrupt. So how do you fix something like that? Easy. Go to the SQL tab and simply type: repair table `table_name`. Leave off the ".myi". In my case it was repair table `greysmusic_entries`. It will either fix the misnumbered rows/bad blocks/etc or it will simply say "OK". If it says "OK" you're trying to fix the wrong table. Keep running it on all your other tables until you're all fixed.

Comments

No Comments

Leave a Comment

You must log in first to post a comment. Click here to log in.

Not a member? Click here to sign up today!