SEO

No, I am not able to create table of innodb type

On Wed, May 7, 2008 at 2:48 AM, Ananda Kumar <anandkl@gmail.com> wrote:

> r u not able to create tables of type=INNODB.
>
>
>
>
> On 5/7/08, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
> >
> > Hi,
> >
> > What ever you have written i did the same thing, Yet innodb get
> > disabled,
> >
> >
> > On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <
> > redwards@logicworks.net>
> > wrote:
> >
> > > If you just created the /data/mysql folder and moved the ib* files to
> > that
> > > folder from /var/lib/mysql, you may have to contend with the internal
> > data
> > > dictionary with ibdata1.
> > >
> > > You do the following:
> > >
> > > 1) Put the mysql data back into /var/lib/mysql
> > > 2) Configure my.cnf to set datadir=/var/lib/mysql
> > > 3) Restart mysqld
> > >
> > > Once you put it back the way it was, then
> > >
> > > 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
> > >
> > > At this point, 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 reload the
> > internal
> > > data dictionary elements pertaining to its new location.
> > >
> > > Moving MyISAM is simple. Moving InnoDB is a little more work but doing
> > it
> > > this way ensures ibdata1 is in a proper state.
> > >
> > > -----Original Message-----
> > > From: Juan Eduardo Moreno [mailto:juaneduardomc@gmail.com]
> > > 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 Chandra Prajapati <prajapatikc@gmail.com> wrote:
> > > >
> > > > 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---- 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile1
> > > > drwx------ 2 mysql root 4096 2008-03-28 02:58 mysql
> > > >
> > > > In error log file there is error.
> > > > debian-sys-maint error
> > > >
> > > > The above error come while starting mysql for the first time. Then i
> > > have
> > > > given the permissions for debian sys-maint
> > from /etc/mysql/debian.cnf.
> > > > After that restart mysql don't gives any error. still innodb is
> > > disabled.
> > > >
> > > > Thanks,
> > > > Prajapati
> > > >
> > > > On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno <
> > > > juaneduardomc@gmail.com> wrote:
> > > >
> > > > > 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. If you don´t understand nothing in the error log file,
> > please
> > > send
> > > > > this errors to the list.
> > > > >
> > > > > Regards,
> > > > > Juan
> > > > >
> > > > >
> > > > >
> > > > > On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
> > > > > prajapatikc@gmail.com> wrote:
> > > > >
> > > > > > Hi all,
> > > > > >
> > > > > > I have change the data directory from /var/lib/mysql to
> > /data/mysql
> > > > > > directory and adding innodb_file_per_table. By doing this innodb
> > > > > > storage
> > > > > > engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is
> > > it's
> > > > > > adding
> > > > > > will enable or not
> > > > > >
> > > > > > HOW CAN I ENABLE INNODB
> > > > > >
> > > > > > mysql> show engines;
> > > > > >
> > > > > >
> > >
> > +------------+----------+----------------------------------------------------------------+
> > > > > > | Engine | Support |
> > > > > > Comment |
> > > > > >
> > > > > >
> > >
> > +------------+----------+----------------------------------------------------------------+
> > > > > > | 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 | Supports transactions and page-level
> > > > > > locking |
> > > > > > | BLACKHOLE | NO | /dev/null storage engine (anything you
> > > write
> > > > > > to it
> > > > > > disappears) |
> > > > > > | EXAMPLE | NO | Example storage
> > > > > > engine |
> > > > > > | ARCHIVE | YES | Archive storage
> > > > > > engine |
> > > > > > | CSV | YES | CSV storage
> > > > > > engine |
> > > > > > | ndbcluster | DISABLED | Clustered, fault-tolerant,
> > memory-based
> > > > > > tables |
> > > > > > | FEDERATED | YES | Federated MySQL storage
> > > > > > engine |
> > > > > > | MRG_MYISAM | YES | Collection of identical MyISAM
> > > > > > tables |
> > > > > > | ISAM | NO | Obsolete storage
> > > > > > engine |
> > > > > >
> > > > > >
> > >
> > +------------+----------+----------------------------------------------------------------+
> > > > > > 12 rows in set (0.00 sec)
> > > > > >
> > > > > >
> > > > > > # /etc/mysql/my.cnf: The global mysql configuration file.
> > > > > > # $Header:
> > > /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v
> > > > > > 1.3
> > > > > > 2006/02/01 20:25:56 vivo Exp $
> > > > > > #
> > > > > > # $Revision:$
> > > > > > # $Id:$
> > > > > >
> > > > > > # The following options will be passed to all MySQL clients
> > > > > > [client]
> > > > > > #password =
> > > > > > port = 3306
> > > > > > socket =
> > > > > > /var/run/mysqld/mysqld.sock
> > > > > >
> > > > > > [mysql]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqladmin]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlcheck]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqldump]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlimport]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlshow]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [myisamchk]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [myisampack]
> > > > > > character-sets-dir=utf8
> > > > > >
> > > > > >
> > > > > > # use [safe_mysqld] with mysql-3
> > > > > > [mysqld_safe]
> > > > > > err-log =
> > > > > > /var/log/mysql/mysql.err
> > > > > >
> > > > > > # add a section [mysqld-4.1] or [mysqld-5.0] for specific
> > > > > > configurations.
> > > > > > [mysqld]
> > > > > > old_passwords = false # inserted by debconf
> > > > > > character-set-server = utf8
> > > > > > default-character-set = utf8
> > > > > > user = mysql
> > > > > > port = 3306
> > > > > > socket = /var/run/mysqld/mysqld.sock
> > > > > > pid-file = /var/run/mysqld/mysqld.pid
> > > > > > log-error = /var/log/mysql/mysqld.err
> > > > > > basedir = /usr
> > > > > > #datadir = /var/lib/mysql
> > > > > > skip-locking
> > > > > > #set default_storage_engine=InnoDB
> > > > > > key_buffer = 384M
> > > > > > max_allowed_packet = 16M
> > > > > > table_cache = 1024
> > > > > >
> > > > > > sort_buffer_size = 9M
> > > > > >
> > > > > > net_buffer_length = 8K
> > > > > > read_buffer_size = 2M
> > > > > > read_rnd_buffer_size = 32M
> > > > > > myisam_sort_buffer_size = 64M
> > > > > >
> > > > > > query_cache_type = 1
> > > > > > query_cache_size = 100M
> > > > > >
> > > > > > language = /usr/share/mysql/english
> > > > > >
> > > > > > set-variable = max_connections=1024
> > > > > >
> > > > > > # Begin replication section
> > > > > > log-bin=/var/db/db05-master-bin.log
> > > > > > server-id=5
> > > > > >
> > > > > > # End replication section
> > > > > >
> > > > > > #security:
> > > > > > #using "localhost" in connects use sockets by default
> > > > > > #skip-networking
> > > > > > #bind-address = 127.0.0.1
> > > > > >
> > > > > > # Point the following paths to different dedicated disks
> > > > > > tmpdir = /tmp/
> > > > > > #log-update =
> > > > > > /path-to-dedicated-directory/hostname
> > > > > >
> > > > > > # you need debug use flag enabled to use this ones.
> > > > > > # if needed uncomment them, start the server and issue
> > > > > > # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
> > > > > > # this will show you *exactly* what's appening in your server
> > > > > >
> > > > > > #log = /tmp/mysqld.sql
> > > > > > #gdb
> > > > > > #debug = d:t:i,/tmp/mysqld.trace
> > > > > > #one-thread
> > > > > >
> > > > > > # Uncomment the following if you are using BDB tables
> > > > > > #bdb_cache_size = 4M
> > > > > > #bdb_max_lock = 10000
> > > > > >
> > > > > > # The following is the InnoDB configuration
> > > > > > #
> > > > > > # the rest of the innodb config follows:
> > > > > > # don't eat too much memory, we're trying to be safe on 64Mb
> > boxes.
> > > > > > # you might want to bump this up a bit on boxes with more RAM
> > > > > > innodb_buffer_pool_size = 1G
> > > > > > # this is the default, increase if you have lots of tables
> > > > > > innodb_additional_mem_pool_size = 128M
> > > > > > #
> > > > > > # i'd like to use /var/lib/mysql/innodb, but that is seen as a
> > > > > > database :-(
> > > > > > # and upstream wants things to be under /var/lib/mysql/, so
> > that's
> > > the
> > > > > > route
> > > > > > # we have to take for the moment
> > > > > > #innodb_data_home_dir = /var/lib/mysql/
> > > > > > innodb_data_home_dir = /data/mysql/
> > > > > > innodb_log_arch_dir = /data/mysql/
> > > > > > innodb_log_group_home_dir = /data/mysql/
> > > > > >
> > > > > > datadir = /data/mysql/
> > > > > > #innodb_file_per_table
> > > > > >
> > > > > > # you may wish to change this size to be more suitable for your
> > > system
> > > > > > # the max is there to avoid run-away growth on your machine
> > > > > > innodb_data_file_path = ibdata1:10M:autoextend
> > > > > > # we keep this at around 25% of of innodb_buffer_pool_size
> > > > > > # sensible values range from 1MB to
> > > > > > (1/innodb_log_files_in_group*innodb_buffer_pool_size)
> > > > > > innodb_log_file_size = 256M
> > > > > > # this is the default, increase if you have very large
> > transactions.
> > > > > > innodb_log_buffer_size = 256M
> > > > > > # this is the default, and won't hurt you.
> > > > > > # you shouldn't need to tweak it.
> > > > > > set-variable = innodb_log_files_in_group=2
> > > > > > # see the innodb config docs, the other options are not always
> > safe
> > > > > > innodb_flush_log_at_trx_commit = 1
> > > > > > innodb_lock_wait_timeout = 50
> > > > > >
> > > > > >
> > > > > > [mysqldump]
> > > > > > quick
> > > > > > max_allowed_packet = 16M
> > > > > >
> > > > > > [mysql]
> > > > > > # Remove the next comment character if you are not familiar with
> > SQL
> > > > > > #safe-updates
> > > > > >
> > > > > > [isamchk]
> > > > > > key_buffer = 20M
> > > > > > sort_buffer_size = 20M
> > > > > > read_buffer = 2M
> > > > > > write_buffer = 2M
> > > > > >
> > > > > > [myisamchk]
> > > > > > key_buffer = 20M
> > > > > > sort_buffer_size = 20M
> > > > > > read_buffer = 2M
> > > > > > write_buffer = 2M
> > > > > >
> > > > > > [mysqlhotcopy]
> > > > > > interactive-timeout
> > > > > >
> > > > > > #vim: set tabstop=4 :
> > > > > > #vim: set shiftwidth=4 :
> > > > > >
> > > > > >
> > > > > > Krishna Chandra Prajapati
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Krishna Chandra Prajapati
> > > > MySQL DBA,
> > > > Ed Ventures e-Learning Pvt.Ltd.
> > > > 1-8-303/48/15, Sindhi Colony
> > > > P.G.Road, Secunderabad.
> > > > Pin Code: 500003
> > > > Office Number: 040-66489771
> > > > Mob: 9912924044
> > > > URL: ed-ventures-online.com
> > > > Email-id: prajapatikc@gmail.com
> > > >
> > >
> >
> >
> >
> > --
> > Krishna Chandra Prajapati
> > MySQL DBA,
> > Ed Ventures e-Learning Pvt.Ltd.
> > 1-8-303/48/15, Sindhi Colony
> > P.G.Road, Secunderabad.
> > Pin Code: 500003
> > Office Number: 040-66489771
> > Mob: 9912924044
> > URL: ed-ventures-online.com
> > Email-id: prajapatikc@gmail.com
> >
>
>


--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikc@gmail.com

when u try to create the table, what is the error ur getting.

regards
anandkl


On 5/7/08, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
>
> No, I am not able to create table of innodb type
>
> On Wed, May 7, 2008 at 2:48 AM, Ananda Kumar <anandkl@gmail.com> wrote:
>
> > r u not able to create tables of type=INNODB.
> >
> >
> >
> >
> > On 5/7/08, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
> > >
> > > Hi,
> > >
> > > What ever you have written i did the same thing, Yet innodb get
> > > disabled,
> > >
> > >
> > > On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <
> > > redwards@logicworks.net>
> > > wrote:
> > >
> > > > If you just created the /data/mysql folder and moved the ib* files
> > > to that
> > > > folder from /var/lib/mysql, you may have to contend with the
> > > internal data
> > > > dictionary with ibdata1.
> > > >
> > > > You do the following:
> > > >
> > > > 1) Put the mysql data back into /var/lib/mysql
> > > > 2) Configure my.cnf to set datadir=/var/lib/mysql
> > > > 3) Restart mysqld
> > > >
> > > > Once you put it back the way it was, then
> > > >
> > > > 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
> > > >
> > > > At this point, 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 reload the
> > > internal
> > > > data dictionary elements pertaining to its new location.
> > > >
> > > > Moving MyISAM is simple. Moving InnoDB is a little more work but
> > > doing it
> > > > this way ensures ibdata1 is in a proper state.
> > > >
> > > > -----Original Message-----
> > > > From: Juan Eduardo Moreno [mailto:juaneduardomc@gmail.com]
> > > > 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 Chandra Prajapati <prajapatikc@gmail.com> wrote:
> > > > >
> > > > > 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---- 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile1
> > > > > drwx------ 2 mysql root 4096 2008-03-28 02:58 mysql
> > > > >
> > > > > In error log file there is error.
> > > > > debian-sys-maint error
> > > > >
> > > > > The above error come while starting mysql for the first time. Then
> > > i
> > > > have
> > > > > given the permissions for debian sys-maint
> > > from /etc/mysql/debian.cnf.
> > > > > After that restart mysql don't gives any error. still innodb is
> > > > disabled.
> > > > >
> > > > > Thanks,
> > > > > Prajapati
> > > > >
> > > > > On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno <
> > > > > juaneduardomc@gmail.com> wrote:
> > > > >
> > > > > > 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. If you don´t understand nothing in the error log file,
> > > please
> > > > send
> > > > > > this errors to the list.
> > > > > >
> > > > > > Regards,
> > > > > > Juan
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
> > > > > > prajapatikc@gmail.com> wrote:
> > > > > >
> > > > > > > Hi all,
> > > > > > >
> > > > > > > I have change the data directory from /var/lib/mysql to
> > > /data/mysql
> > > > > > > directory and adding innodb_file_per_table. By doing this
> > > innodb
> > > > > > > storage
> > > > > > > engine get dissabled. my.cnf doesn't contains "#skip-innodb".
> > > Is
> > > > it's
> > > > > > > adding
> > > > > > > will enable or not
> > > > > > >
> > > > > > > HOW CAN I ENABLE INNODB
> > > > > > >
> > > > > > > mysql> show engines;
> > > > > > >
> > > > > > >
> > > >
> > > +------------+----------+----------------------------------------------------------------+
> > > > > > > | Engine | Support |
> > > > > > >
> > > Comment |
> > > > > > >
> > > > > > >
> > > >
> > > +------------+----------+----------------------------------------------------------------+
> > > > > > > | 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 | Supports transactions and page-level
> > > > > > > locking |
> > > > > > > | BLACKHOLE | NO | /dev/null storage engine (anything
> > > you
> > > > write
> > > > > > > to it
> > > > > > > disappears) |
> > > > > > > | EXAMPLE | NO | Example storage
> > > > > > > engine |
> > > > > > > | ARCHIVE | YES | Archive storage
> > > > > > > engine |
> > > > > > > | CSV | YES | CSV storage
> > > > > > > engine |
> > > > > > > | ndbcluster | DISABLED | Clustered, fault-tolerant,
> > > memory-based
> > > > > > > tables |
> > > > > > > | FEDERATED | YES | Federated MySQL storage
> > > > > > > engine |
> > > > > > > | MRG_MYISAM | YES | Collection of identical MyISAM
> > > > > > > tables |
> > > > > > > | ISAM | NO | Obsolete storage
> > > > > > > engine |
> > > > > > >
> > > > > > >
> > > >
> > > +------------+----------+----------------------------------------------------------------+
> > > > > > > 12 rows in set (0.00 sec)
> > > > > > >
> > > > > > >
> > > > > > > # /etc/mysql/my.cnf: The global mysql configuration file.
> > > > > > > # $Header:
> > > > /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v
> > > > > > > 1.3
> > > > > > > 2006/02/01 20:25:56 vivo Exp $
> > > > > > > #
> > > > > > > # $Revision:$
> > > > > > > # $Id:$
> > > > > > >
> > > > > > > # The following options will be passed to all MySQL clients
> > > > > > > [client]
> > > > > > > #password =
> > > > > > > port = 3306
> > > > > > > socket =
> > > > > > > /var/run/mysqld/mysqld.sock
> > > > > > >
> > > > > > > [mysql]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [mysqladmin]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [mysqlcheck]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [mysqldump]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [mysqlimport]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [mysqlshow]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [myisamchk]
> > > > > > > character-sets-dir=utf8
> > > > > > > default-character-set=utf8
> > > > > > >
> > > > > > > [myisampack]
> > > > > > > character-sets-dir=utf8
> > > > > > >
> > > > > > >
> > > > > > > # use [safe_mysqld] with mysql-3
> > > > > > > [mysqld_safe]
> > > > > > > err-log =
> > > > > > > /var/log/mysql/mysql.err
> > > > > > >
> > > > > > > # add a section [mysqld-4.1] or [mysqld-5.0] for specific
> > > > > > > configurations.
> > > > > > > [mysqld]
> > > > > > > old_passwords = false # inserted by debconf
> > > > > > > character-set-server = utf8
> > > > > > > default-character-set = utf8
> > > > > > > user = mysql
> > > > > > > port = 3306
> > > > > > > socket = /var/run/mysqld/mysqld.sock
> > > > > > > pid-file = /var/run/mysqld/mysqld.pid
> > > > > > > log-error = /var/log/mysql/mysqld.err
> > > > > > > basedir = /usr
> > > > > > > #datadir = /var/lib/mysql
> > > > > > > skip-locking
> > > > > > > #set default_storage_engine=InnoDB
> > > > > > > key_buffer = 384M
> > > > > > > max_allowed_packet = 16M
> > > > > > > table_cache = 1024
> > > > > > >
> > > > > > > sort_buffer_size = 9M
> > > > > > >
> > > > > > > net_buffer_length = 8K
> > > > > > > read_buffer_size = 2M
> > > > > > > read_rnd_buffer_size = 32M
> > > > > > > myisam_sort_buffer_size = 64M
> > > > > > >
> > > > > > > query_cache_type = 1
> > > > > > > query_cache_size = 100M
> > > > > > >
> > > > > > > language = /usr/share/mysql/english
> > > > > > >
> > > > > > > set-variable = max_connections=1024
> > > > > > >
> > > > > > > # Begin replication section
> > > > > > > log-bin=/var/db/db05-master-bin.log
> > > > > > > server-id=5
> > > > > > >
> > > > > > > # End replication section
> > > > > > >
> > > > > > > #security:
> > > > > > > #using "localhost" in connects use sockets by default
> > > > > > > #skip-networking
> > > > > > > #bind-address = 127.0.0.1
> > > > > > >
> > > > > > > # Point the following paths to different dedicated disks
> > > > > > > tmpdir = /tmp/
> > > > > > > #log-update =
> > > > > > > /path-to-dedicated-directory/hostname
> > > > > > >
> > > > > > > # you need debug use flag enabled to use this ones.
> > > > > > > # if needed uncomment them, start the server and issue
> > > > > > > # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
> > > > > > > # this will show you *exactly* what's appening in your server
> > >
> > > > > > >
> > > > > > > #log = /tmp/mysqld.sql
> > > > > > > #gdb
> > > > > > > #debug = d:t:i,/tmp/mysqld.trace
> > > > > > > #one-thread
> > > > > > >
> > > > > > > # Uncomment the following if you are using BDB tables
> > > > > > > #bdb_cache_size = 4M
> > > > > > > #bdb_max_lock = 10000
> > > > > > >
> > > > > > > # The following is the InnoDB configuration
> > > > > > > #
> > > > > > > # the rest of the innodb config follows:
> > > > > > > # don't eat too much memory, we're trying to be safe on 64Mb
> > > boxes.
> > > > > > > # you might want to bump this up a bit on boxes with more RAM
> > > > > > > innodb_buffer_pool_size = 1G
> > > > > > > # this is the default, increase if you have lots of tables
> > > > > > > innodb_additional_mem_pool_size = 128M
> > > > > > > #
> > > > > > > # i'd like to use /var/lib/mysql/innodb, but that is seen as a
> > > > > > > database :-(
> > > > > > > # and upstream wants things to be under /var/lib/mysql/, so
> > > that's
> > > > the
> > > > > > > route
> > > > > > > # we have to take for the moment
> > > > > > > #innodb_data_home_dir = /var/lib/mysql/
> > > > > > > innodb_data_home_dir = /data/mysql/
> > > > > > > innodb_log_arch_dir = /data/mysql/
> > > > > > > innodb_log_group_home_dir = /data/mysql/
> > > > > > >
> > > > > > > datadir = /data/mysql/
> > > > > > > #innodb_file_per_table
> > > > > > >
> > > > > > > # you may wish to change this size to be more suitable for
> > > your
> > > > system
> > > > > > > # the max is there to avoid run-away growth on your machine
> > > > > > > innodb_data_file_path = ibdata1:10M:autoextend
> > > > > > > # we keep this at around 25% of of innodb_buffer_pool_size
> > > > > > > # sensible values range from 1MB to
> > > > > > > (1/innodb_log_files_in_group*innodb_buffer_pool_size)
> > > > > > > innodb_log_file_size = 256M
> > > > > > > # this is the default, increase if you have very large
> > > transactions.
> > > > > > > innodb_log_buffer_size = 256M
> > > > > > > # this is the default, and won't hurt you.
> > > > > > > # you shouldn't need to tweak it.
> > > > > > > set-variable = innodb_log_files_in_group=2
> > > > > > > # see the innodb config docs, the other options are not always
> > > safe
> > > > > > > innodb_flush_log_at_trx_commit = 1
> > > > > > > innodb_lock_wait_timeout = 50
> > > > > > >
> > > > > > >
> > > > > > > [mysqldump]
> > > > > > > quick
> > > > > > > max_allowed_packet = 16M
> > > > > > >
> > > > > > > [mysql]
> > > > > > > # Remove the next comment character if you are not familiar
> > > with SQL
> > > > > > > #safe-updates
> > > > > > >
> > > > > > > [isamchk]
> > > > > > > key_buffer = 20M
> > > > > > > sort_buffer_size = 20M
> > > > > > > read_buffer = 2M
> > > > > > > write_buffer = 2M
> > > > > > >
> > > > > > > [myisamchk]
> > > > > > > key_buffer = 20M
> > > > > > > sort_buffer_size = 20M
> > > > > > > read_buffer = 2M
> > > > > > > write_buffer = 2M
> > > > > > >
> > > > > > > [mysqlhotcopy]
> > > > > > > interactive-timeout
> > > > > > >
> > > > > > > #vim: set tabstop=4 :
> > > > > > > #vim: set shiftwidth=4 :
> > > > > > >
> > > > > > >
> > > > > > > Krishna Chandra Prajapati
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Krishna Chandra Prajapati
> > > > > MySQL DBA,
> > > > > Ed Ventures e-Learning Pvt.Ltd.
> > > > > 1-8-303/48/15, Sindhi Colony
> > > > > P.G.Road, Secunderabad.
> > > > > Pin Code: 500003
> > > > > Office Number: 040-66489771
> > > > > Mob: 9912924044
> > > > > URL: ed-ventures-online.com
> > > > > Email-id: prajapatikc@gmail.com
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Krishna Chandra Prajapati
> > > MySQL DBA,
> > > Ed Ventures e-Learning Pvt.Ltd.
> > > 1-8-303/48/15, Sindhi Colony
> > > P.G.Road, Secunderabad.
> > > Pin Code: 500003
> > > Office Number: 040-66489771
> > > Mob: 9912924044
> > > URL: ed-ventures-online.com
> > > Email-id: prajapatikc@gmail.com
> > >
> >
> >
> >
>
>
>
> --
> Krishna Chandra Prajapati
> MySQL DBA,
> Ed Ventures e-Learning Pvt.Ltd.
> 1-8-303/48/15, Sindhi Colony
> P.G.Road, Secunderabad.
> Pin Code: 500003
> Office Number: 040-66489771
> Mob: 9912924044
> URL: ed-ventures-online.com
> Email-id: prajapatikc@gmail.com
>

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

It could be the problem with permissions or sizes of iblog or ibdata files

Can you try this back up the iblog and ibdata files and move it to some
other location from /data/mysql
and restart mysql to see if it shows innodb up on show engines, by doing
this atleast u can isolate the
problem is not with iblog or ibdata files

-srini

Krishna Chandra Prajapati wrote:
> Hi,
>
> What ever you have written i did the same thing, Yet innodb get disabled,
>
>
> On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <redwards@logicworks.net>
> wrote:
>
>
>> If you just created the /data/mysql folder and moved the ib* files to that
>> folder from /var/lib/mysql, you may have to contend with the internal data
>> dictionary with ibdata1.
>>
>> You do the following:
>>
>> 1) Put the mysql data back into /var/lib/mysql
>> 2) Configure my.cnf to set datadir=/var/lib/mysql
>> 3) Restart mysqld
>>
>> Once you put it back the way it was, then
>>
>> 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
>>
>> At this point, 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 reload the internal
>> data dictionary elements pertaining to its new location.
>>
>> Moving MyISAM is simple. Moving InnoDB is a little more work but doing it
>> this way ensures ibdata1 is in a proper state.
>>
>> -----Original Message-----
>> From: Juan Eduardo Moreno [mailto:juaneduardomc@gmail.com]
>> 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 Chandra Prajapati <prajapatikc@gmail.com> wrote:
>>
>>> 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---- 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile1
>>> drwx------ 2 mysql root 4096 2008-03-28 02:58 mysql
>>>
>>> In error log file there is error.
>>> debian-sys-maint error
>>>
>>> The above error come while starting mysql for the first time. Then i
>>>
>> have
>>
>>> given the permissions for debian sys-maint from /etc/mysql/debian.cnf.
>>> After that restart mysql don't gives any error. still innodb is
>>>
>> disabled.
>>
>>> Thanks,
>>> Prajapati
>>>
>>> On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno <
>>> juaneduardomc@gmail.com> wrote:
>>>
>>>
>>>> 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. If you don´t understand nothing in the error log file, please
>>>>
>> send
>>
>>>> this errors to the list.
>>>>
>>>> Regards,
>>>> Juan
>>>>
>>>>
>>>>
>>>> On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
>>>> prajapatikc@gmail.com> wrote:
>>>>
>>>>
>>>>> Hi all,
>>>>>
>>>>> I have change the data directory from /var/lib/mysql to /data/mysql
>>>>> directory and adding innodb_file_per_table. By doing this innodb
>>>>> storage
>>>>> engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is
>>>>>
>> it's
>>
>>>>> adding
>>>>> will enable or not
>>>>>
>>>>> HOW CAN I ENABLE INNODB
>>>>>
>>>>> mysql> show engines;
>>>>>
>>>>>
>>>>>
>> +------------+----------+----------------------------------------------------------------+
>>
>>>>> | Engine | Support |
>>>>> Comment |
>>>>>
>>>>>
>>>>>
>> +------------+----------+----------------------------------------------------------------+
>>
>>>>> | 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 | Supports transactions and page-level
>>>>> locking |
>>>>> | BLACKHOLE | NO | /dev/null storage engine (anything you
>>>>>
>> write
>>
>>>>> to it
>>>>> disappears) |
>>>>> | EXAMPLE | NO | Example storage
>>>>> engine |
>>>>> | ARCHIVE | YES | Archive storage
>>>>> engine |
>>>>> | CSV | YES | CSV storage
>>>>> engine |
>>>>> | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based
>>>>> tables |
>>>>> | FEDERATED | YES | Federated MySQL storage
>>>>> engine |
>>>>> | MRG_MYISAM | YES | Collection of identical MyISAM
>>>>> tables |
>>>>> | ISAM | NO | Obsolete storage
>>>>> engine |
>>>>>
>>>>>
>>>>>
>> +------------+----------+----------------------------------------------------------------+
>>
>>>>> 12 rows in set (0.00 sec)
>>>>>
>>>>>
>>>>> # /etc/mysql/my.cnf: The global mysql configuration file.
>>>>> # $Header:
>>>>>
>> /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v
>>
>>>>> 1.3
>>>>> 2006/02/01 20:25:56 vivo Exp $
>>>>> #
>>>>> # $Revision:$
>>>>> # $Id:$
>>>>>
>>>>> # The following options will be passed to all MySQL clients
>>>>> [client]
>>>>> #password =
>>>>> port = 3306
>>>>> socket =
>>>>> /var/run/mysqld/mysqld.sock
>>>>>
>>>>> [mysql]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [mysqladmin]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [mysqlcheck]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [mysqldump]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [mysqlimport]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [mysqlshow]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [myisamchk]
>>>>> character-sets-dir=utf8
>>>>> default-character-set=utf8
>>>>>
>>>>> [myisampack]
>>>>> character-sets-dir=utf8
>>>>>
>>>>>
>>>>> # use [safe_mysqld] with mysql-3
>>>>> [mysqld_safe]
>>>>> err-log =
>>>>> /var/log/mysql/mysql.err
>>>>>
>>>>> # add a section [mysqld-4.1] or [mysqld-5.0] for specific
>>>>> configurations.
>>>>> [mysqld]
>>>>> old_passwords = false # inserted by debconf
>>>>> character-set-server = utf8
>>>>> default-character-set = utf8
>>>>> user = mysql
>>>>> port = 3306
>>>>> socket = /var/run/mysqld/mysqld.sock
>>>>> pid-file = /var/run/mysqld/mysqld.pid
>>>>> log-error = /var/log/mysql/mysqld.err
>>>>> basedir = /usr
>>>>> #datadir = /var/lib/mysql
>>>>> skip-locking
>>>>> #set default_storage_engine=InnoDB
>>>>> key_buffer = 384M
>>>>> max_allowed_packet = 16M
>>>>> table_cache = 1024
>>>>>
>>>>> sort_buffer_size = 9M
>>>>>
>>>>> net_buffer_length = 8K
>>>>> read_buffer_size = 2M
>>>>> read_rnd_buffer_size = 32M
>>>>> myisam_sort_buffer_size = 64M
>>>>>
>>>>> query_cache_type = 1
>>>>> query_cache_size = 100M
>>>>>
>>>>> language = /usr/share/mysql/english
>>>>>
>>>>> set-variable = max_connections=1024
>>>>>
>>>>> # Begin replication section
>>>>> log-bin=/var/db/db05-master-bin.log
>>>>> server-id=5
>>>>>
>>>>> # End replication section
>>>>>
>>>>> #security:
>>>>> #using "localhost" in connects use sockets by default
>>>>> #skip-networking
>>>>> #bind-address = 127.0.0.1
>>>>>
>>>>> # Point the following paths to different dedicated disks
>>>>> tmpdir = /tmp/
>>>>> #log-update =
>>>>> /path-to-dedicated-directory/hostname
>>>>>
>>>>> # you need debug use flag enabled to use this ones.
>>>>> # if needed uncomment them, start the server and issue
>>>>> # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
>>>>> # this will show you *exactly* what's appening in your server
>>>>>
>>>>> #log = /tmp/mysqld.sql
>>>>> #gdb
>>>>> #debug = d:t:i,/tmp/mysqld.trace
>>>>> #one-thread
>>>>>
>>>>> # Uncomment the following if you are using BDB tables
>>>>> #bdb_cache_size = 4M
>>>>> #bdb_max_lock = 10000
>>>>>
>>>>> # The following is the InnoDB configuration
>>>>> #
>>>>> # the rest of the innodb config follows:
>>>>> # don't eat too much memory, we're trying to be safe on 64Mb boxes.
>>>>> # you might want to bump this up a bit on boxes with more RAM
>>>>> innodb_buffer_pool_size = 1G
>>>>> # this is the default, increase if you have lots of tables
>>>>> innodb_additional_mem_pool_size = 128M
>>>>> #
>>>>> # i'd like to use /var/lib/mysql/innodb, but that is seen as a
>>>>> database :-(
>>>>> # and upstream wants things to be under /var/lib/mysql/, so that's
>>>>>
>> the
>>
>>>>> route
>>>>> # we have to take for the moment
>>>>> #innodb_data_home_dir = /var/lib/mysql/
>>>>> innodb_data_home_dir = /data/mysql/
>>>>> innodb_log_arch_dir = /data/mysql/
>>>>> innodb_log_group_home_dir = /data/mysql/
>>>>>
>>>>> datadir = /data/mysql/
>>>>> #innodb_file_per_table
>>>>>
>>>>> # you may wish to change this size to be more suitable for your
>>>>>
>> system
>>
>>>>> # the max is there to avoid run-away growth on your machine
>>>>> innodb_data_file_path = ibdata1:10M:autoextend
>>>>> # we keep this at around 25% of of innodb_buffer_pool_size
>>>>> # sensible values range from 1MB to
>>>>> (1/innodb_log_files_in_group*innodb_buffer_pool_size)
>>>>> innodb_log_file_size = 256M
>>>>> # this is the default, increase if you have very large transactions.
>>>>> innodb_log_buffer_size = 256M
>>>>> # this is the default, and won't hurt you.
>>>>> # you shouldn't need to tweak it.
>>>>> set-variable = innodb_log_files_in_group=2
>>>>> # see the innodb config docs, the other options are not always safe
>>>>> innodb_flush_log_at_trx_commit = 1
>>>>> innodb_lock_wait_timeout = 50
>>>>>
>>>>>
>>>>> [mysqldump]
>>>>> quick
>>>>> max_allowed_packet = 16M
>>>>>
>>>>> [mysql]
>>>>> # Remove the next comment character if you are not familiar with SQL
>>>>> #safe-updates
>>>>>
>>>>> [isamchk]
>>>>> key_buffer = 20M
>>>>> sort_buffer_size = 20M
>>>>> read_buffer = 2M
>>>>> write_buffer = 2M
>>>>>
>>>>> [myisamchk]
>>>>> key_buffer = 20M
>>>>> sort_buffer_size = 20M
>>>>> read_buffer = 2M
>>>>> write_buffer = 2M
>>>>>
>>>>> [mysqlhotcopy]
>>>>> interactive-timeout
>>>>>
>>>>> #vim: set tabstop=4 :
>>>>> #vim: set shiftwidth=4 :
>>>>>
>>>>>
>>>>> Krishna Chandra Prajapati
>>>>>
>>>>>
>>>>
>>>>
>>>
>>> --
>>> Krishna Chandra Prajapati
>>> MySQL DBA,
>>> Ed Ventures e-Learning Pvt.Ltd.
>>> 1-8-303/48/15, Sindhi Colony
>>> P.G.Road, Secunderabad.
>>> Pin Code: 500003
>>> Office Number: 040-66489771
>>> Mob: 9912924044
>>> URL: ed-ventures-online.com
>>> Email-id: prajapatikc@gmail.com
>>>
>>>
>
>
>
>

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 <norbert@tretkowski.de>
wrote:

> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=p...tikc@gmail.com
>
>


--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikc@gmail.com

Thanks a lot to all of you.

On Wed, May 7, 2008 at 8:51 PM, Srini <srini@geekcrossing.net> wrote:

> It could be the problem with permissions or sizes of iblog or ibdata files
>
> Can you try this back up the iblog and ibdata files and move it to some
> other location from /data/mysql
> and restart mysql to see if it shows innodb up on show engines, by doing
> this atleast u can isolate the
> problem is not with iblog or ibdata files
>
> -srini
>
>
> Krishna Chandra Prajapati wrote:
>
> > Hi,
> >
> > What ever you have written i did the same thing, Yet innodb get
> > disabled,
> >
> >
> > On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <
> > redwards@logicworks.net>
> > wrote:
> >
> >
> >
> > > If you just created the /data/mysql folder and moved the ib* files to
> > > that
> > > folder from /var/lib/mysql, you may have to contend with the internal
> > > data
> > > dictionary with ibdata1.
> > >
> > > You do the following:
> > >
> > > 1) Put the mysql data back into /var/lib/mysql
> > > 2) Configure my.cnf to set datadir=/var/lib/mysql
> > > 3) Restart mysqld
> > >
> > > Once you put it back the way it was, then
> > >
> > > 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
> > >
> > > At this point, 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 reload the
> > > internal
> > > data dictionary elements pertaining to its new location.
> > >
> > > Moving MyISAM is simple. Moving InnoDB is a little more work but doing
> > > it
> > > this way ensures ibdata1 is in a proper state.
> > >
> > > -----Original Message-----
> > > From: Juan Eduardo Moreno [mailto:juaneduardomc@gmail.com]
> > > 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 Chandra Prajapati <prajapatikc@gmail.com> wrote:
> > >
> > >
> > > > 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---- 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile1
> > > > drwx------ 2 mysql root 4096 2008-03-28 02:58 mysql
> > > >
> > > > In error log file there is error.
> > > > debian-sys-maint error
> > > >
> > > > The above error come while starting mysql for the first time. Then i
> > > >
> > > >
> > > have
> > >
> > >
> > > > given the permissions for debian sys-maint from
> > > > /etc/mysql/debian.cnf.
> > > > After that restart mysql don't gives any error. still innodb is
> > > >
> > > >
> > > disabled.
> > >
> > >
> > > > Thanks,
> > > > Prajapati
> > > >
> > > > On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno <
> > > > juaneduardomc@gmail.com> wrote:
> > > >
> > > >
> > > >
> > > > > 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. If you don´t understand nothing in the error log file,
> > > > > please
> > > > >
> > > > >
> > > > send
> > >
> > >
> > > > this errors to the list.
> > > > >
> > > > > Regards,
> > > > > Juan
> > > > >
> > > > >
> > > > >
> > > > > On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
> > > > > prajapatikc@gmail.com> wrote:
> > > > >
> > > > >
> > > > >
> > > > > > Hi all,
> > > > > >
> > > > > > I have change the data directory from /var/lib/mysql to
> > > > > > /data/mysql
> > > > > > directory and adding innodb_file_per_table. By doing this innodb
> > > > > > storage
> > > > > > engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is
> > > > > >
> > > > > >
> > > > > it's
> > >
> > >
> > > > adding
> > > > > > will enable or not
> > > > > >
> > > > > > HOW CAN I ENABLE INNODB
> > > > > >
> > > > > > mysql> show engines;
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > +------------+----------+----------------------------------------------------------------+
> > >
> > >
> > > > | Engine | Support |
> > > > > > Comment |
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > +------------+----------+----------------------------------------------------------------+
> > >
> > >
> > > > | 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 | Supports transactions and page-level
> > > > > > locking |
> > > > > > | BLACKHOLE | NO | /dev/null storage engine (anything you
> > > > > >
> > > > > >
> > > > > write
> > >
> > >
> > > > to it
> > > > > > disappears) |
> > > > > > | EXAMPLE | NO | Example storage
> > > > > > engine |
> > > > > > | ARCHIVE | YES | Archive storage
> > > > > > engine |
> > > > > > | CSV | YES | CSV storage
> > > > > > engine |
> > > > > > | ndbcluster | DISABLED | Clustered, fault-tolerant,
> > > > > > memory-based
> > > > > > tables |
> > > > > > | FEDERATED | YES | Federated MySQL storage
> > > > > > engine |
> > > > > > | MRG_MYISAM | YES | Collection of identical MyISAM
> > > > > > tables |
> > > > > > | ISAM | NO | Obsolete storage
> > > > > > engine |
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > +------------+----------+----------------------------------------------------------------+
> > >
> > >
> > > > 12 rows in set (0.00 sec)
> > > > > >
> > > > > >
> > > > > > # /etc/mysql/my.cnf: The global mysql configuration file.
> > > > > > # $Header:
> > > > > >
> > > > > >
> > > > > /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v
> > >
> > >
> > > > 1.3
> > > > > > 2006/02/01 20:25:56 vivo Exp $
> > > > > > #
> > > > > > # $Revision:$
> > > > > > # $Id:$
> > > > > >
> > > > > > # The following options will be passed to all MySQL clients
> > > > > > [client]
> > > > > > #password =
> > > > > > port = 3306
> > > > > > socket =
> > > > > > /var/run/mysqld/mysqld.sock
> > > > > >
> > > > > > [mysql]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqladmin]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlcheck]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqldump]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlimport]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [mysqlshow]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [myisamchk]
> > > > > > character-sets-dir=utf8
> > > > > > default-character-set=utf8
> > > > > >
> > > > > > [myisampack]
> > > > > > character-sets-dir=utf8
> > > > > >
> > > > > >
> > > > > > # use [safe_mysqld] with mysql-3
> > > > > > [mysqld_safe]
> > > > > > err-log =
> > > > > > /var/log/mysql/mysql.err
> > > > > >
> > > > > > # add a section [mysqld-4.1] or [mysqld-5.0] for specific
> > > > > > configurations.
> > > > > > [mysqld]
> > > > > > old_passwords = false # inserted by debconf
> > > > > > character-set-server = utf8
> > > > > > default-character-set = utf8
> > > > > > user = mysql
> > > > > > port = 3306
> > > > > > socket = /var/run/mysqld/mysqld.sock
> > > > > > pid-file = /var/run/mysqld/mysqld.pid
> > > > > > log-error = /var/log/mysql/mysqld.err
> > > > > > basedir = /usr
> > > > > > #datadir = /var/lib/mysql
> > > > > > skip-locking
> > > > > > #set default_storage_engine=InnoDB
> > > > > > key_buffer = 384M
> > > > > > max_allowed_packet = 16M
> > > > > > table_cache = 1024
> > > > > >
> > > > > > sort_buffer_size = 9M
> > > > > >
> > > > > > net_buffer_length = 8K
> > > > > > read_buffer_size = 2M
> > > > > > read_rnd_buffer_size = 32M
> > > > > > myisam_sort_buffer_size = 64M
> > > > > >
> > > > > > query_cache_type = 1
> > > > > > query_cache_size = 100M
> > > > > >
> > > > > > language = /usr/share/mysql/english
> > > > > >
> > > > > > set-variable = max_connections=1024
> > > > > >
> > > > > > # Begin replication section
> > > > > > log-bin=/var/db/db05-master-bin.log
> > > > > > server-id=5
> > > > > >
> > > > > > # End replication section
> > > > > >
> > > > > > #security:
> > > > > > #using "localhost" in connects use sockets by default
> > > > > > #skip-networking
> > > > > > #bind-address = 127.0.0.1
> > > > > >
> > > > > > # Point the following paths to different dedicated disks
> > > > > > tmpdir = /tmp/
> > > > > > #log-update =
> > > > > > /path-to-dedicated-directory/hostname
> > > > > >
> > > > > > # you need debug use flag enabled to use this ones.
> > > > > > # if needed uncomment them, start the server and issue
> > > > > > # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
> > > > > > # this will show you *exactly* what's appening in your server
> > > > > >
> > > > > > #log = /tmp/mysqld.sql
> > > > > > #gdb
> > > > > > #debug = d:t:i,/tmp/mysqld.trace
> > > > > > #one-thread
> > > > > >
> > > > > > # Uncomment the following if you are using BDB tables
> > > > > > #bdb_cache_size = 4M
> > > > > > #bdb_max_lock = 10000
> > > > > >
> > > > > > # The following is the InnoDB configuration
> > > > > > #
> > > > > > # the rest of the innodb config follows:
> > > > > > # don't eat too much memory, we're trying to be safe on 64Mb
> > > > > > boxes.
> > > > > > # you might want to bump this up a bit on boxes with more RAM
> > > > > > innodb_buffer_pool_size = 1G
> > > > > > # this is the default, increase if you have lots of tables
> > > > > > innodb_additional_mem_pool_size = 128M
> > > > > > #
> > > > > > # i'd like to use /var/lib/mysql/innodb, but that is seen as a
> > > > > > database :-(
> > > > > > # and upstream wants things to be under /var/lib/mysql/, so
> > > > > > that's
> > > > > >
> > > > > >
> > > > > the
> > >
> > >
> > > > route
> > > > > > # we have to take for the moment
> > > > > > #innodb_data_home_dir = /var/lib/mysql/
> > > > > > innodb_data_home_dir = /data/mysql/
> > > > > > innodb_log_arch_dir = /data/mysql/
> > > > > > innodb_log_group_home_dir = /data/mysql/
> > > > > >
> > > > > > datadir = /data/mysql/
> > > > > > #innodb_file_per_table
> > > > > >
> > > > > > # you may wish to change this size to be more suitable for your
> > > > > >
> > > > > >
> > > > > system
> > >
> > >
> > > > # the max is there to avoid run-away growth on your machine
> > > > > > innodb_data_file_path = ibdata1:10M:autoextend
> > > > > > # we keep this at around 25% of of innodb_buffer_pool_size
> > > > > > # sensible values range from 1MB to
> > > > > > (1/innodb_log_files_in_group*innodb_buffer_pool_size)
> > > > > > innodb_log_file_size = 256M
> > > > > > # this is the default, increase if you have very large
> > > > > > transactions.
> > > > > > innodb_l