Mysql error

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

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

      Source Code

      1. 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:

      Source Code

      1. apt-get purge mysql-server-5.5 mysql-server-core-5.5 mysql-common
      2. apt-get autoremove
      3. rm -rfv /etc/mysql
      4. rm -rfv /var/lib/mysql
      5. reboot
      6. userdel mysql

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


      Source Code

      1. Błąd http://ftp.pl.debian.org/debian/ wheezy/main libaio1 amd64 0.3.109-3
      2. 404 Not Found
      3. Błąd http://ftp.pl.debian.org/debian/ wheezy/main libdbi-perl amd64 1.622-1+deb7u1
      4. 404 Not Found
      5. Błąd http://ftp.pl.debian.org/debian/ wheezy/main libdbd-mysql-perl amd64 4.021-1+b1
      6. 404 Not Found
      7. Błąd http://security.debian.org/ wheezy/updates/main mysql-common all 5.5.49-0+deb7u1
      8. 404 Not Found
      9. Błąd http://security.debian.org/ wheezy/updates/main libmysqlclient18 amd64 5.5.49-0+deb7u1
      10. 404 Not Found
      11. Błąd http://security.debian.org/ wheezy/updates/main mysql-client-5.5 amd64 5.5.49-0+deb7u1
      12. 404 Not Found
      13. Błąd http://security.debian.org/ wheezy/updates/main mysql-server-core-5.5 amd64 5.5.49-0+deb7u1
      14. 404 Not Found
      15. Błąd http://security.debian.org/ wheezy/updates/main mysql-server-5.5 amd64 5.5.49-0+deb7u1
      16. 404 Not Found
      17. Błąd http://security.debian.org/ wheezy/updates/main mysql-server all 5.5.49-0+deb7u1
      18. 404 Not Found
      19. Nie udało się pobrać http://ftp.pl.debian.org/debian/pool/main/liba/libaio/libaio1_0.3.109-3_amd64.deb 404 Not Found
      20. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/mysql-common_5.5.49-0+deb7u1_all.deb 404 Not Found
      21. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/libmysqlclient18_5.5.49-0+deb7u1_amd64.deb 404 Not Found
      22. Nie udało się pobrać http://ftp.pl.debian.org/debian/pool/main/libd/libdbi-perl/libdbi-perl_1.622-1+deb7u1_amd64.deb 404 Not Found
      23. Nie udało się pobrać http://ftp.pl.debian.org/debian/pool/main/libd/libdbd-mysql-perl/libdbd-mysql-perl_4.021-1+b1_amd64.deb 404 Not Found
      24. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/mysql-client-5.5_5.5.49-0+deb7u1_amd64.deb 404 Not Found
      25. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/mysql-server-core-5.5_5.5.49-0+deb7u1_amd64.deb 404 Not Found
      26. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/mysql-server-5.5_5.5.49-0+deb7u1_amd64.deb 404 Not Found
      27. Nie udało się pobrać http://security.debian.org/pool/updates/main/m/mysql-5.5/mysql-server_5.5.49-0+deb7u1_all.deb 404 Not Found
      28. E: Nie udało się pobrać niektórych archiwów, proszę spróbować uruchomić apt-get update lub użyć opcji --fix-missing.
      Display All

      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 ?
    • Gajdet wrote:

      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.
      Odroid HC2 - armbian - Seagate ST4000DM004 - OMV4.x
      Asrock Q1900DC-ITX - 16GB - 2x Seagate ST3000VN000 - Intenso SSD 120GB - OMV4.x
      :!: Backup - Solutions to common problems - OMV setup videos - OMV4 Documentation - user guide :!:
    • 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 ?
    • There are some guides on the internet on how to move a database from one server to another.

      For example these:
      eversql.com/how-to-transfer-a-…base-between-two-servers/
      digitalocean.com/community/tut…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.
      Odroid HC2 - armbian - Seagate ST4000DM004 - OMV4.x
      Asrock Q1900DC-ITX - 16GB - 2x Seagate ST3000VN000 - Intenso SSD 120GB - OMV4.x
      :!: Backup - Solutions to common problems - OMV setup videos - OMV4 Documentation - user guide :!: