Hello All, I have forum site. Name redchillyz. com i'm using vbulletin 4.0.8 Only few member are still joined (115). But my database size seems 560 MB. Is there any chance to be have this much mb i doubt that is there any virus ? (Actually i have small knowledge in database) Thanks.
@Nerv is right.. btw,If you compress the db in zip or gzip while backing up, you could see about 10x reduced space.
Following are the stats of your forum: Threads: 70,535 Posts: 70,541 Members: 116 Code (markup): Thread / Post ratio is very less and most of threads are about torrents having long content in it. However, chances of having 560MB database with the amount of posts you have are very less. Are you sure you checked database size only? How did you arrive at 560MB?
You can then try checking which table is using most of the space. Do it via phpMyAdmin and you can know the table having highest data size. May be there would be more than one tables. If tables are temporary tables, then may be you can truncate them or delete old data.
You can read some more details about searchcore_text table at this link. Mainly, you may have to alter table structure but I would advice you to have word with vBulletin support for this and get a solution from them.