MySQL 5.7 prefix 8 chars limit

[jmginer]

Hello, on servers with MySQL 5.7, the database prefix is limited to 8 characters.

This causes a serious problem if I want to migrate the accounts of a server with MariaDB, since all prefixes higher than 8 characters are going to be renamed and the webs are going to stop working until the user manually edits the connection settings.

It is feasible when we want to migrate an individual website, but impossible if we want to migrate hundreds of websites.

Is there any solution to allow in a migration from MariaDB to MySQL the original db names and usernames (including prefixes)?

Thanks!

 

[cPanelLauren]

Hello,

As far as I'm aware, without removing the prefix or modifying it there is no supported way to do this during the migration or automatically.

 

[jmginer]

MariaDB -> No limit to the number of characters in the database prefix
MySQL 5.7 -> Limited to 8 characters the prefix

To be able to use the "cPanel migration tool" without errors, i.e. to migrate a cPanel account from a MariaDB server to a MySQL 8 server, it is important to remove the 8 character limit in the database prefix for MySQL 8 servers.

As MySQL 8 has a 64 character limit on database names, there is no reason for cPanel to impose a forced limit like in MySQL 5.x

I hope that cPanel developers understand the importance of this situation.

 

[capuano]

Hello,

I am have the same problem and serious mistekes on retore and move accounts, any suggestions to resolve this shortly?