20.4.38 mysql_ping()

int mysql_ping(MYSQL *mysql)

20.4.38.1 Description

Checks whether or not the connection to the server is working. If it has gone down, an automatic reconnection is attempted.

This function can be used by clients that remain idle for a long while, to check whether or not the server has closed the connection and reconnect if necessary.

20.4.38.2 Return values

Zero if the server is alive. Non-zero if an error occurred.

20.4.38.3 Errors

CR_COMMANDS_OUT_OF_SYNC

Commands were executed in an improper order.

CR_SERVER_GONE_ERROR

The MySQL server has gone away.

CR_UNKNOWN_ERROR

An unknown error occurred.