![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |