1 of 1

mysql_refresh

Syntax

int mysql_refresh(MYSQL * mysql,
  unsigned int options);

mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().
options - a bit masked composed integer. See below.

Description

Flushes different types of information stored on the server. The bit-masked parameter options specify which kind of information will be flushed. options can be any combinationation of the following:

Option

Description

REFRESH_GRANT

Refresh grant tables.

REFRESH_LOG

Flush logs.

REFRESH_TABLES

Flush table cache.

REFRESH_HOSTS

Flush host cache.

REFRESH_STATUS

Reset status variables.

REFRESH_THREADS

Flush thread cache.

REFRESH_SLAVE

Reset master server information and restart slaves.

REFRESH_MASTER

Remove binary log files.

REFRESH_READ_LOCK

REFRESH_FAST

Returns zero on success, otherwise non zero.

To combine different values in the options parameter use the OR operator '|'. The function mysql_reload() is an alias for mysql_refresh().