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.

Changes or removing my.cnf has no effect??

Discussion in 'General Discussion' started by Freezer, Apr 30, 2007.

  1. Freezer

    Freezer Well-Known Member

    Joined:
    Jun 13, 2005
    Messages:
    120
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Den Haag
    Hi,

    i have got a strange problem. On one of my servers, i can't configure mysql anymore, it just runs with default settings. Making changes in /etc/my.cnf does'nt do anything, even deleting has no effect. When i start mysql is see this:

    Attempting to restart mysql
    Waiting for mysql to restart.... . . . . . . . . . . finished.

    mysql statusroot 2966 0.0 0.0 3188 1040 ? S 17:11 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/neo.website.net.pid
    mysql 2987 0.7 0.3 117692 13836 ? S 17:11 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/neo.website.net.pid --skip-external-locking


    mysql started ok

    Any suggestions??
     
  2. mastermute

    mastermute Registered

    Joined:
    May 29, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem, my /var device is underdimesioned and i need to move the datadir, where can I edit this?
     
  3. Freezer

    Freezer Well-Known Member

    Joined:
    Jun 13, 2005
    Messages:
    120
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Den Haag
    I solved it by moving my my.cnf file to the data dir. Also you can edit the startup script of mysql to change the datadir.
     
  4. mastermute

    mastermute Registered

    Joined:
    May 29, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    The problem is i can't find the startupscript.. restartsrv_myql doesn't have an directories in it...:(
     
  5. Freezer

    Freezer Well-Known Member

    Joined:
    Jun 13, 2005
    Messages:
    120
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Den Haag
    /etc/rc.d/init.d/mysql

    That is the startup script, open it with your favorite editor (back it up first before you change something)
     
Loading...

Share This Page