Jacob,
- Original Message -
From: "Devore, Jacob" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 12:20 AM
Subject: RE: Losing data
> can one change a table from MyISAM tables into something
Anna,
please check with
SHOW VARIABLES
if InnoDB is enabled in mysqld.
Also check with
SHOW CREATE TABLE tablename
that your tables really are of the InnoDB type. Error 127 means the 'table
is crashed', and I think only MyISAM type tables can return that error
number.
An upgrade to 4.0.2 is
(Sorry for the double email Simon, forgot to
switch the email to text...)
Simon Windsor wrote:
> Hi
>
> The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
> the standard RedHat version.
>
> The machine is running two databases, one is a full archive while the other
> on
Simon Windsor wrote:
> Hi
>
> The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
> the standard RedHat version.
>
> The machine is running two databases, one is a full archive while the other
> ones holds current data. The same five records are unavailable using SQL in
>
Hi
The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
the standard RedHat version.
The machine is running two databases, one is a full archive while the other
ones holds current data. The same five records are unavailable using SQL in
the two databases, but using mys
Simon Windsor wrote:
> Hi
>
> I appear to have lost several records, but on doing mysqldump the
> records are there.
>
> I have tried optimize|repair and the data hasn't re-appeared.
>
> Any ideas ?
Not with this level of information.
(Try including some sql, what you are trying to match, etc.
