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
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().