1z0-888 Exam Dumps : MySQL 5.7 Database Administrator

--skip-opt

--lock-all-tables

--create-apply-log

--single-transaction

--master-data

Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

Start the MySQL Server with –initialize-insecure to force a password reset procedure on the command line.

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.