MySQL Update - Error starting service

    • OMV 4.x

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

    • MySQL Update - Error starting service

      The last night MySQL was updated and not work again.
      Looks like the path where the database is located doesn't exist but is there and is browseable from WinSCP and Windows Explorer, but not from the command line:






      For test, in VMWare I make a new fresh install only with OMV, OMV-Extras and MySQL.
      I have a txt with the steps to setup MySQL (i use always, it's simply and works every time) and the path is not found, just like in my NAS.

      service mysql stop
      service mysql status
      mkdir -p /sharedfolders/Soporte/Databases/MySQL
      chown mysql:mysql /sharedfolders/Soporte/Databases/MySQL
      mysql -u root -p -e "SELECT @@datadir;" <--- NOW GET ERROR IN THIS POINT
      cp -rfvp /var/lib/mysql/* /sharedfolders/Soporte/Databases/MySQL/
      Change in WebGUI:
      Bin address: 0.0.0.0
      datadir = /sharedfolders/Soporte/Databases/MySQL
      mysql -u root -p -e "SELECT @@datadir;"
      SQL: /etc/init.d/mysql restart

      Thanks for the help.