Re: Need Help With MYSQL InnoDB

Top Page
Attachments:
Message as email
+ (text/plain)
+ PGP.sig (application/pgp-signature)
+ (text/plain)
Delete this message
Reply to this message
Author: Alex Dean
Date:  
To: Main PLUG discussion list
Subject: Re: Need Help With MYSQL InnoDB


On May 5, 2010, at 12:13 PM, Mark Phillips wrote:

> Alex,
>
> Thanks for the link. I have no idea how the tables were
> corrupted......They were created about 9 months ago to define some
> virtual host, aliases, and users for a postfix email server. Postfix
> only reads them, and they have not been written to since they were
> created. I have paper copies, so I will just recreate them by hand.
> I am not sure how to keep it from happening again.


Have you tried 'REPAIR TABLE virtual_aliases', etc? The data files
may be fine, and MySQL may be able to fix whatever is wrong with the
FRM file for you. Worth a try if your next step is to drop and
recreate. If it doesn't work, you're no worse off than now. Good
luck, and let us know how it goes!

alex
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss