Problem getting innodb enabled ...

Mon, 12 Jul 2004 13:20:18 -0700

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: [EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to