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 Error on new server

Discussion in 'General Discussion' started by jdarow, Jun 28, 2003.

  1. jdarow

    jdarow Well-Known Member
    PartnerNOC

    Joined:
    May 30, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Michigan, US
    cPanel Access Level:
    DataCenter Provider
    After transferring accounts to new server, a lot of people are getting the following error, can anyone tell me why?

    Warning: main(db/mysql.php) [function.main]: failed to create stream: No such file or directory in /home/username/public_html/db/db.php on line 53

    Warning: main() [function.main]: Failed opening 'db/mysql.php' for inclusion (include_path='/usr/local/lib/php:/usr/lib/php') in /home/username/public_html/db/db.php on line 53

    Fatal error: Cannot instantiate non-existent class: sql_db in /home/username/public_html/db/db.php on line 86

    cPanel.net Support Ticket Number:
     
  2. NetX

    NetX Well-Known Member

    Joined:
    Jun 18, 2003
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    Have you checked mysql is running on your new server?

    cPanel.net Support Ticket Number:
     
  3. NetX

    NetX Well-Known Member

    Joined:
    Jun 18, 2003
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    Sometimes mysql is not properly started, try making a graceful reboot of your server.

    cPanel.net Support Ticket Number:
     
  4. pguy

    pguy Well-Known Member

    Joined:
    Feb 21, 2003
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Same problem here. Any leads folks ? mySQL is running fine. But its a brand new server with phpsuexec installed.

    cPanel.net Support Ticket Number:
     
  5. pagedeveloping

    pagedeveloping Well-Known Member

    Joined:
    Jun 11, 2003
    Messages:
    219
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    New York
    Here is what I did!

    I found this some where around here and saved it incase this problem ever came up again. This could help you too!

    Do the following:

    login via ssh

    run the commands as follows:

    killall mysqld
    safe_mysqld --skip-grant-tables &
    /usr/local/cpanel/startup

    Then login into WHM reset the MySQL root
    password.

    go back to ssh...

    killall mysqld
    /etc/rc.d/init.d/mysql start

    Thats it! and MySQL was back up and running...

    hope this helps,

    Pete

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page