Percona Toolkit

pt-online-schema-change documentation example w/drop-tmp-table does not work

Reported by Morgan Tocker on 2011-09-07
18
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
Low
Daniel Nichter
1.0
Low
Daniel Nichter
2.0
Low
Daniel Nichter

Bug Description

See: http://www.percona.com/doc/percona-toolkit/pt-online-schema-change.html (copy and pasting the example) -

root@baseubuntu:~# pt-online-schema-change \
> h=127.1,t=db.tbl \
> --alter "ENGINE=InnoDB" \
> --drop-tmp-table
Unknown option: drop-tmp-table
Usage: pt-online-schema-change [OPTION...] DSN

Errors in command-line arguments:
  * Error parsing options

pt-online-schema-change performs online, non-blocking schema changes to a table.
The table to change must be specified in the DSN C<t> part, like C<t=my_table>.
The table can be database-qualified, or the database can be specified with the
L<"--database"> option. For more details, please use the --help option, or try
'perldoc /usr/bin/pt-online-schema-change' for complete documentation.

-----

From the manual, I believe you mean the option --drop-old-table.

There is a second example in the manual which presumably will also fail:

pt-online-schema-change \
  h=127.1,D=db,t=parent \
  --alter "ADD COLUMN (foo INT)" \
  --child-tables child1,child2 \
  --update-foreign-keys-method drop_tmp_table

David Meiners (dmeiners) wrote :

oops, I reported a duplicate # 864299

Baron Schwartz (baron-xaprb) wrote :

Thanks for the bug report. We will fix this in an upcoming release.

tags: added: docs
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers