chilihead Posted June 25, 2015 Share Posted June 25, 2015 I'm thinking I want to speed up the upgrade process by converting to UTF-8mb4 first. Can someone please point me to the converter (for 3.4)? Thanks Link to comment Share on other sites More sharing options...
Vroom Posted June 25, 2015 Share Posted June 25, 2015 /admin/convertutf8 Make sure you do it on a database backup, not live site. It will lock your tables, etc. The conversion took me 4 days with 12 million posts.If your board is large use command line version, and run it behind "screen" command to be safe. So if you get disconnected it will be running in the background and you can rejoin it with screen -rs. Link to comment Share on other sites More sharing options...
chilihead Posted June 25, 2015 Author Share Posted June 25, 2015 Don't know what you mean. This is not something in my 3.4 install. I believe it is a download from IPS. Link to comment Share on other sites More sharing options...
Ahmad E. Posted June 25, 2015 Share Posted June 25, 2015 Link to comment Share on other sites More sharing options...
chilihead Posted June 25, 2015 Author Share Posted June 25, 2015 Gracias! Hmmm that one is not for mb4. Link to comment Share on other sites More sharing options...
Vroom Posted June 25, 2015 Share Posted June 25, 2015 I suppose you need to download the 4.0 software and upload it to a second folder. Change the config file to point to the database backup (important), and then go to the folder I mentioned. Link to comment Share on other sites More sharing options...
chilihead Posted June 25, 2015 Author Share Posted June 25, 2015 I was trying to make the upgrade simple lol. If the standalone converter does not exist as a download I guess I'll do it during the upgrade later on. However I'd really like to do it before as step 1 can be taken care of now. I probably won't upgrade for a month or so. Link to comment Share on other sites More sharing options...
Ahmad E. Posted June 25, 2015 Share Posted June 25, 2015 I was trying to make the upgrade simple lol. If the standalone converter does not exist as a download I guess I'll do it during the upgrade later on. However I'd really like to do it before as step 1 can be taken care of now. I probably won't upgrade for a month or so. UTF8MB4 requires MySQL 5.5 or higher, the converter only shows the utf8mb4 option if that condition is met Link to comment Share on other sites More sharing options...
chilihead Posted June 25, 2015 Author Share Posted June 25, 2015 Okay so I can download that one. My MySQL is compatible. You can confirm this is for mb4?I was going by the description on the page didn't DL yet. This tool will convert your IP.Board 3.x database to UTF8 (with a collation of utf8_unicode_ci). Link to comment Share on other sites More sharing options...
Ahmad E. Posted June 25, 2015 Share Posted June 25, 2015 Okay so I can download that one. My MySQL is compatible. You can confirm this is for mb4?I was going by the description on the page didn't DL yet. This tool will convert your IP.Board 3.x database to UTF8 (with a collation of utf8_unicode_ci). You should be able to select utf8mb4 if your server supports it. Link to comment Share on other sites More sharing options...
TSP Posted June 25, 2015 Share Posted June 25, 2015 Okay so I can download that one. My MySQL is compatible. You can confirm this is for mb4?I was going by the description on the page didn't DL yet. This tool will convert your IP.Board 3.x database to UTF8 (with a collation of utf8_unicode_ci). The description is outdated. They added utf8mb4 as an option after some of the first versions of the converter. Link to comment Share on other sites More sharing options...
chilihead Posted June 25, 2015 Author Share Posted June 25, 2015 Excellent. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.