What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.

You test whether the import was successful by using the following commands:

Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)

Mysql> show grants for ‘admin’@’%’;

ERROR 1141 (42000): There is no such grant defined for user ‘admin’ on host ‘%’

Which command will fix this issue?

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data.

You then TRUNCATE this table to empty it.

Mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table?