Location of my.cnf for MySQL so I can change the datapath

Discussion in 'Solaris, Nexenta, OpenIndiana, and napp-it' started by Gremlin190, Dec 27, 2018.

  1. Gremlin190

    Gremlin190 New Member

    Joined:
    Dec 14, 2018
    Messages:
    4
    Likes Received:
    0
    Hello, I am using the command wget -O - www.napp-it.org/amp | perl to install MySQL and need to know the location of my.cnf so I can change the path of my database to my ZFS pool instaed of my rpool. I tried adding my.cnf to /etc, /etc/mysql, and /opt/etc/mysql, but it still will not move. I also edited the service using svccfg -s mysql and changing the method_context/working_directory to my pools path. Everytime I rename the original directory ad restart the service, I get stuck in maintenance mode. I copied the path like rsync -av /var/lib/mysql /mnt/volume-nyc1-01 TIA
     
    #1
  2. gea

    gea Well-Known Member

    Joined:
    Dec 31, 2010
    Messages:
    2,043
    Likes Received:
    654
    All applications that use pkgin (like the amp installer) are using /opt as destination to be independent from normal OS settings.

    Check /opt/local
     
    #2
Similar Threads: Location mycnf
Forum Title Date
Solaris, Nexenta, OpenIndiana, and napp-it Backup to a network location? Nov 5, 2018
Solaris, Nexenta, OpenIndiana, and napp-it Ram allocation for Napp It setup Jun 3, 2016

Share This Page