Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Question 98

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.

Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.

Start mysqld again using the --upgrade=FORCE option.

Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.

Go to the /mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.

Correct Answer: D

The errors in the log indicate that specific MySQL system tables (`columns_priv`, `event`, `proc`, `proxies_priv`, `tables_priv`) require repairs. The correct way to handle these issues is to use the `mysqlcheck` utility with the `--repair` option to fix these tables. This directly addresses the errors shown in the logs by repairing the affected tables, which is what is needed in this scenario.

Discussion

marklvOption: C

C, you start mysqld with force upgrade option. New in 8.0