DB Backup Question

[Grandmaster]

My board has a little under 900 members. 30000 posts. My database has a size of 100 megs, is that average for it being that big?

When the database is starting to download, it crashs "BIND" on the server. Why would the database inflate so much?

Server info:
OS: Linux
Kernel version: 2.4.5
Apache version: 1.3.20 (Unix)
PERL version: 5.006001
MySQL version: 3.23.45

[Grandmaster]

Also, the template colors in the admin cp, have all disappeared. They only show as black, no green or red.

Do you guys think vbstats has anything to do with it?

[steven]

how are you dumping the database via SSH, or phpmyadmin, and you downloading the dump with an FTP client?

[Steve Machol]

For the colors in the Admin CP, make sure you still have the file cp.css in the forums directory. It sounds like it's missing.

As for the database size, I have almost 1500 members and 31,000 posts and my DB is aroung 70 MB. The two things that will really inflatre the size of the DB are the searchindex (particularly if you have set to to index 2-3 character words) and file attachments.

[Grandmaster]

Steve, the cp.css is already on my ftp.

[Grandmaster]

and steven, im getting the mysql data from the VB backup

[steven]

Grandmaster-
It appears to me that you are asking 2 questions.

1) Should my DB be that big with the amount of members and posts?

2) Why is bind crashing when I download the backup file?

Answer to #1 is what the other Steve (couldn't he have a different first name) had replied. It really depends on your search index and attachments tables.

Answer to #2 is do you have access to SSH on the server, if you do try to do a dump using the mysqldump command and see how bind reacts. Generally speaking, the mysqldump command is a lot faster than VB's backup capability.

HTH
Steven

[Grandmaster]

Steven, I think that is what i am going to have to do to download the database. Good call.