MySQL Error on new server

jdarow

Well-Known Member
PartnerNOC
May 30, 2003
88
1
156
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:
 

NetX

Well-Known Member
Jun 18, 2003
177
0
166
Have you checked mysql is running on your new server?

cPanel.net Support Ticket Number:
 

NetX

Well-Known Member
Jun 18, 2003
177
0
166
Sometimes mysql is not properly started, try making a graceful reboot of your server.

cPanel.net Support Ticket Number:
 

pguy

Well-Known Member
Feb 21, 2003
73
0
156
Same problem here. Any leads folks ? mySQL is running fine. But its a brand new server with phpsuexec installed.

cPanel.net Support Ticket Number:
 

pagedeveloping

Well-Known Member
Jun 11, 2003
219
0
166
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: