I have used the command below to change the file system permissions
chown -R mysql:mysql /data/mysql
On Jan 17, 2008 5:01 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Have you checked filesystem permissions where InnoDB needs to create
> its files? And you're sure you've removed ALL of Inno
uary 17, 2008 3:04 AM
To: Rolando Edwards
Cc: MySql
Subject: Re: Innodb gets disabled
I did the same as you have written, but innodb storage engine is not available
now. Even the skip-innodb is commented in my.cnf
On Jan 16, 2008 9:43 PM, Rolando Edwards < [EMAIL PROTECTED]<mailto:[EMAIL
Have you checked filesystem permissions where InnoDB needs to create
its files? And you're sure you've removed ALL of InnoDB's previous
data and log files? And there's nothing in the server's error logs?
Are you looking in the right error logs? (cause an error deliberately
and look for it to be
I did the same as you have written, but innodb storage engine is not
available now. Even the skip-innodb is commented in my.cnf
On Jan 16, 2008 9:43 PM, Rolando Edwards <[EMAIL PROTECTED]> wrote:
> 1) 'mysqldump' all databases to an SQL file
> 2) Drop all databases
> 3) Shutdown mysqld
> 4) Dele
1) 'mysqldump' all databases to an SQL file
2) Drop all databases
3) Shutdown mysqld
4) Delete the ibdata1, ib_logfile0, ib_logfile1
5) Add innodb_file_per_table to my.cnf (which you already did)
6) Make sure you gave this setting in [mysqld] group of my.cnf
innodb_data_file_path=ibdata1:10M:autoe
no errors are there in log file
On Jan 16, 2008 6:38 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati
> <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > In order to reclaim the free space from mysql innodb storage engine. I
> have
> > stoppe
Hi,
On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> In order to reclaim the free space from mysql innodb storage engine. I have
> stopped the mysql server, remove all the things from data (to create new
> datadirectory and log files) directory, added inn
