MAJOR HELP NEEEDED Database Error

[SL No. 1]

I want to know why I keep seeing when i load my forum i.e. only the index.php page there is a database error occurring sometimes, sometimes no page can be displayed and sometimes it works. I get an error to my email sayin fail to connect mysql error = 0 and this has just started happening recently and my server people say that the server is all functional and I have made no changes at all to my files.

Can somebody please help

[Steve Machol]

This error means that either:

1) The db info in your config.php file is wrong (in which case your forums won't work at all.)

2) That user doesn't have permission to access the database listed in config.php.

3) The database doesn't exist.

4) MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit - either on the server level or user level.) If you are sure your config.php info is correct, then you will need to contact your host about this.

Note, many servers are being probed for the phpBB worm these days and the MySQL server is being overloaded. This could account for these errors.

[SL No. 1]

Yeah the db info is all correct. How would i move servers, just ftp the files to the new server and then the db files to be put back into the new database and then change the config.php? thats all? cos its doesnt work it says db error

[Steve Machol]

Instructions for moving servers are in the online manual here:

http://www.vbulletin.com/docs/html/moving_servers

Note: The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.

[SL No. 1]

I have read thos but not helpful enough

[Steve Machol]

Hmmm...those are the best docs I can point to.

[SL No. 1]

only our new servers have ssh

[Steve Machol]

How big is your database? You could ask your host to make a backup for you.

[SL No. 1]

70mb and we have a copy of it now but i stil need you to explain how to get the thing to load cos i have ftped the files and also restored the database but nothing

[SL No. 1]

????

[Dennis Olson]

MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit - either on the server level or user level.)

[SL No. 1]

70mb and we have a copy of it now but i stil need you to explain how to get the thing to load cos i have ftped the files and also restored the database but nothing

what else do i need to do staff?

[Dennis Olson]

So are you getting the error 100% of the time now? Or just on-again off-again?

[Steve Machol]

The answers are in posts #2 and #4. I'm not sure what else we can do. What's the latest info?

[SL No. 1]

80%