Announcement

Announcement Module
Collapse
No announcement yet.

pt-upgrade help

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-upgrade help

    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 ..
Working...
X