Mike,

----- Original Message ----- 
From: "Mike Blezien" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, June 01, 2004 5:29 PM
Subject: MySQL Warnings


> Hello,
>
> Noticed this morning when restarting MySQL, saw this in the error log
file:
> Version 4.0.20(RPM's)
...
> Also, we noticed if the "innodb_force_recovery = X" is enabled in the
my.cnf
> file, we can't insert any data without getting table handler errors (-1)
and
> something in the error log file about change "newraw" to "raw".... and
removing
> the "innodb_force_recovery"  ?? Why is that ??

inserting new data to the database can lead to more corruption if

innodb_force_recovery

is set to a value > 0. That is why we have blocked new inserts in that case.

> TIA,
> -- 
> Mike<mickalo>Blezien

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/

> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to