It doesn’t look I have asked this previously, what version of MyBB are you importing from? I linked this post from our Import Troubleshooting docs so when I get the time we can expand that section (or a dedicated section) on tweaking ‘all the things’. Thanks for listing those tweaks you made, they make sense, we already bump the PHP timeout and up the memory limit to 256M but that is all we can really do safely before we cause grief in shared hosting environments. Sorry for the delay, life has been getting in the way. Is it possible to do an SQL checksum to check the expected output? It could be that myBB adds subjects and replies to messages, but the difference is a bit too big. That can be explained because of the first issue. The converted forum contains 109k subjects. The original myBB forum contained 1mlj messages and 36k discussions. The copies do not contain any topics or replies, so it is easy to remove them. Is it possible to correct this with an SQL? Is there another workaround? Correcting them one by one is not my preference ? The conversion leaves the spaces in the login name. The Repair Forums option ‘Recalculate the position of each reply’ does not work. An option in the Topics interface to combine these, would be ace ? Is it possible to correct this with a query? My SQL skills are too limited unfortunately. The ‘Recalculate the parent topic for each post’ does not fix this. Not quite sure about some things and have some questions. I did a lot of random checks and the outcome seems ok-ish. Most likely it is possible to squeeze out more performance. During the conversion my memory was around 50% and CPU was very low. I ran the conversion with the following settings: Rows Limit 10,000 and Delay Time 0. It took me a while to find all the necessary settings.Ĭopy /applications/mamp/library/support-files/my-huge.cnf and rename to /Applications/MAMP/conf/my.cnfĬhange in my.cnf setting max_allowed_packet = 1000MĬhange in /Applications/MAMP/bin/php/php5.5.10/conf/php.ini settingsĪdd or change in Applications/MAMP/bin/phpMyAdmin/ setting $cfg = 0 The conversion ran for roughly 48 hours on a MacBook Air with i7, 8Gb memory and a 500Gb Solid State drive under MAMP.įor people who want to do such a big conversion, I also had to tweak a lot of the PHP ini files to import such a big query and get maximum throughput. It contained 1 million messages, close to 40k topics and a 400 members. The MyBB SQL of the database was 435,9 Mb big. Hi Stephen / was finally able to run a complete conversion without any restarts. I get the feeling this is some kind of MAMP issue because I got it to run on my VPN.Īny help / suggestions are more than welcome. Could be there, but I am not too familiar on linking php code files. I’ve checked the code but could not find any error handling. Whatever I do, even leave blank fields to get some kind of error message, I still get the same result. Localhost port, userid/pass on database, prefix etc etc. I have tried every scenario I could think of that could go wrong. No error messages, just that there is nothing to convert. Whatever I do I keep getting the same messages. I was one happy muppet and kicked of the conversion. Ages…Īfter some trial and error I was able to make a complete dump of the MyBB as SQL and imported it on my Mac’s MAMP. Tried to do it directly on my VPS, but it took way too long. I am trying to migrate a very big MyBB forum to bbPres (1,7 mlj posts and 63k discussions). Used to code 20 years ago, so I can read a lot of the syntax, but am quite new to the javascript, php etc.
0 Comments
Leave a Reply. |