Solved

mysql reindex files

Posted on 2004-08-17
2
1,162 Views
Last Modified: 2008-01-09

I need to reindex a table as it has crashed because of power failure while running
Optimizing nor repairing Doesnt work ?
any ideas to fix this




(errno: 144) when repairing


| zm.Events | check | warning  | Table is marked as crashed and last repair failed    |
| zm.Events | check | warning  | Size of indexfile is: 1774592      Should be: 619520 |
| zm.Events | check | error    | Can't read indexpage from filepos: -1                |
| zm.Events | check | error    | Corrupt    

mysql> REPAIR TABLE Events;
+-----------+--------+----------+---------------------+
| Table     | Op     | Msg_type | Msg_text            |
+-----------+--------+----------+---------------------+
| zm.Events | repair | error    | 5 when fixing table |
| zm.Events | repair | status   | Operation failed    |
+-----------+--------+----------+---------------------+
2 rows in set (1.65 sec)
0
Comment
Question by:aot2002
2 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 500 total points
Comment Utility
Hi

Please check this link..
( backup all the tables before doing anything..)

http://dev.mysql.com/doc/mysql/en/Repair.html


0
 
LVL 1

Author Comment

by:aot2002
Comment Utility
what a pain it deleted all my records but at least its fixed !
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now