OpenSuSE 11.4 -> 11.5 with myaql upgrade from 5.1 to 5.5

Hi!

I have upgraded my OpenSuSE-11.4 to 12.1 which includes an upgrade of my mysql from 5.1 to 5.5 and I have made a big mistake and not made an mysqldump of my database.

Unfortunately now my mysql isn’t starting and I get the message:

120409 16:27:38 InnoDB: The InnoDB memory heap is disabled
120409 16:27:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120409 16:27:38 InnoDB: Compressed tables use zlib 1.2.5
120409 16:27:38 InnoDB: Initializing buffer pool, size = 128.0M
120409 16:27:38 InnoDB: Completed initialization of buffer pool
120409 16:27:38 InnoDB: highest supported file format is Barracuda.
120409 16:27:38 InnoDB: Waiting for the background threads to start
120409 16:27:39 InnoDB: 1.1.8 started; log sequence number 267603862
120409 16:27:39 [ERROR] mysqld: unknown option ‘–skip-locking’
120409 16:27:39 [ERROR] Aborting

Unfortunately, with google I do not find a solution of the problem. Does anybody know how to fix it? Where can I fix the --skip-locking?

Thanks in advance,

Michael

OK, I have found the place: /etc/my.cnf in section [mysqld]. I have removed the option, and now it is working.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It’s probably in /etc/my.cnf so try to comment it out in there.

Good luck.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJPgwJWAAoJEF+XTK08PnB5VeAP/RMlm92Iwr/zhLd/wU/T6RaR
VR+nv64r9BgybW8ftZIBgOxm2MqHAR+Mmm9eFCxSbuKa1347+xzdciWdXfb993q9
wsUhtlQkVhSThpA1aFpkWh51hQnUTa4T9cAmumMR8QrdHS5a0DieFAWeOZb9cRsq
wwidk6y0iCNU5A0RPLd4PwYxGmj9N289D/hI/QmGqfS4xu/bYmyLckVTvg1pCTSs
3w4pTOtwUGtSymhlJjgH0QeNtUFuTdVaeuw06YBnmvq64nbI/1Wtwh4iN2UZoVjd
WBydXrum7Npq4wt7qfBNDGBQKL0UCp/yCU1RXrIJOVRoCPGGrO77DbGcmuO9gJDC
LH6NIGUrRwlqX3ar354zatfRYVqIiOka9WxjvRppsqpVnXQ8U5AV6P+doSIKjhbz
JEQ9Cgx9gEF0hMTwUKLXTMQR0kkINhZwTCfwM4Q7ri7aFyt3ybJb5UNg9mnJaBSk
EBo7TZKpSA2nOfiCKaxdfa4toBIlQCJYT7BzFDIkqujQ6N2VmN84TIL2UmBnKQRN
4U9sjawgaWFUXaFqjp9Go05khpK/nIDnvqTdwPBvAR24cZYsK8PJBHlxDemKWYGt
D5XkqakwRK5+gltPkfv0jOVawCI5+NnB3NRxZpIjExyyOgtTxEU0az6t4RivzEH9
ODexbFMxngWQtjhm5B0d
=ZPeN
-----END PGP SIGNATURE-----