MyBB Community Forums

IP Conversion

Converting post IPs...
Converting ip 135000 to 139999 (1130117 Total)
Done. Click Next to continue the IP conversion.

That part takes a very long time. For each 5,000 it takes about 3 minutes. That's over eleven hours of just updating post IPs.  

Anyone have any tips to make this part work a bit faster? 

this might help!
or may be its better to do upgrade on localhost using your own computer (eg. XAMPP server)

Using xampp offline localhost server with 8 gigs of ram dedicated to it

Thanks! What's the best way to stop the upgrade process so I can run that sql query? Or should I just start over?

^ you have to abort the current process and start over (with the earlier version's database)

Aye. Alrighty! That'd take about 4 hours. Much better then the 15+ hours with post ip conversion

https://gist.github.com/Zalvie/cdef0eba26a62d2a10b0
pip install MySQLdb
Edit line 67
python convert.py

Edit: Btw, was able to convert 8m posts, 300k users and oh god so many other tables in about 3 min with that which is why I made in the first place.