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:
    253
    Likes Received:
    2
    Trophy Points:
    168
    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,277
    Likes Received:
    8
    Trophy Points:
    313
    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:
    318
    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:
    253
    Likes Received:
    2
    Trophy Points:
    168
    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:
    253
    Likes Received:
    2
    Trophy Points:
    168
    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:
    318
    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:
    253
    Likes Received:
    2
    Trophy Points:
    168
    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:
    156
    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. mdvaldosta

    Mysql.service changed on disk

    mdvaldosta, Feb 27, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    681
    mdvaldosta
    Feb 28, 2017
  2. mahdy_sharifi

    change mysql default charset

    mahdy_sharifi, Jan 31, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    500
    cPanelMichael
    Feb 8, 2017
  3. Derek Lee

    How change MySQL strict mode to null mode

    Derek Lee, Sep 29, 2016, in forum: E-mail Discussions
    Replies:
    3
    Views:
    733
    cPanelMichael
    Oct 6, 2016
  4. rasa

    Remote MySQL server IP change issue

    rasa, Jul 31, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    680
    cPanelMichael
    Aug 1, 2016
  5. zye

    Change open files limit mysql

    zye, May 15, 2016, in forum: Database Discussions
    Replies:
    21
    Views:
    4,910
    Jaison V John
    Feb 14, 2017

Share This Page