On Mon, 2009-05-18 at 00:20 +0200, Anders Johansson wrote:
On Monday 18 May 2009 00:02:18 Mike McMullin wrote:
090517 17:57:40 mysqld started 090517 17:57:41 [ERROR] /usr/sbin/mysqld: unknown variable 'binlog_format=mixed' 090517 17:57:41 mysqld ended
Am I right in thinking that you have been playing with newer versions of mysql on this system?
Yes, then I switched back.
This looks like you're trying to start mysqld with a configuration file for a much newer version of mysql. The binlog_format variable wasn't added until version 5.1.5 according to the mysql docs
So the uninstall and downgrade to the original install version didn't work. I looked at the various my.cnf* files in /etc and all but the my.cnf.rpmnew had a reference to binlog format=mixed. After mv the my.cnf for back, i did a cp my.cnf.rpmnew my.cnf and this was the result: rcmysql start checkproc: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld Updating MySQL privilege database... Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log Error : Can't find file: 'general_log' (errno: 2) error : Corrupt mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log Error : Can't find file: 'slow_log' (errno: 2) error : Corrupt mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Repairing tables mysql.general_log Error : Can't find file: 'general_log' (errno: 2) error : Corrupt mysql.slow_log Error : Can't find file: 'slow_log' (errno: 2) error : Corrupt Running 'mysql_fix_privilege_tables'... OK Starting service MySQL done and this: ps aux|grep mysql root 17164 0.0 0.0 2936 1308 pts/0 S 21:24 0:00 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql mysql 17209 0.2 1.1 111956 17244 pts/0 Sl 21:24 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock root 17447 0.0 0.0 3232 740 pts/0 S+ 21:38 0:00 grep mysql I'll need to reconfigure mythtv, but I'm sure the practice on that will do me some good, as I am not familiar enough with the program. Thanks, Mike -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org