Топ-100
 
CerebroSQL

RESET

Database: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

Topic

Syntax:
RESET reset_option [, reset_option] ...

reset_option: {
MASTER
| SLAVE
}

The RESET statement is used to clear the state of various server
operations. You must have the RELOAD privilege to execute RESET.

For information about the RESET PERSIST statement that removes
persisted global system variables, see [HELP RESET PERSIST].

RESET acts as a stronger version of the FLUSH statement. See [HELP
FLUSH].

The RESET statement causes an implicit commit.

The following list describes the permitted RESET statement reset_option
values:

o RESET MASTER

Deletes all binary logs listed in the index file, resets the binary
log index file to be empty, and creates a new binary log file.

o RESET SLAVE

Makes the replica forget its replication position in the source
binary logs. Also resets the relay log by deleting any existing relay
log files and beginning a new one.

Example