Need Help With MYSQL InnoDB

[Alex Dean]

On May 5, 2010, at 9:55 AM, Mark Phillips wrote:

> Craig,
>
> I saw that particular article, and it is not the cause of my  
> problem. My tables were setup with the "autoextend" parameter, so  
> they grow as then need to, at least according to the mysql docs.  
> Thanks for looking for that.
>
> I have even tried to repair the tables, but with no success:
>
> mysql> repair table mailserver.virtual_aliases,  
> mailserver.virtual_users, mailserver.virtual_domains;
> +----------------------------+--------+---------- 
> +-------------------------------------------------------------------+
> | Table                      | Op     | Msg_type |  
> Msg_text                                                          |
> +----------------------------+--------+---------- 
> +-------------------------------------------------------------------+
> | mailserver.virtual_aliases | repair | Error    | Incorrect  
> information in file: './mailserver/virtual_aliases.frm' |
> | mailserver.virtual_aliases | repair | error    |  
> Corrupt                                                           |
> | mailserver.virtual_users   | repair | Error    | Incorrect  
> information in file: './mailserver/virtual_users.frm'   |
> | mailserver.virtual_users   | repair | error    |  
> Corrupt                                                           |
> | mailserver.virtual_domains | repair | Error    | Incorrect  
> information in file: './mailserver/virtual_domains.frm' |
> | mailserver.virtual_domains | repair | error    |  
> Corrupt                                                           |
> +----------------------------+--------+---------- 
> +-------------------------------------------------------------------+
> 6 rows in set (0.00 sec)
>
> It seems the tables are corrupt, so i will have to drop them and  
> then rebuild them.
>
> Thanks for the reference!
>
> Mark

The .frm file is the basic table definition, like what columns are in  
the table, what storage engine to use, etc.  Try to determine how  
these got corrupted/changed.  I've never seen MySQL itself corrupt  
a .frm, so I'd suspect some other process or user was mucking with  
them.  Did you perhaps restore a backup .frm which had a table  
definition which doesn't match what's in the InnoDB data files?  (Wild  
guess)

http://forge.mysql.com/wiki/MySQL_Internals_File_Formats

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/c4682a6b/attachment.pgp>