Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 20.8.3 C API Function Descriptions
- 20.8.3.1 mysql_affected_rows()
- 20.8.3.2 mysql_autocommit()
- 20.8.3.3 mysql_change_user()
- 20.8.3.4 mysql_character_set_name()
- 20.8.3.5 mysql_close()
- 20.8.3.6 mysql_commit()
- 20.8.3.7 mysql_connect()
- 20.8.3.8 mysql_create_db()
- 20.8.3.9 mysql_data_seek()
- 20.8.3.10 mysql_debug()
- 20.8.3.11 mysql_drop_db()
- 20.8.3.12 mysql_dump_debug_info()
- 20.8.3.13 mysql_eof()
- 20.8.3.14 mysql_errno()
- 20.8.3.15 mysql_error()
- 20.8.3.16 mysql_escape_string()
- 20.8.3.17 mysql_fetch_field()
- 20.8.3.18 mysql_fetch_field_direct()
- 20.8.3.19 mysql_fetch_fields()
- 20.8.3.20 mysql_fetch_lengths()
- 20.8.3.21 mysql_fetch_row()
- 20.8.3.22 mysql_field_count()
- 20.8.3.23 mysql_field_seek()
- 20.8.3.24 mysql_field_tell()
- 20.8.3.25 mysql_free_result()
- 20.8.3.26 mysql_get_character_set_info()
- 20.8.3.27 mysql_get_client_info()
- 20.8.3.28 mysql_get_client_version()
- 20.8.3.29 mysql_get_host_info()
- 20.8.3.30 mysql_get_proto_info()
- 20.8.3.31 mysql_get_server_info()
- 20.8.3.32 mysql_get_server_version()
- 20.8.3.33 mysql_get_ssl_cipher()
- 20.8.3.34 mysql_hex_string()
- 20.8.3.35 mysql_info()
- 20.8.3.36 mysql_init()
- 20.8.3.37 mysql_insert_id()
- 20.8.3.38 mysql_kill()
- 20.8.3.39 mysql_library_end()
- 20.8.3.40 mysql_library_init()
- 20.8.3.41 mysql_list_dbs()
- 20.8.3.42 mysql_list_fields()
- 20.8.3.43 mysql_list_processes()
- 20.8.3.44 mysql_list_tables()
- 20.8.3.45 mysql_more_results()
- 20.8.3.46 mysql_next_result()
- 20.8.3.47 mysql_num_fields()
- 20.8.3.48 mysql_num_rows()
- 20.8.3.49 mysql_options()
- 20.8.3.50 mysql_ping()
- 20.8.3.51 mysql_query()
- 20.8.3.52 mysql_real_connect()
- 20.8.3.53 mysql_real_escape_string()
- 20.8.3.54 mysql_real_query()
- 20.8.3.55 mysql_refresh()
- 20.8.3.56 mysql_reload()
- 20.8.3.57 mysql_rollback()
- 20.8.3.58 mysql_row_seek()
- 20.8.3.59 mysql_row_tell()
- 20.8.3.60 mysql_select_db()
- 20.8.3.61 mysql_set_character_set()
- 20.8.3.62 mysql_set_local_infile_default()
- 20.8.3.63 mysql_set_local_infile_handler()
- 20.8.3.64 mysql_set_server_option()
- 20.8.3.65 mysql_shutdown()
- 20.8.3.66 mysql_sqlstate()
- 20.8.3.67 mysql_ssl_set()
- 20.8.3.68 mysql_stat()
- 20.8.3.69 mysql_store_result()
- 20.8.3.70 mysql_thread_id()
- 20.8.3.71 mysql_use_result()
- 20.8.3.72 mysql_warning_count()
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. Non-zero if an error occurred.
Errors
-
CR_COMMANDS_OUT_OF_SYNCCommands were executed in an improper order.
-
CR_SERVER_GONE_ERRORThe MySQL server has gone away.
-
CR_SERVER_LOSTThe connection to the server was lost during the query.
-
CR_UNKNOWN_ERRORAn unknown error occurred.
User Comments
Add your own comment.