Jump to content

Converting database to UTF-8


Recommended Posts

Hello ! :)

I'm going to upgrade to IPB 4.

My database's posts table is 5 Gb big. My server has 12 processors and the CPU is Intel(R) Xeon(R) CPU E5-1650 0 @ 3.20GHz.

How long (approximately) will it take to convert it to UTF-8, in your opinion ?

What should I do to make sure it works ? Turn off the board ? Disable server backups ?


Thank you. :)

Link to comment
Share on other sites


A 5GB database might take ~25 minutes to convert. This is my estimation compared to the ~5 minutes it took me to convert a 1GB database.

I strongly suggest you take a full backup before continuing and I suggest you turn your board offline when this is happening so new rows don't get entered in the database during the conversion.

Also, UTF-8mb4 might be better.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...