List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:July 12 2004 8:44pm
Subject:RE: Problem getting innodb enabled ...
View as plain text  
Can you post the exact syntax from your my.cnf file? 

-----Original Message-----
From: Hugh Taylor
To: mysql@stripped
Sent: 7/12/04 3:17 PM
Subject: Problem getting innodb enabled ...

Running MySQL 4.0.15 on SuSE 9 Professional. MySQL works fine until I 
try to allow innodb by uncommenting the lines in the my.cnf file. Once I

do this MySQLwill not start, the error message in the log is:

040712 15:25:39  mysqld started
/usr/sbin/mysqld: ERROR: unknown variable 
'innodb_data_home_dir=/var/lib/mysql/'
040712 15:25:39  mysqld ended

 I found one thread in the SuSE listserv where someone fixed the problem

by deleting all the files and directories in /var/lib/mysql except mysql

and test, but that didn't work for me. The file permissions on 
/var/lib/mysql are:

drwxr-xr-x    9 mysql    daemon        544 2004-07-12 15:58 mysql

and

drwxr-xr-x    9 mysql    daemon        544 2004-07-12 15:58 .
drwxr-xr-x   41 root     root         1056 2004-07-12 15:12 ..
drwx------    2 mysql    daemon        576 2004-07-12 11:12
CPIAInventory
drwx------    2 mysql    daemon      17976 2004-02-26 08:50 egroupware
drwx------    2 mysql    daemon        336 2004-06-28 16:21 EmployeeLog
drwxr-xr-x    2 mysql    daemon         48 2004-07-12 15:22 innodb
drwx------    2 mysql    daemon        528 2003-11-12 18:13 mysql
-rw-rw----    1 mysql    daemon       2877 2004-07-12 15:58 mysqld.log
-rw-rw----    1 mysql    daemon        220 2004-06-29 15:56 
mysqld.log-20040630.gz
-rw-rw----    1 mysql    daemon        220 2004-06-30 18:20 
mysqld.log-20040701.gz
-rw-rw----    1 mysql    daemon        284 2004-07-07 18:04 
mysqld.log-20040708.gz
-rw-rw----    1 mysql    daemon        223 2004-07-10 08:56 
mysqld.log-20040710.gz
-rw-rw----    1 mysql    daemon        237 2004-07-11 11:55 
mysqld.log-20040712.gz
-rw-rw----    1 mysql    daemon          5 2004-07-12 15:58 mysqld.pid
srwxrwxrwx    1 mysql    daemon          0 2004-07-12 15:58 mysql.sock
drwx------    2 mysql    daemon        816 2004-06-28 15:29 phpmyadmin
drwx------    2 mysql    daemon         48 2003-11-12 18:13 test

Any ideas?

(I'm also posting this to the SuSE list.)

-- 

Hugh
mailto: hrtlist@stripped


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
Problem getting innodb enabled ...Hugh Taylor12 Jul
  • Re: Problem getting innodb enabled ...Hugh Taylor13 Jul
RE: Problem getting innodb enabled ...Victor Pendleton12 Jul
  • Re: Problem getting innodb enabled ...Hugh Taylor13 Jul