1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backing up database after vB4 migration

Discussion in 'XenForo Questions and Support' started by mistypants, Sep 21, 2012.

  1. mistypants

    mistypants Well-Known Member

    I had a question regarding backing up my database. I upgraded from vBulletin 4 and that all went well. Before moving to Xenforo, my vBulletin database was averaging about 1GB in size, and I would backup usually from phpmyadmin. When I tried recently to backup the Xenforo database, it was around 15MB. This size discrepancy was so big that I wasn't sure it could be attributed to just vBulletin bloat.

    So, my question is, are posts etc still stored in the old database that was being used for vBulletin, and should I continue to back that one up? Or is Xenforo really that marvelous that the database is only 15MB?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The import does not explain the difference in size. Do you have a lot of post attachments? XF stores post attachments in the file system, not in the database. If your forum is mostly attachments then that might explain the difference in db size.
  3. mistypants

    mistypants Well-Known Member

    I don't think we had a notable number of attachments, no. I mean there were certainly a decent amount but it wasn't a widely used feature on our boards, most people opted to use image hosting services because of vB's poor attachment system. Although, many users did use uploaded avatars.

    If it's any help in figuring out the database size, our stats are:
  4. Walter

    Walter Well-Known Member

    15MB is way to less for a forum with 3.5 million messages.

    Wh not simply look at your config file and see what database you are using? You can find the file at e.g.
    /home/yourhostingusername/public_html/forum/library/config.php if you have installed Xenforo in the forum directory

    and $config['db']['dbname'] tells you the name of the database you are using.

Share This Page