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

How to clean mysql tables before second Import with unique ids

Discussion in 'Installation, Upgrade, and Import Support' started by Kerby, Dec 20, 2012.

  1. Kerby

    Kerby Active Member

    Need help until tomorrow :)

    I will move my community from phpBB to xenforo. I developped my custom xenforo/style since Summer on my xenforo testinstallation. For a efficient fast move, I will just move xenforo testinstallation folder to domain root folder, where actually phpBB is. So I have to import actual phpBB Data.

    But I have already imported once half year ago my phpBB Data (already 1.1.3 xenforo) in my testinstallation. But I cant import twice to have unique same ids for threads, members, posts for SEO reasons in redirection rules of htaccess. And i dont want to redo my custom changes manually in a new Installation.

    How can I wipe the existing Import Data to be able to do a second import and still use my custom testinstallation for the move release for my community?
  2. CyclingTribe

    CyclingTribe Well-Known Member

    AFAIK this cannot be done; you'll need to do a fresh install of XF and import your style and re-apply any settings/file changes/add-ons you've installed on your test version. (y)
    Kerby and Jake Bunce like this.
  3. SchmitzIT

    SchmitzIT Well-Known Member

    It should be doable using a manual script. Alternatively, we secure your style and its files, and re-initiate the database. I sent you a skype request as per your PC.
    Kerby and Jake Bunce like this.
  4. Sadik B

    Sadik B Well-Known Member

    Export the style, Reinstall Xenforo, import style in new installation, import PHPBB.
    Kerby, Jake Bunce and Brandon Sheley like this.
  5. Brandon Sheley

    Brandon Sheley Well-Known Member

    This ^ is the only best answer
    Sadik B and Kerby like this.
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    You should import into a new installation of XF. Use your test forum as a point of reference in manually applying any custom development to the final import, as opposed to building onto your test forum and taking it live. There is no easy way to deal with the duplicate content if you import again into the same forum.

    With that said, it has been done:


    But it's a dirty thing to do and may cause problems later.
    Kerby and Brandon Sheley like this.
  7. Kerby

    Kerby Active Member

    Thank you very much guys. I will do the clean way like recommended:
    1. export style & language
    2. second installation
    3. import style & language
    4. import phpBB
    5. install all addon's
    6. apply options/permissions of xenforo/addon's, apply custom icon's and custom codesnippets by reference of testinstallation

Share This Page