MySQL 5.7 prefix 8 chars limit

jmginer

• November 06, 2019 04:21

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

  • November 06, 2019 17:28

  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.

  0
• 

  jmginer

  • February 02, 2020 11:31

  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.

  0
• 

  capuano

  • October 31, 2020 12:12

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

  0

Please sign in to leave a comment.