Need Help With MYSQL InnoDB
Alex Dean
alex at crackpot.org
Wed May 5 20:35:54 MST 2010
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100505/068a339c/attachment.pgp>
More information about the PLUG-discuss
mailing list