After much searching (and trying to read non-English posts), I've
stumbled across the solution. I installed the mysql-MAX rpm, changed the
my.cnf file and Viola! it works!
--
Hugh
mailto: [EMAIL PROTECTED]
Hugh Taylor wrote:
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.)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
