Converting database to UTF-8

[SecondSight]

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.

[David..]

Hello,

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.

[SecondSight]

Thank you.

[David..]

15 hours ago, SecondSight said:

Thank you.

And always test things on a test server first. Just to make sure.