XF 2.2 MyBB Migration to XF 2.2

[Dragonfruit]

Hi I'm currently importing through the CLI method, it's taken 30 minutes to process 74 private messages on Step 4 of 10. There's over 1.2 million. Steps 1 to 3 wasn't as bad as this. Is there anything that can be done to speed things up?

 

[Dragonfruit]

I set up XAMPP so I can use my own PC with a lot more memory.
After adjusting these MySQL configs:

innodb_buffer_pool_size        = 12G
innodb_buffer_pool_instances   = 4
innodb_flush_method            = O_DIRECT
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1
innodb_log_files_in_group      = 2
innodb_log_file_size           = 512M

It sped up, but it's still rather slow. It's completing 0.20% per hour on Stage 4 of 10, the PMs. Is there anything more I can do to help this along?

 

[Dragonfruit]

I've got past it by migrating it to XF 1.5 instead. Seems like the MyBB importer for XF 2.x is problematic for large databases.

 

[Paul B]

Report it here and the developers may be able to investigate and make changes: https://xenforo.com/community/forums/importer-bugs/

How large is the DB in terms of MB?
They may need a copy of it to do some testing.

 

[Dragonfruit]

The total size is about 2.3gb
The PM table is next being the largest table aside from the posts with somewhere between 1.2-1.3 mil rows. Can this thread just be moved there? Or do I need to make it again?