# pt-upgrade help

**URL:** <https://forums.percona.com/t/pt-upgrade-help/2617>\
**Category:** Percona Toolkit\
**Created:** [March 28, 2013, 11:38pm UTC](https://forums.percona.com/t/pt-upgrade-help/2617 "2013-03-28T23:38:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhanushkar](https://avatars.discourse-cdn.com/v4/letter/d/50afbb/32.png) [@dhanushkar](https://forums.percona.com/u/dhanushkar)\
**Post date:** [March 28, 2013, 11:38pm UTC](https://forums.percona.com/t/pt-upgrade-help/2617/1 "2013-03-28T23:38:02Z")

</div>

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 …
