RE: consistency checking InnoDB tables

2004-01-08 Thread Joshua Thomas 
That's ok, we got the right answer. Mailing lists are great like that. :-)

Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED] 

---
In theory there is no difference between theory and practice. In practice
there is. 
- Yogi Berra 
---



> -Original Message-
> From: robert_rowe [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 08, 2004 4:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: consistency checking InnoDB tables
> 
> 
> 
> Thanks for the correction. I didn't think to check InnoDB's 
> docs. MySQL's docs don't mention this. Sorry for leading you 
> astray Joshua.
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>

Re: consistency checking InnoDB tables

2004-01-08 Thread robert_rowe 

Thanks for the correction. I didn't think to check InnoDB's docs. MySQL's docs don't 
mention this. Sorry for leading you astray Joshua.

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

Re: consistency checking InnoDB tables

2004-01-08 Thread Heikki Tuuri 
Hi!

- Original Message - 
From: "robert_rowe" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 08, 2004 7:16 PM
Subject: Re: consistency checking InnoDB tables


>
> I had the same question a while back and I was told that InnoDB does this
automatically. There are no utilities that I could find.
>

CHECK TABLE tablename;

is the way to check an InnoDB table for consistency.

After a mysqld crash, you do not need to repair InnoDB type tables. The
automatic crash recovery of InnoDB returns them automatically to a
transaction-consistent state.

If an InnoDB table becomes corrupt, the way to 'repair' it is to dump, drop,
and reimport it. In cases of bad corruption you may need to resort to a
backup of your database, or dump all tables and recreate the whole InnoDB
tablespace (that is, the ibdata files and ib_logfiles).

If InnoDB's crash recovery crashes or its internal cleaning processes crash
because of database corruption, then you need to set

set-variable = innodb_force_recovery=...

in my.cnf to a value 1 ... 6. See
http://www.innodb.com/ibman.php#Forcing_recovery for details.

Best regards,

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

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


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

Re: consistency checking InnoDB tables

2004-01-08 Thread robert_rowe 

I had the same question a while back and I was told that InnoDB does this 
automatically. There are no utilities that I could find.

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

consistency checking InnoDB tables

2004-01-07 Thread Joshua Thomas 
Hi folks,

I'm familar with using myisamchk to check/repair myISAM databases; how do I
do consistency checks and repair operations on an InnoDB database?

Thanks,

Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED] 

---
In theory there is no difference between theory and practice. In practice
there is. 
- Yogi Berra 
---