Backup before upgrade

Pietro Leone

• May 21, 2024 09:26

Hello,

i am near to upgrade mysql version on 1 server. i use db governor on it.

before do it, i want to know if it is convenient use mysql enterprise backup (https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/installing.html)

in the past upgrades i always dump all db. but fortunly it was never used for restore !!!

something like this:

mysqldump -u root -p --all-databases > all_dbs.sql

 

thanks

• 

  cPRex Jurassic Moderator

  • May 21, 2024 13:02

  Hey there!  Dumping all the databases is never a bad idea, but if you have cPanel backups with the databases included you would already have backups of each database on the system.

  I don't have any experience with the MySQL Enterprise Backup tool, and that's not something that cPanel tests, so I can't comment on that part of the question.

  0

Please sign in to leave a comment.