Update! The wp-posts table isn’t getting any larger, so my guess is that the conversion is unable to proceed and that the hyphens are the result of an error.
Done!
I can also report that switching the databases to a ramdisk is quite easy and has sped things up quite a bit. Though my earlier report was a little optimistic — it was going to take a couple of weeks. With the ramdisk, though, it really does seem to be headed for a few days work.
Overnight, it got to 30,000 of 500k rows, but then it started showing hyphens instead of “Converting replies” in the reporting windows, Like so:
------------------------------------------------------------------------
------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
----------------------------------------------
Converting replies (26750 - 26999)
Converting replies (26500 - 26749)
Converting replies (26250 - 26499)
Converting replies (26000 - 26249)
Converting replies (25750 - 25999)
The hyphens are added a a rate of one per delay time, by the looks of it, at the top.
A peek at the database has it at _bpp_converter_step 10 still, and _bpp_converter_start at 27000
Has the conversion croaked or is this part of the process? Should I manually increment _bpp_converter_start a little and restart the convertion? (I had to do that a couple of times as it was converting topic titles)
Disabling plugins (other than bbpress) prevents those notices from appearing. Doesn’t seem to have an effect on the speed of the operation, alas.
One thought: the notification window on the import is filling up with warnings like this, presumably one for every processed row.
Notice: Trying to get property of non-object in /Library/WebServer/Documents/eq/wp-includes/post-template.php on line 29
Notice: Trying to get property of non-object in /Library/WebServer/Documents/eq/wp-content/plugins/easy-add-thumbnail/easy-add-thumbnail.php on line 37
Notice: Trying to get property of non-object in /Library/WebServer/Documents/eq/wp-content/plugins/easy-add-thumbnail/easy-add-thumbnail.php on line 42
Notice: Trying to get property of non-object in /Library/WebServer/Documents/eq/wp-includes/post-template.php on line 29
Could these be slowing it down?
Everything’s on an SSD.
If you’d like to experiment on a large PHPFox import, you’re more than welcome to this 800MB SQL dump of one 🙂
The desktop is an i7 mac, with 32GB of RAM. So should be up to the job generally.
