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

XF 1.3 vb4 import to xenforo 1.3.1

Discussion in 'Installation, Upgrade, and Import Support' started by AvCrash, Apr 30, 2014.

  1. AvCrash

    AvCrash Member

    Hi dear support!
    I have a question/problem
    I have a VB4 forum with over 134000 threads, over 1900000 posts and over 19000 users
    DB size around 1,7GB
    Attachments size around 43GB

    I tried to import all this into Xenforo 1.3.1 with local import functions
    I'm tired to wait when it end

    For example new server for xenforo:
    2 Intel Xeon E5506 @ 2.13GHz 2cores
    4Gb RAM
    RAID5 (4hdd)
    Gentoo core 3.13.6-hardened-r3 SMP x86_64

    Import of Threads & Messages: I wait about 28 hours !!!
    Import of Attachments: About 8 hours i wait (okay, here is about 43GB and i can understand it)
    Import of other sections (at all): about 8 hours

    But why import took 28 hours to import threads and messages??!
    What i need to optimize to make it more and more faster?

  2. Mike

    Mike XenForo Developer Staff Member

    The main optimizations revolve around optimizing InnoDB and your I/O settings on your server. (On a side note, 4GB is really not much RAM in a server like that.)

    Alternatively, you can look at the third-party big board importer though it requires more technical knowledge.
  3. AvCrash

    AvCrash Member

    Thanks for answer.
    What I/O settings for server you can recommend??
    But this script costs about 150USD! I think that XenForo developers need to think about integrate this Big Board Importer to the XenForo core !
  4. Mike

    Mike XenForo Developer Staff Member

  5. AvCrash

    AvCrash Member

    When tried to import attachments from vb4 to xenforo at 40% i got this:
    My vb4 DB in latin1. May be need to change import settings?
  6. Mike

    Mike XenForo Developer Staff Member

    Your previous message implied that you ran the attachments step successfully before. Is that not the case?

    An error like that means that there is conflicting data already in the DB and you chose to retain IDs. It's hard to suggest exactly why that specific one would have failed -- it presumably got imported twice. You could try deleting the 253205 record from xf_attachment (and xf_attachment_data).
    AvCrash likes this.

Share This Page