gt;>> 4) mysqldump -h... -u... -p... --single-transaction --all-databases
>>>>> --routines --triggers > AllData.sql
>>>>> 5) Make /data/mysql TOTALLY EMPTY.
>>>>> 6) Configure my.cnf to set datadir=/data/mysql
>>>>> 7) Restart mysqld
>
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,
>
>
Hi,
Currently error log file is empty. What else can be the reason for disable
innodb.
On Tue, May 6, 2008 at 9:11 AM, Juan Eduardo Moreno <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Can you send the error log file of mysql server in your machine?.
>
> Regards,
> Juan
>
>
> On 5/6/08, Krishna Chandra
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
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 directory permissions, its shown below.
>
> linux76:~# ls -l /data/mysql/
> total 535088
> drwx-- 2 mysql mysq
Hi Juan,
I have verified directory permissions, its shown below.
linux76:~# ls -l /data/mysql/
total 535088
drwx-- 2 mysql mysql 20480 2008-05-04 23:44 dip
-rw-rw 1 mysql mysql 10485760 2007-12-23 01:21 ibdata1
-rw-rw 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile0
-rw-rw---
Hi,
The InnoDB engine was disable because some ib_log files or Ibdata files,
InnoDB can´t read. In some cases, could be a directory permissions or some
error in creation of ib_logfiles when database is started. If you want , try
to see in the error log file generated in order to see more details.
U also need innodb tables?.
As you have myisam as ur default, SHOW STATUS is showing it correctly.
regards
anandkl
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> hi
>
> I want MYISAM to be the default storage engine.
>
>
> On Tue, May 6, 2008 at 4:42 AM, Ananda Kumar <[EMAI
hi
I want MYISAM to be the default storage engine.
On Tue, May 6, 2008 at 4:42 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> looks like your mn.cnf has this commented
>
> #set default_storage_engine=InnoDB
>
> Can u please uncomment it, if u want INNODB as ur default storage engine.
>
> On 5/6/
looks like your mn.cnf has this commented
#set default_storage_engine=InnoDB
Can u please uncomment it, if u want INNODB as ur default storage engine.
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I have change the data directory from /var/lib/mysql to /data/mys
Found the problem. After searching for a while, I found where someone
deleted the ib_logfile*.* in the data directory. I did that, and that
cleaned it up.
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Saturday, May 19, 2007 4:22 PM
Subject: In
19 matches
Mail list logo
