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.

MySql

Discussion in 'General Discussion' started by B12Org, Aug 25, 2003.

  1. B12Org

    B12Org Well-Known Member

    Joined:
    Jul 15, 2003
    Messages:
    692
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle Washington
    cPanel Access Level:
    Root Administrator
    I get this when I restart mysql. I am using mysql 4 and it is all up to date, and it still works and fuctions and stuff, but I get this error everytime. Can some one please tell me what this means and how to fix it?

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

    mysql status root 21797 0.2 0.2 2096 1044 ? S 13:22 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server1.b12.org.pid



    mysql started ok Aug 24 15:32:39 server1 mysql: Killing mysqld with pid 15149 Aug 24 15:32:40 server1 mysql: Wait for mysqld to exit\c Aug 24 15:32:41 server1 mysql: done Aug 24 15:32:41 server1 rc: Stopping mysql: succeeded

    cPanel.net Support Ticket Number:
     
  2. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    This line is fine:

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

    mysql status root 21797 0.2 0.2 2096 1044 ? S 13:22 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server1.b12.org.pid

    However the remaining lines aren't. This could be caused by persistent connections to MySQL. You may want to kill off connections or limit them to a certain amount of time. If you restart mysql via the command line, do you get the same result as in WHM?

    service mysql stop
    service mysql start

    cPanel.net Support Ticket Number:
     
  3. B12Org

    B12Org Well-Known Member

    Joined:
    Jul 15, 2003
    Messages:
    692
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle Washington
    cPanel Access Level:
    Root Administrator
    Yes, if I use the script to restart mysql In command line or whm I get the same thing. It all happened after I restored dabases from another disk that had run on another server (with the same name, a backed up tar of all databases on the server), and then we had to switch hard disks because of a failure of the disk, and then just made a tar of the old stuff, and copied it to the new place. I did not overwrite any files. I have tried it with overwriting before and get the same result as well.

    cPanel.net Support Ticket Number:
     
  4. hostcp3

    hostcp3 Well-Known Member

    Joined:
    Jun 18, 2002
    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    16
    We had this problem also on one server,

    Killing it from the command line

    service mysql stop

    and then restart from WHM seems to give all clear.

    cPanel.net Support Ticket Number:
     
  5. rix

    rix Well-Known Member

    Joined:
    May 1, 2003
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    if still dosent work, try checking your error logfile in /var/lib/mysql/<host>.err after restarting it. you might find some infos why its not running

    cPanel.net Support Ticket Number:
     
  6. B12Org

    B12Org Well-Known Member

    Joined:
    Jul 15, 2003
    Messages:
    692
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle Washington
    cPanel Access Level:
    Root Administrator
    I tried the command line and then the whm and that did not do anything new.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page