A follow-up in case anyone comes across this thread. I managed to import my vbulletin 5 database. I stopped using docker on a macOS and I switched to my windows desktop. I installed XAMPP and restored my vbulletin database there. Then I started a new xenforo install and used the 1.5.0 importer...
I retried with a clean database, latest versions and storage pointing to a folder outside of docker but no luck. After 2 hours the import finished 8000PM's. Which should be done in matter of minutes (seconds). I'm going to try native although I wish I hadn't. Running it in docker is so much easier.
Actually, it might be a different issue.
There's only 63649 records in my xf_post table while there are 323150 rows in my (vbulletin) text table. The importer claims to be on 361001?
Thanks for replying. I'm trying to find out what a config for a write intensive mysql should be. I'm currently testing with adding the following to the mysql images and that seems to speed it up somewhat:
command: --innodb_buffer_pool_size=8096M --innodb_read_io_threads=8
AFAIK this is a standard config. To add to this. I've tried to optimize 2 tables from vbulletin (text and node) but that doesn't impact performance. I'll optimize all the tables and try again.
Hi all,
I'm running an import with importer 1.4.1 in a docker container setup to migrate a vBulletin forum. The vBulletin SQL dump is around 900MB to give an indication of the size. I have the following setup to migrate:
version: '2'
services:
php:
image: xfrocks/xenforo:php-apache...