Mysql error

  • Hello


    I have a problem with mysql plugin. After system down i cannot start it anyway.


    If I trying start i have this message.


    Code
    Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed.




    i try this:


    Code
    apt-get purge mysql-server-5.5 mysql-server-core-5.5 mysql-common
    apt-get autoremove
    rm -rfv /etc/mysql
    rm -rfv /var/lib/mysql
    reboot
    userdel mysql


    And now when i try reinstall plugin i have this message.




    Almost one day still no luck. I think i have to change repositories in /etc/apt/sources.list But what should i write in source.list ?

    • Offizieller Beitrag

    http://ftp.pl.debian.org/debian/ wheezy/main libaio1 amd64 0.3.109-3

    Your system is terribly outdated. You must be on OMV2. Currently there are many issues with OMV3 because of being EOL.
    You should do a fresh install of OMV4.

  • Thank You for reply.
    I try install 4.0 but i have a problem sql.
    One : MySQL i have whole database (invoices) on local disk but i cant overwrite the newone by oldone (i dont know what i have to copy all the directories with/without main files like debian-5.5.flag; ib_logfile0; ib_logfile1; ibdata1; mysql_upgrade_info ?)


    And now i have a stoneburner with down mysql plugin, and OMV4 with clean sql database ?(


    I think i`ll have to hire someone good to do it i`m too old for that :)


    Hmm it is any manual how to copy sql database from local computer to OMV4. Is it possible to do by midnight commander ?

    • Offizieller Beitrag

    There are some guides on the internet on how to move a database from one server to another.


    For example these:
    https://www.eversql.com/how-to…base-between-two-servers/
    https://www.digitalocean.com/c…abase-between-two-servers.


    But also an upgrade of the database might be needed.


    But, to be honest, I cannot talk you through. So either
    a// you give it a try yourself
    b// wait for some others for help
    c// seek help in a MySQL (or MariaDB) forum or
    c// hire someone as you mentioned.

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!