（含图）

You execute a "SHOW CREATE TABLE mytable" on the slave:（含图）

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

You are unable to use an additional intermediate MySQL instance to restore the table. 

Which two backup methods can be used to restore the single table without stopping the MySQL instance?

[mysqld]  

skip-log-bin 

/myfolder2/my.cnf has this option set:

 [mysqld] log-bin = /valid/path/to/mysqlbinlog 

All mentioned paths are accessible to the account that you are currently using.

 Assume that any other options mentioned in either file are valid and legal option definitions. 

You start an instance by using this command line: mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

The user option is set to mysql in /etc/my.cnf. What is the reason for this error and how do you fix it?

The account has temporarily been granted full privileges WITH GRANT to perform the actions required. You want to change the password for the locally existing "backup" user. Select the three command which will perform the required action.

（含图）