hi i have a vBulletin forum with this statics: Threads: 88,758, Posts: 95,372, Members: 4,263 and my sql database size is 573.5 Mb !!!! and hard to backup... i think it's abnormal, i want to ask you about normal size of databases and how to reduce that?
i'd like to know the normal DB size of such forum.... cause i think there's problem with my DB, its too big!!!
The size of your database is fine, but if you're concerned about importing it, then you'll need to use bigdump. You can get it here: http://www.ozerov.de/bigdump.php
ah man 500 mb is normal for big site many site then more then it ask ur webhost provider to take backup for ur site and save backup in ur /root location thank , ayush
If it's default vBulletin settings then you probably have the avatars, signatures and attachments stored in the database plus anything else stored from any installed mods and plugins. My database used to be 1GB+ and then I moved all these things to the filesystem and backups are now about 300Mb.
mysqldumper, nuff said. and you wont even have to download the backup unless you want to and it can restore database as well.
Sorry about the delay with this guys, I forgot where the option was for this myself. Anyway you can find the option to move the items such as Signatures, Avatars and Profile Pics in your Admin CP under the Avatar group and then click User Picture Storage Type. And to move Attachments look under the Attachments group for Attachment Storage Type. Bare in mind if you have a lot it will be best to Turn off your board before doing this and also grabbing a backup before doing so is always recommended. Also mysql/dump is the easiest and best way to backup and recover a database as long as you have Shell access. Export mysqldump -udbusername -pdbpassword -h dbhost dbname > dbbackupdir/dbname_DATE.sql for example. Import mysql -udbuser -pdbpassword -h dbhost dbname < dbbackupdir/dbname_DATE.sql That's what I use anyway and it hasn't failed me yet. (you could also gzip)