This tool requires binlog_format=STATEMENT, but the current binlog_format is set to MIXED and an error occurred while attempting to change it. If running MySQL 5.1.29 or newer, setting binlog_format requires the SUPER privilege. You will need to manually set binlog_format to 'STATEMENT' before running this tool.

you need to assign SUPER privileges for the user you are using with pt-table-sync. As SUPER privilege is required to change binlog_format.
To check current privileges for the user. Check via following command.

Code:

mysql> SHOW GRANTS FOR 'username'@'hostname';

Use following command to assign SUPER privilege.

Code:

mysql> GRANT SUPER ON *.* TO 'username'@'hostname' IDENTIFIED BY 'password';

Comment

It really put me in a pickle as I have the script in place to sync from a protected database to a local copy etc. The script used to work fine until this switch was removed. The DBA's are never going to grant super privs to a user account in that database..

Unless that parameter is restored at some point, you have two options, you can find an old version of the toolkit - I think version 2.1.3 still supports this switch.. -or- you can modify the pt-table-sync script and comment out the line where the set binlog sql is executed around line 10827 like this - #$dbh->do($sql);