[MySQL] datadirectory

  • Hi there!
    is it possible, using a workaround or anything else, to use the standard-path (/var/lib/mysql) for the MySQL-Server, instead of any share (without using symlinks), or do i have to use the distri-version of mysql and manage it myself?
    I have an SSD RAID1 only for the operating system and dont want to have the data on a share.


    thanks in advance.

  • The newest version of the plugin, 2.1, doesn't use a location at all. So, it stays in /var/lib/mysql and should do exactly what you want. If someone wants to move it, they have to specify the location in extra options and move the files manually.

    omv 5.6.6 usul | 64 bit | 5.11 proxmox kernel | omvextrasorg 5.6.1
    omv-extras.org plugins source code and issue tracker - github


    Please read this before posting a question.
    Please don't PM for support... Too many PMs!

  • If you are running OMV 2.x and have the omv-extras testing repo enabled, it is.


    Code
    $ reprepro ls openmediavault-mysql
    openmediavault-mysql | 0.5.13 | sardaukar | i386, amd64, armel, armhf
    openmediavault-mysql | 1.0.16 | kralizec | i386, amd64, armel, armhf
    openmediavault-mysql | 2.1 | stoneburner-testing | i386, amd64, armel, armhf
    openmediavault-mysql | 1.0.16 | stoneburner | i386, amd64, armel, armhf

    omv 5.6.6 usul | 64 bit | 5.11 proxmox kernel | omvextrasorg 5.6.1
    omv-extras.org plugins source code and issue tracker - github


    Please read this before posting a question.
    Please don't PM for support... Too many PMs!

  • If someone wants to move it, they have to specify the location in extra options and move the files manually.




    And how can i specify it in the extra options. I didn't know the command e.g.




    Thx

    Cooler Master Elite 110
    ASRock Q1900-ITX
    GeIL Green SO-DIMM 2x2GB, DDR3L-1333
    3x Western Digital WD green 3TB
    1x 60GB BOOT-SSD
    be quiet! System Power 7 300W

  • And how can i specify it in the extra options. I didn't know the command e.g.


    datadir = /media/long_uuid/mysql-data


    You do realize that you have to move the files manually, right?

    omv 5.6.6 usul | 64 bit | 5.11 proxmox kernel | omvextrasorg 5.6.1
    omv-extras.org plugins source code and issue tracker - github


    Please read this before posting a question.
    Please don't PM for support... Too many PMs!

Participate now!

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