shell > mysqladmin recover test dump.sql

shell > mysql test < dump.sql

shell > mysqlimport test dump.sql

mysql > USE test;

mysql > LOAD DATA INFILE ‘dump.sql’;

mysql > USE test;

mysql > SOURCE dump.sql;

it contains the binary log.

it contains a general tablespace.

it is the default location for all new tables that you create.

it contains the system tablespace.

it contains the redo log.

it contains the undo log.

binlog_cache_size=1024 is too small and transactions are lost.

binlog_format=STATEMENT and a non-deterministic query was executed.

enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

The sync_relay_log=1000 setting on the slave is too small.

sync_binlog=0 and the master server crashed.

The value should be increased if the client performs several SELECT operations.

The join buffer is set per connection.

The join buffer is used to process sorts when complex joins are being performed.

The value should be increased from the default if the query joins large rows without using an index.

The join buffer is global and can be changed only by restarting the server.

There is network congestion between client and server.

No index has been defined on the filtered column.

There are 108 queries still being executed.

A table lock is causing delays.

A full table scan is being used.

Bob has max_user_connections set to zero, which blocks all his connections.

All users are blocked because max_user_connections is accumulated over the host account information.

connect_timeout is too small to allow a connection to occur.

Joe has exceeded the max_user_connections global limit.

Kay is already connected elsewhere and attempting to log in again.

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.