Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Moving mysql databases

Discussion in 'General Discussion' started by JamesSmith, Oct 21, 2003.

  1. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    UK, Luton
    Hi,

    Currently I believe the mysql databases are in the /var partition. This is almost out of space. Would like to move existing and any to be created databases to /usr/mysql or /usr/home/mysql for example.

    Has anyone attempted this, or if anyone has some instructions on doing this, would be great.

    Server info: WHM 8.4.0 cPanel 8.5.3-S6 FreeBSD 4.8-RELEASE
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 JamesSmith, Oct 21, 2003
  2. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    166
    #2 RandyO, Oct 22, 2003
  3. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    UK, Luton
    hrm.

    That looks a bit simple, are you sure that is 100% how it should be done?

    Just wondering how cpanel knows its been changed ..

    And is mysql stopped before doing any of it?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 JamesSmith, Oct 22, 2003
  4. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    166
    Hmm I will see about making it more complicated :D As it is a simple redirect I don't know that mysql needs stopped except to maybe copy the current db's
     
    #4 RandyO, Oct 22, 2003
    Last edited: Oct 22, 2003
  5. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    UK, Luton
    For others to know in the future, I e-mailed cPanel support, who suggested:

    /usr/local/etc/rc.d/mysql-server.sh stop ; mv /var/db/mysql /usr/home ; ln -s /usr/home/mysql /var/db/mysql ; /usr/local/etc/rc.d/mysql-server.sh start

    It worked :)

    Thanks goes to Michael Photakis, cPanel Support Staff.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 JamesSmith, Oct 22, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Moving mysql databases
  1. Bidi

    Moving MySQL directory

    Bidi, Aug 19, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    824
    cPanelMichael
    Aug 22, 2017
  2. chris0147

    New Thread Apache rebuild problem after removing main domain

    chris0147, Oct 18, 2018 at 5:21 PM, in forum: EasyApache
    Replies:
    7
    Views:
    75
    Infopro
    Oct 18, 2018 at 6:48 PM
  3. bdp31770

    Removing and Re-adding Domain and MX Records

    bdp31770, Oct 12, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    55
    cPanelLauren
    Oct 16, 2018 at 9:21 AM
  4. osamaweb

    Removing autossl rules on htaccess

    osamaweb, Sep 30, 2018, in forum: Security
    Replies:
    3
    Views:
    114
    cPanelLauren
    Oct 5, 2018
  5. dstana

    Moving Domain for an Account Issue

    dstana, Sep 27, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    6
    Views:
    120
    cPanelLauren
    Oct 11, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice