MySQL 5.7 prefix 8 chars limit

jmginer

Well-Known Member
Jul 26, 2006
143
4
168
Alicante
cPanel Access Level
Root Administrator
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!
 

jmginer

Well-Known Member
Jul 26, 2006
143
4
168
Alicante
cPanel Access Level
Root Administrator
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

Member
Mar 16, 2002
8
0
301
Hello,

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