Can you post the exact syntax from your my.cnf file? -----Original Message----- From: Hugh Taylor To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
