Results 1 to 2 of 2

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

  1. #1

    Default 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.

  2. #2

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

    -----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-----

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •