Need Help Please
 

I run a gaming community, been using VB for 2 years.

The guy who was managing my Database tells me that the database is s**t and has errors in the code. The site runs, but i do get 505 errors more then i would expect and the site is slow.

Can someone please help me:
1.) identify the error
2.) direct me how to get on the road to fixing it?

I literally have no clue.


He says if I run database backup and error will show. but all i get is this when i run it

http://img16.imageshack.us/img16/868...cessingqe6.jpg

no errors there i can see.

read here about 505
http://www.checkupdown.com/status/E505.html

so the guy just doesnt know what he is talking about? is it normal just for that screen to sit in the proccessing stage for an hour?

you never said it hangs there for a hour?.. that is a different thing

do you get any emails from the mysql server about errors?.

no.. how do i set that up?

--------------- Added [DATE]1233783299[/DATE] at [TIME]1233783299[/TIME] ---------------

i get no errors, it just hangs up on that screen

You should not use the AdminCP backup function.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. 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. 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

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php