On Tuesday 13 April 2004 01:32, Gideon Hallett typed: [SNIP] usual stuff]
This may be a dim question, but what does /var/lib/mysql/mysql.log say when you try starting it?
"040401 12:56:42 mysqld started /usr/sbin/mysqld: ready for connections. Version: '4.0.15' socket: '/var/lib/mysql/mysql.sock' port: 3306"
- is what I get in the log when starting a (working) mysqld under 9.0
OK: here I will run the start thingy, and then run it again, and then show the last two sets of error messages for those two commands (a set of messages for these errors takes around 12 lines, so "tail -12" should do it, or "tail -24" for both). BTW I do not have a "/var/lib/mysql/mysql.log" file...it is "/ var/lib/mysql/mysqld.log", I wonder why? linux:~ # rcmysql start Starting service MySQL failed linux:~ # /etc/init.d/mysql start Starting service MySQL failed linux:/var/lib/mysql # tail -24 /var/lib/mysql/mysqld.log 040414 03:06:27 mysqld started InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 20971520 bytes! 040414 3:06:29 Can't init databases 040414 3:06:29 Aborting 040414 3:06:29 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 040414 3:06:29 /usr/sbin/mysqld-max: Shutdown Complete 040414 03:06:29 mysqld ended 040414 03:06:44 mysqld started InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 20971520 bytes! 040414 3:06:44 Can't init databases 040414 3:06:44 Aborting 040414 3:06:44 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 040414 3:06:44 /usr/sbin/mysqld-max: Shutdown Complete 040414 03:06:44 mysqld ended linux:/var/lib/mysql # So, you see: those are the error messages for the two commands that I issued just now. (I entered blank lines above for readability). Thanks, --Mark VII pampaluz@cox.net