nerdexam
Oracle

1Z0-873 · Question #70

Which of the following should be done before upgrading the mysql server to a newer version?

The correct answer is A. Read and understand the appropriate "Upgrading MySQL" section of the online manual. B. Read through the online change notes and understand the changes made between the versions. Check the MySQL Reference Manual before performing any upgrade: Always consult the section on upgrading to see whether there are any notes pertaining to the type of upgrade you're performing. If so, follow the recommended procedures described there. Check the change note…

Installing and Upgrading MySQL

Question

Which of the following should be done before upgrading the mysql server to a newer version?

Options

  • ARead and understand the appropriate "Upgrading MySQL" section of the online manual.
  • BRead through the online change notes and understand the changes made between the versions.
  • CPrepare the datadir to be read in by a new version by running the mysqlupgrade --prepare
  • DNothing; MySQL data files are binary compatible between all versions and the server will

How the community answered

(44 responses)
  • A
    80% (35)
  • C
    14% (6)
  • D
    7% (3)

Explanation

Check the MySQL Reference Manual before performing any upgrade: Always consult the section on upgrading to see whether there are any notes pertaining to the type of upgrade you're performing. If so, follow the recommended procedures described there. Check the change note sections for versions more recent than your current version to make sure that you're aware of what has changed since your original install. Note particularly any changes that are not backward compatible with your current version because they may require modifications to your existing applications if you upgrade.

Topics

#MySQL upgrade#version migration#upgrade procedure

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice