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
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 …