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:
    WinSCP.jpg


    Explorer.jpg


    cmd.jpg


    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!