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
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) Delete
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
: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
PROTECTED] wrote:
1
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
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
stopped the mysql
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
