Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
chilihead Posted June 25, 2015 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
Vroom Posted June 25, 2015 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.
chilihead Posted June 25, 2015 Author 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.
Vroom Posted June 25, 2015 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.
chilihead Posted June 25, 2015 Author 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.
Ahmad E. Posted June 25, 2015 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
chilihead Posted June 25, 2015 Author 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).
Ahmad E. Posted June 25, 2015 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.
TSP Posted June 25, 2015 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.