]>
To: "Cliff" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 05, 2004 10:16 AM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff wrote:
> > I think I may have gotten closer to the root of the problem. It seems
that
> > the field nam
Cliff wrote:
I think I may have gotten closer to the root of the problem. It seems that
the field named 'comments' is the one that crashes the server when it is
selected. Here is the output of the logs when I do 'select comments from
allusa':
040304 23:14:52 mysqld restarted
040304 23:14:53 InnoD
Discussion« Previous MessageNext Message »
From: Cliff Date: March 5 2004 8:12am
Subject: Re: Major problem converting MyISAM to InnoDB
I think I may have gotten closer to the root of the problem. It seems that
the field named 'comments' is the one that crashes the server when it is
selected. H
: Thursday, March 04, 2004 1:24 PM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> - Original Message -
> From: ""Cliff"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Thursday, March 04, 2004 7:07 PM
&g
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 1:24 PM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> - Original Message -
> From: "&q
Cliff,
- Original Message -
From: ""Cliff"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 04, 2004 7:07 PM
Subject: Re: Major problem converting MyISAM to InnoDB
> Hi, I ran CHECK TABLE with the EXTENDED option on the table a
> Hi, I ran CHECK TABLE with the EXTENDED option on the table and it reports
> everything ok:
>
> mysql> check table allusa extended;
> +---+---+--+--+
> | Table | Op| Msg_type | Msg_text |
> +---+---+--+--+
> | bb.allusa | check | s
nal Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 12:36 AM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> please run
>
> CHECK TABLE ...
>
> on your table and look if mysql
ckup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday
Cliff wrote:
Recently I tried to convert our largest table from MyISAM to InnoDB. During
the process I believe there was a problem where something was corrupt along
the way. It was stupid, but I did not verify that our backup system was
working correctly, since I assumed it had been running as usua
Recently I tried to convert our largest table from MyISAM to InnoDB. During
the process I believe there was a problem where something was corrupt along
the way. It was stupid, but I did not verify that our backup system was
working correctly, since I assumed it had been running as usual. It was not
11 matches
Mail list logo
