The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Migrate to mariadb with databases in /home

Discussion in 'Database Discussions' started by benito, Nov 17, 2016.

Tags:
  1. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    300
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Mar del Plata - Argentina
    Hello!

    It is safe migrate to mariadb if i move all the databases to /home in mysql?

    Thanks
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,958
    Likes Received:
    1,274
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you verify the steps you took to move your databases to the /home partition?

    Thank you.
     
  3. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    300
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Mar del Plata - Argentina
    Yes its simple, just move and symbolic link. I followed this steps.

    /etc/init.d/mysql stop
    mkdir /home/var_mysql
    mv /var/lib/mysql /home/var_mysql
    chown -R mysql:mysql /home/var_mysql/mysql
    ln -s /home/var_mysql/mysql /var/lib/mysql
    /etc/init.d/mysql start
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,958
    Likes Received:
    1,274
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    The upgrade should work, but I strongly recommend backing up your databases beforehand because this is an unsupported configuration. You should consider reverting this change if you have the available disk space, and then moving it back into place once the upgrade finishes.

    Thank you.
     
    benito likes this.
  5. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    300
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Mar del Plata - Argentina
    Thanks Michael
     
Loading...

Share This Page