Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 25, 20159 yr 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
June 25, 20159 yr /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.
June 25, 20159 yr Author Don't know what you mean. This is not something in my 3.4 install. I believe it is a download from IPS.
June 25, 20159 yr 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.
June 25, 20159 yr Author 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.
June 25, 20159 yr 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
June 25, 20159 yr Author 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).
June 25, 20159 yr 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.
June 25, 20159 yr 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.
Archived
This topic is now archived and is closed to further replies.