Transfer Tool reports a function error when restoring a database

Symptoms

When transferring a MySQL database from a remote server via the Transfer Tool, this error appears in the transfer log when restoring the database:

The MySQL server reported an error (This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)) in response to this request

Description

This error appears when a specific non-deterministic function, such as a view or stored procedure, is defined for the database and is not compatible with the Transfer Tool due to incorrect security-definer settings. You can read more about this error here:

DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

Workaround

Manually drop and recreate the database cleanly, then restore it from a database dump file.