Skip to:
Content
Pages
Categories
Search
Top
Bottom

Import Troubleshooting

Codex HomeGetting StartedImporting DataImport Forums → Import Troubleshooting

Specific forum imports

Make sure you also check each forum importers codex page for specific issues relating to each forum, the list can be found here.

The import gets ‘stuck’

When importing topics or replies the import may become ‘stuck’ and the import will no longer continue importing.

These types of faults are typically due to some encoding issue in that post. Sometimes this is from an encoding conversion to UTF8 that was done at some point. Whatever it is, it’s nearly impossible to detect without setting a time limit on queries and bisecting the difference until we can narrow down the offending entry, and skip it. Because queries could naturally take a long time, and because it results in missed data, I’m not comfortable with this approach.

The workaround is to find and delete the offending topic or reply which is time consuming and tricky but the only way at this stage.

Here’s how I do debug this and find the offending topics/replies:

Tweaking MySQL

When you have very large forums to import it can take quite a long time.

@ezyridah performed a MyBB import of 1 million+ messages, close to 40k topics and a 400+ members and took ~48 hours, he has added some custom PHP & MySQL tweaks that helped speed things up a bit, you can see what settings he used here, and beware, this is pretty advanced and not for the faint hearted.

Cyrillic Usernames

If you need to import users ‘Cyrillic’ before importing install and activate @SergeyBiryukov‘s Allow Cyrillic Usernames.

Skip to toolbar