mysql_refresh(3)

Name

mysql_refresh - flushes information on the server


#include <mysql.h>
int mysql_refresh(MYSQL * mysql, unsigned int options);

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

•: mysql - a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3).
•: options - a bit masked composed integer. See below.

options can be any combinationation of the following flags:

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.

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

Returns zero on success, otherwise non zero.