Can you transfer a cPanel server with MariaDB 10.3 to a server with MySQL 8?

WebHostPro

• May 15, 2021 14:03

We are migrating an older server that uses MariaDB 10.3 and we want to use MySQL 8 on the new server. There is about 30 cPanel accounts on the old server. Will there be any compatibility issues with default cPanel set ups? No custom software or configurations or used on MariaDB or MySQL.

• 

  andrew.n

  • May 16, 2021 06:48

  I would first upgrade to MySQL 8 on the old server to make sure everything is working okay and then proceed with the migration over to the new server.

  0
• 

  quietFinn

  • May 16, 2021 06:55

  I would first upgrade to MySQL 8 on the old server to make sure everything is working okay and then proceed with the migration over to the new server.

  
  I don't think that's possible (n WHM anyway). in WHM -> SQL Services -> MySQL/mariaDB Upgrade: " Also note that since MariaDB is installed, moving to MySQL 8 is considered a downgrade, and therefore not supported. " I would do a test transfer and see how it goes.

  0
• 

  andrew.n

  • May 16, 2021 07:12

  @quietFinn is right, direct upgrade from MariaDB to MySQL 8 is not supported due to using your hosts file you can test how it is and then proceed with the live transfer.

  0
• 

  cPRex Jurassic Moderator

  • May 17, 2021 14:43

  We do recommend trying to match the MySQL version as close as possible, even with transfers we perform for clients in our ticket system. You may want to try @andrew.n 's suggestion of moving over one domain and testing that on the new server before switching DNS or performing a live transfer.

  0

Please sign in to leave a comment.