Re: Incorrect information in file: './maindb/users.frm'

2008-06-05 Thread Stut
Sorry, should've sent an update last night. That was indeed the problem. It's fixed now. Thanks to everyone who helped. -Stut -- http://stut.net/ On 5 Jun 2008, at 09:04, Ben Clewett wrote: It could be the size of your InnoDB log files. Or something else which stops InnoDB running. I o

Re: Incorrect information in file: './maindb/users.frm'

2008-06-05 Thread Ben Clewett
It could be the size of your InnoDB log files. Or something else which stops InnoDB running. I once changed server and by mistake changed the size of the innodb_log_file_size. The result was that InnoDB could not start and instead dissabled its self. Therefore every table I created became M

Re: Incorrect information in file: './maindb/users.frm'

2008-06-04 Thread Stut
On 5 Jun 2008, at 00:41, Phil wrote: Just a very quick guess but is innobd engine running ? SHOW STATUS like '%inno%' Output shown below. I've just finished importing the backup file again (into a different DB) and it's ignored the engine=innodb on each create table and has used MyISAM ins

Re: Incorrect information in file: './maindb/users.frm'

2008-06-04 Thread Phil
Just a very quick guess but is innobd engine running ? SHOW STATUS like '%inno%' On Wed, Jun 4, 2008 at 6:44 PM, Stut <[EMAIL PROTECTED]> wrote: > On 4 Jun 2008, at 23:10, Stut wrote: > >> HELP!! >> >> Our database just died. SHOW TABLE STATUS shows the message in the status >> line for every ta

Re: Incorrect information in file: './maindb/users.frm'

2008-06-04 Thread Stut
On 4 Jun 2008, at 23:10, Stut wrote: HELP!! Our database just died. SHOW TABLE STATUS shows the message in the status line for every table except the one that's MyISAM - the rest are InnoDB. Is there any way to rebuild the .frm files for the InnoDB tables? Can anyone help? I know I haven

Re: Incorrect information in file...

2006-09-01 Thread Duane Hill
: Duane Hill [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 31, 2006 10:18 AM > To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: Incorrect information in file... > On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: >> Hi Duane, >> Have you t

Re: Incorrect information in file...

2006-08-31 Thread Duane Hill
To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: Incorrect information in file... > On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: >> Hi Duane, >> Have you tried to repair "test" table using "REPAIR" to see if that >>

RE: Incorrect information in file...

2006-08-31 Thread Mikhail Berman
TED] Sent: Thursday, August 31, 2006 10:18 AM To: Mikhail Berman Cc: mysql@lists.mysql.com Subject: Re: Incorrect information in file... On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR"

Re: Incorrect information in file...

2006-08-31 Thread Duane Hill
On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR" to see if that > solves your problem? That didn't seem to work. The result returned was: mysql> repair table test; +-++--+---

Re: Incorrect information in file...

2006-08-31 Thread Duane Hill
On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR" to see if that > solves your problem? No I had not. The problem is easily duplicated and I do not have anything really set up yet. I will try that. Thanks.

RE: Incorrect information in file...

2006-08-31 Thread Mikhail Berman
Hi Duane, Have you tried to repair "test" table using "REPAIR" to see if that solves your problem? Regards, Mikhail Berman -Original Message- From: Duane Hill [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:49 AM To: mysql@lists.mysql.com Subject: Incorrect information in f