pt-upgrade help

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-upgrade help


    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=,u=com,p=password --socket /tmp/mysql.sock] [D=com_v1,h=,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 ..