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.

Change mysql database directory

Discussion in 'General Discussion' started by Kailash1, Mar 19, 2008.

  1. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    I have stored Mysql database in /var/lib/mysql location and now /var is about to reach its allocated space. Is there any way I can change the location and move the existing Mysql databases to new location?

    Thanks,

    Kailash
     
    #1 Kailash1, Mar 19, 2008
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This thread may help: http://forums.cpanel.net/showthread.php?t=71424

    That thread also links to another thread that may help.
     
    #2 cPanelDavidG, Mar 19, 2008
  3. Marty

    Marty Well-Known Member

    Joined:
    Oct 10, 2001
    Messages:
    630
    Likes Received:
    1
    Trophy Points:
    18
    cd /var/lib

    service chkservd stop

    service mysql stop

    mv mysql /home

    ln -s /home/mysql mysql

    service mysql start

    service chkservd start

    That is the way I do it. Use at your own risk. I think I have ln -s command correct.
     
    #3 Marty, Mar 19, 2008
    jugo likes this.
  4. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks David and Marty.

    And sorry for the duplicate post.

    Kailash
     
    #4 Kailash1, Mar 19, 2008
  5. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Will it create any problem taking cPnel backup (including MySQL databases) after changing the location of MySQL databases.

    Thanks,

    Kailash
     
    #5 Kailash1, Mar 20, 2008
  6. Marty

    Marty Well-Known Member

    Joined:
    Oct 10, 2001
    Messages:
    630
    Likes Received:
    1
    Trophy Points:
    18
    No, the backups will follow the symlink, so there is no problem at all.
     
    #6 Marty, Mar 20, 2008
  7. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks Marty,

    Kailash
     
    #7 Kailash1, Mar 20, 2008
  8. jugo

    jugo Active Member

    Joined:
    Nov 23, 2005
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Worked for me....

    Thanks.:D
     
    #8 jugo, Apr 3, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Change mysql database
  1. zoltan.racz

    Change title in File Manager

    zoltan.racz, Sep 26, 2016 at 10:31 AM, in forum: General Discussion
    Replies:
    4
    Views:
    32
    kernow
    Sep 27, 2016 at 11:08 AM
  2. Leon savvides

    Change Document root directory

    Leon savvides, Sep 8, 2016, in forum: General Discussion
    Replies:
    4
    Views:
    270
    cPanelMichael
    Sep 11, 2016
  3. Success1

    SVN Client deploys folder with 775 and files 664, How to change on deployment

    Success1, Sep 8, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    51
    cPanelMichael
    Sep 8, 2016
  4. nalpha120

    Change cPanel User Password Question

    nalpha120, Sep 8, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    49
    Infopro
    Sep 8, 2016
  5. Bidi

    Force Password Change WHMSonic login not working

    Bidi, Sep 5, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    56
    Infopro
    Sep 5, 2016

Share This Page