Upgrade MySQL 5.7 to MariaDB 10.6

wbhoster

• April 28, 2023 10:19

I want to upgrade my server from MySQL 5.7 to MariaDB 10.6 i want to confirm that if i upgrade it how much time it takes and can i faced any problem after upgradtion. i have 150+ website hosted on my server.

• 

  cPRex Jurassic Moderator

  • April 28, 2023 15:44

  Hey there! The upgrade itself only takes a few minutes. I would expect that process to go well on your server. What we can't say is if all of your databases and code will work with the newer version, as that would be up to a database administrator to determine. If you have standard tools like WordPress or Joomla on your sites, those will be just fine, but any custom code that interacts with the database would need to be reviewed to ensure it works with the newer version.

  0
• 

  wbhoster

  • April 28, 2023 15:47

  Hey there! The upgrade itself only takes a few minutes. I would expect that process to go well on your server. What we can't say is if all of your databases and code will work with the newer version, as that would be up to a database administrator to determine. If you have standard tools like WordPress or Joomla on your sites, those will be just fine, but any custom code that interacts with the database would need to be reviewed to ensure it works with the newer version.

  
  yes we have mostly wordpress sites hosted but site hosted on WHMCS like my main website.

  0
• 

  wbhoster

  • April 28, 2023 17:17

  we have some website which is hosted on WHMCS so i want to confirm that it is safe to update to MariaDB ?

  0
• 

  cPRex Jurassic Moderator

  • April 28, 2023 17:18

  Yes, WHMCS would not be related to the MySQL upgrade.

  0
• 

  wbhoster

  • April 28, 2023 17:24

  Thannks for the reply now i am going to update to MariaDB

  0
• 

  SimpleSonic

  • April 28, 2023 17:57

  Thannks for the reply now i am going to update to MariaDB

  
  Make sure to do a full backup prior to upgrading. You"ll be glad you did if the upgrade fails.

  0
• 

  wbhoster

  • April 29, 2023 04:02

  Make sure to do a full backup prior to upgrading. You"ll be glad you did if the upgrade fails.

  
  How can we take a backup of all server databases?

  0
• 

  ffeingol

  • April 29, 2023 13:17

  From CLI: mysqldump --all-databases > some-file.sql That will backup all the databases on the server into a file called "some-file.sql"

  0
• 

  wbhoster

  • April 30, 2023 16:32

  From CLI: mysqldump --all-databases > some-file.sql That will backup all the databases on the server into a file called "some-file.sql"

  
  Thanks for the reply can u please tell me where this file will be saved on server mean what is the path of "some-file.sql" if i run command and can we restore it if i faced any problem after upgradation.

  0
• 

  SimpleSonic

  • April 30, 2023 17:43

  Thanks for the reply can u please tell me where this file will be saved on server mean what is the path of "some-file.sql" if i run command and can we restore it if i faced any problem after upgradation.

  
  If no path is given it will save it to the current folder you are in.

  0
• 

  wbhoster

  • May 02, 2023 04:10

  From CLI: mysqldump --all-databases > some-file.sql That will backup all the databases on the server into a file called "some-file.sql"

  
  I will create a backup of my server database using this method I want just to confirm if I upgrade today and unfortunately, the upgradation process failed due to any reason can we restore my server database which I saved by using this method if yes then how?

  0
• 

  SimpleSonic

  • May 02, 2023 14:10

  If the databases were dumped to that file, you can import them using: mysql -u root < some-file.sql

  0

Please sign in to leave a comment.