Not the answer you need?
Register and ask your own question!

pt-upgrade help

dhanushkardhanushkar EntrantCurrent User Role Beginner
Hi..

im planing upgrade mysql from 5.1 to to 5.5 , so i collected some query by enabling query log ,

then i ran the pt-upgrade tool as fallows ,


pt-upgrade --fingerprints samplequery.sql [D=com_v1,h=192.168.0.1,u=com,p=password --socket /tmp/mysql.sock] [D=com_v1,h=192.168.0.2,u=com,p=password --socket /var/run/mysqld/mysqld.sock] > sample13.out &


and most of the query's executed fine , but at end of the report (sample13.out)


got following set of errors .

Failed to execute query: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
line 2 [for Statement "CREATE TEMPORARY TABLE `com_v3`.`mk_upgrad

]

another set of errors such as ,

Failed to clear warnings at /usr/local/bin/pt-upgrade line 9959, <$fh> line 1426.


is there any way overcom this error , please advice ..
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.