gt;>>>>>
>>>>>>
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> The InnoDB engine was disable because some ib_log files or Ibdata
>>>>>>> files, InnoDB canĀ“t read. In some cases, c
May 06, 2008 9:12 AM
To: Krishna Chandra Prajapati
Cc: mysql
Subject: Re: innodb disabled
Hi,
Can you send the error log file of mysql server in your machine?.
Regards,
Juan
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
Hi Juan,
I have verified director
ry.
> > >
> > > 8) mysql -h... -u... -p... < AllData.sql
> > >
> > > All data get put into this new data folder and will reload the
> > > internal
> > > data dictionary elements pertaining to its new location.
> > >
> > > Movi
Hi Nobert,
I verified the syslog file and didn't found any error.
Krishna Chandra Prajapati
On Wed, May 7, 2008 at 8:20 AM, Norbert Tretkowski <[EMAIL PROTECTED]>
wrote:
> Am Mittwoch, den 07.05.2008, 01:30 schrieb Krishna Chandra Prajapati:
> > Currently error log file is empty. What else can
proper state.
-Original Message-
From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 06, 2008 9:12 AM
To: Krishna Chandra Prajapati
Cc: mysql
Subject: Re: innodb disabled
Hi,
Can you send the error log file of mysql server in your machine?.
Regards,
Juan
On 5/6/08, Krishna Chand
Am Mittwoch, den 07.05.2008, 01:30 schrieb Krishna Chandra Prajapati:
> Currently error log file is empty. What else can be the reason for
> disable innodb.
You mentioned that you're using Debian. The MySQL packages in Debian
using syslog, check /var/log/syslog for errors.
Norbert
--
M
mysqld will regenerate a new ibdata1 file with a
> > > clean
> > > > internal data dictionary.
> > > >
> > > > 8) mysql -h... -u... -p... < AllData.sql
> > > >
> > > > All data get put into this new data folder and will reloa
internal data dictionary.
> > >
> > > 8) mysql -h... -u... -p... < AllData.sql
> > >
> > > All data get put into this new data folder and will reload the
> > internal
> > > data dictionary elements pertaining to its new location.
> > >
&g
but doing
> it
> > this way ensures ibdata1 is in a proper state.
> >
> > -Original Message-
> > From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, May 06, 2008 9:12 AM
> > To: Krishna Chandra Prajapati
> > Cc: mysql
> > S
ing it
> this way ensures ibdata1 is in a proper state.
>
> -Original Message-
> From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 06, 2008 9:12 AM
> To: Krishna Chandra Prajapati
> Cc: mysql
> Subject: Re: innodb disabled
>
> Hi,
>
>
gt; > >
> > > > mysql> show engines;
> > > >
> > > > ++--++
> > > > | Engine | Support |
> > > > Comment
e work but doing it this
way ensures ibdata1 is in a proper state.
-Original Message-
From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 06, 2008 9:12 AM
To: Krishna Chandra Prajapati
Cc: mysql
Subject: Re: innodb disabled
Hi,
Can you send the error log file of mysql
Support |
> > > Comment |
> > >
> > > ++--++
> > > | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
&
-+
> > | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
> > performance |
> > | MEMORY | YES | Hash based, stored in memory, useful for
> > temporary
> > tables |
> > | InnoDB
LT | Default engine as of MySQL 3.23 with great
> performance |
> | MEMORY | YES | Hash based, stored in memory, useful for
> temporary
> tables |
> | InnoDB | DISABLED | Supports transactions, row-level locking, and
> foreign keys |
> | Berkel
gt; HOW CAN I ENABLE INNODB
> > >
> > > mysql> show engines;
> > >
> > > ++--++
> > > | Engine | Support |
> > > Comment|
> > >
> > > ++--+-------
LT | Default engine as of MySQL 3.23 with great
> > performance |
> > | MEMORY | YES | Hash based, stored in memory, useful for
> > temporary
> > tables |
> > | InnoDB | DISABLED | Supports transactions, row-level locking, and
> > foreign key
---+
> | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
> performance |
> | MEMORY | YES | Hash based, stored in memory, useful for
> temporary
> tables |
> | InnoDB | DISABLED | Supports transactions, row-level locking
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary
tables |
| InnoDB | DISABLED | Supports transactions, row-level locking, and
foreign keys |
| BerkeleyDB | NO | Support
y 19, 2007 4:22 PM
Subject: InnoDB Disabled?
I'm running version 5.0.22-community-nt of MySQL. For some reason, InnoDB
is disabled. I have it installed on my XP Pro machine, and it's working
fine, and one on a Windows 2003 server, which is working fine, and another
on a Windows
I'm running version 5.0.22-community-nt of MySQL. For some reason, InnoDB
is disabled. I have it installed on my XP Pro machine, and it's working
fine, and one on a Windows 2003 server, which is working fine, and another
on a Windows 2003 server, which is the one with a problem.
At one point
21 matches
Mail list logo