What should be done when MySQL server is being upgraded to newer version?

This article is for Zmanda Recovery Manager For MySQL (ZRM)

Info Type: Tip

Info Description:

When MySQL server version is being upgraded (or downgraded),

  1. It is a good idea to do a full backup of the databases/tables before the upgrade.
  2. Check whether the MySQL client version installed on the ZRM server is compatible with new MySQL server version. 
  3. If the MySQL server parameters are changed such as MySQL server port, MySQL backup user or password, the backup set configuration should be updated.
  4. After the upgrade, please check for any configuration errors (Visit Backup|Summary page for the backup set) in the backup set that is configured to backup the MySQL server.
  5. Check database/table consistency after the upgrade before doing a full backup of the backup set. Use mysqlcheck, MySQL client program to do table consistency checks.
en_USEnglish
fr_FRFrench it_ITItalian es_ESSpanish de_DEGerman pt_BRPortuguese sv_SESwedish tr_TRTurkish nl_NLDutch jaJapanese pl_PLPolish zh_TWChinese id_IDIndonesian ko_KRKorean ms_MYMalay thThai en_USEnglish