1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.
  2. Better Analytics for WordPress Get It Free

Sql database size?!

Discussion in 'Databases' started by milad_ran, Jan 5, 2010.

  1. #1
    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?
     
    milad_ran, Jan 5, 2010 IP
  2. chandan123

    chandan123 Prominent Member

    Messages:
    11,597
    Likes Received:
    576
    Best Answers:
    0
    Trophy Points:
    310
    #2
    take backup in .gz or in .zip format that normally reduces around 80% and thats will be ok i guess
     
    chandan123, Jan 5, 2010 IP
  3. milad_ran

    milad_ran Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    i'd like to know the normal DB size of such forum....
    cause i think there's problem with my DB, its too big!!!
     
    milad_ran, Jan 5, 2010 IP
  4. milad_ran

    milad_ran Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    anybody there???
     
    milad_ran, Jan 6, 2010 IP
  5. crivion

    crivion Well-Known Member

    Messages:
    1,668
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    160
    Digital Goods:
    3
    #5
    that size its ok!
     
    crivion, Jan 7, 2010 IP
  6. webizpro

    webizpro Guest

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    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
     
    webizpro, Jan 7, 2010 IP
  7. mUjA

    mUjA Member

    Messages:
    84
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    38
    Digital Goods:
    1
    #7
    very huge database for a forum size...
     
    mUjA, Jan 9, 2010 IP
  8. ayushdeepsingh

    ayushdeepsingh Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    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
     
    ayushdeepsingh, Jan 12, 2010 IP
  9. GSP

    GSP Greenhorn

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #9
    GSP, Jan 12, 2010 IP
  10. milad_ran

    milad_ran Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    thanks for your replies....
     
    milad_ran, Jan 29, 2010 IP
  11. nice12

    nice12 Peon

    Messages:
    37
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Check your database. Looks like you have more than your forum in it.
     
    nice12, Jan 29, 2010 IP
  12. 2and1

    2and1 Active Member

    Messages:
    140
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #12
    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.
     
    2and1, Jan 29, 2010 IP
  13. scylla

    scylla Well-Known Member

    Messages:
    1,007
    Likes Received:
    31
    Best Answers:
    1
    Trophy Points:
    175
    #13
    How do you move them like you described from database to file?
     
    scylla, Jan 30, 2010 IP
  14. milad_ran

    milad_ran Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14
    yes, how you reduced your DB size??
    my DB is going big & bigger everyday....
     
    milad_ran, Feb 3, 2010 IP
  15. forump

    forump Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #15
    why do you want to reduce it?
     
    forump, Feb 3, 2010 IP
  16. milad_ran

    milad_ran Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #16
    its hard to backup and its going bigger, i think it would be more than 2-3 GB soon...
     
    milad_ran, Feb 3, 2010 IP
  17. scylla

    scylla Well-Known Member

    Messages:
    1,007
    Likes Received:
    31
    Best Answers:
    1
    Trophy Points:
    175
    #17
    mysqldumper, nuff said. and you wont even have to download the backup unless you want to and it can restore database as well.
     
    Last edited: Feb 5, 2010
    scylla, Feb 5, 2010 IP
  18. vntutor

    vntutor Banned

    Messages:
    1,722
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #18
    export to SQL to have a backup copy
     
    vntutor, Feb 6, 2010 IP
  19. 2and1

    2and1 Active Member

    Messages:
    140
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #19
    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)
     
    2and1, Feb 8, 2010 IP
  20. hemans70

    hemans70 Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #20
    compress the file??? or just be patient
     
    hemans70, Feb 9, 2010 IP