Centos copy with percentage and speed

[root@db07 ~]# rsync --progress -a /data/storage/backup/full/2015-08-22_18-00-02 /data/storage/dba_backup_important/
sending incremental file list
2015-08-22_18-00-02/
2015-08-22_18-00-02/backup-my.cnf
         358 100%    0.00kB/s    0:00:00 (xfer#1, to-check=354/356)
2015-08-22_18-00-02/ibdata1
  1820098560  50%   26.58MB/s    0:01:04

mysqlbinlog Segmentation fault (core dumped)

[root@twpdb22 mysqlbinlog]# mysqlbinlog --no-defaults -v logbin.000912 > logbin000912.sql
Segmentation fault (core dumped)
[root@twpdb22 mysqlbinlog]# find / -name mysqlbinlog
/data/mysql/mysqlbinlog
/usr/local/mysql/bin/mysqlbinlog
/usr/bin/mysqlbinlog
You have new mail in /var/spool/mail/root
[root@twpdb22 mysqlbinlog]# rm -fr /usr/bin/mysqlbinlog
[root@twpdb22 mysqlbinlog]# cp /usr/local/mysql/bin/mysqlbinlog /usr/bin/
You have new mail in /var/spool/mail/root
[root@twpdb22 mysqlbinlog]# mysqlbinlog --no-defaults -v logbin.000912 > logbin000912.sql
[root@twpdb22 mysqlbinlog]#


The reason was got 2 different version mysqlbinlog , replace the old with new version, then settle the issue.

MySQL noAccessToProcedureBodies=true

Client encounter access rights not enough error as:


Error updating database.  Cause: java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.


Then we grant rights as blow:


GRANT EXECUTE ON PROCEDURE `prodDB`.`spconsolidate_transaction_detail` TO 'user'@'***.***.***.***';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `prodDB`.* TO 'user'@'***.***.***.***';


GRANT SELECT ON mysql.proc TO 'user'@'***.***.***.***'; # this line must have.




----The End-------