Converting Database to UTF8MB4

[Black Six]

I have a recommendation in my ACP saying the following:

Quote

Your database is currently configured to use single-byte UTF-8 Encoding. Some non-common symbols (such as historical scripts, music symbols and Emoji) require 4-Byte UTF-8 Encoding. If you want users to be able to post these symbols, your database needs to be converted.

Based on my past experience, running these sorts of SQL updates through the ACP almost always times out and ends up incomplete. Is there a way to get the SQL commands needed to do this conversion so I can do it via SSH or PHPMyAdmin?

Thanks!

[Marc]

There isnt. You would need to follow the procedure shown there at present

[Stuart Silvester]

49 minutes ago, Black Six said:

I have a recommendation in my ACP saying the following:

Based on my past experience, running these sorts of SQL updates through the ACP almost always times out and ends up incomplete. Is there a way to get the SQL commands needed to do this conversion so I can do it via SSH or PHPMyAdmin?

Thanks!

It's designed to be ran in this environment; it doesn't run all queries at once.