int mysql_refresh(MYSQL *mysql, unsigned int
options)
Description
This function flushes tables or caches, or resets replication
server information. The connected user must have the
RELOAD privilege.
The options argument is a bit mask composed
from any combination of the following values. Multiple values
can be OR'ed together to perform multiple operations with a
single call.
REFRESH_GRANTRefresh the grant tables, like
FLUSH PRIVILEGES.REFRESH_LOGFlush the logs, like
FLUSH LOGS.REFRESH_TABLESFlush the table cache, like
FLUSH TABLES.REFRESH_HOSTSFlush the host cache, like
FLUSH HOSTS.REFRESH_STATUSReset status variables, like
FLUSH STATUS.REFRESH_THREADSFlush the thread cache.
REFRESH_SLAVEOn a slave replication server, reset the master server information and restart the slave, like
RESET SLAVE.REFRESH_MASTEROn a master replication server, remove the binary log files listed in the binary log index and truncate the index file, like
RESET MASTER.
Return Values
Zero for success. Nonzero if an error occurred.
Errors
Commands were executed in an improper order.
The MySQL server has gone away.
The connection to the server was lost during the query.
An unknown error occurred.