Need Help Please

[JPforFree]

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/8681/proccessingqe6.jpg

[WEBDosser]

no errors there i can see.

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

[JPforFree]

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?

[WEBDosser]

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?.

[JPforFree]

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 1233783299 at 1233783299 ---------------

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

[Marco van Herwaarden]

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/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_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/showthread.php?t=134821&highlight=mysqlhotcopy

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