INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Damaged Database

Damaged Database

(OP)
G'day!

I've got an unusual situation. We backup our MySQL databases every night. The backup is done by copying the folders containing the database files (MyISAM on a Windows 2000 server) to a temp folder. They are then zipped and FTP'd to a server at our offices. If I then unzip the database they is always one table that needs to be repaired. I've check the table on the live server using CHECK TABLE table_name and it comes up clean. I've even tried the extended CHECK TABLE and it also comes up clean. If I copy just that table from the live server to my local installation and run the CHECK TABLE table name EXTENDED I then get a size difference warning for the indexfile and the datafile as well as a error "Record at: 2874384 Can't find key for index: 6" and then another error that simply says Corrupt. The table is then marked as crashed. If I run REPAIR TABLE table_name EXTENDED I get a message stating that the number of rows changed from 217393 to 230912.

I hope I'm making sense. Any help would be appreciated.

Many thanks

robhob

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close