How To Repair Corrupted or Crashed MySQL Tables? [Hacks and Mods]
Posted By Keith Dsouza On September 23, 2008 @ 5:34 am In Hacks And Mods | 1 Comment
Welcome to another hacks and mods article, in this one we look at a critical issue which many of use face once in a while, though the issue is trivial and seldom happens we have written a worthwhile tip to backup [1] your database from the command prompt [2] so do check it out.
If you are looking to repair corrupted MySQL tables, Techblissonline has a mod which we will be featuring today.
To repair a MySQL table follow the following steps:
- Login to phpMyAdmin
- Select the affected MySQL database.
- In the options available from the check the tables you want to repair.
- Navigate to the bottom of the page and select Repair Table from the menu.
This should run a rescue on the tables you selected for repair.
Article printed from Techie Buzz: http://techie-buzz.com
URL to article: http://techie-buzz.com/hacks-and-mods/how-to-repair-corrupted-or-crashed-mysql-tables.html
URLs in this post:
[1] backup: http://techie-buzz.com/tag/backup
[2] database from the command prompt: http://techie-buzz.com/tips-and-tricks/how-to-backup-and-email-your-blog-mysql-database-from-command-prompt.html
[3] Mod Tip From Techblissonline: http://techblissonline.com/mysql-tables-corrupt-crash-repair-phpmyadmin/
Click here to print.