Comment 1 for bug 1277049

Revision history for this message
Jericho Rivera (jericho-rivera) wrote :

Fernando, can you try the following instead:

pt-online-schema-change --alter "<SOME BASIC ALTER>" --host "<DB HOST>" --user "root" --password "fizz\,buzz" --alter-foreign-keys-method "auto" D=test,t=test

See the "\" before the comma. It worked on my test.

root@node2:/home/vagrant# pt-online-schema-change --user test_user --password "comma\,separated" --alter "ENGINE=InnoDB" D=test,t=t --dry-run
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Starting a dry run. `test`.`t` will not be altered. Specify --execute instead of --dry-run to alter the table.
Creating new table...
Created new table test._t_new OK.
Altering new table...
Altered `test`.`_t_new` OK.
Not creating triggers because this is a dry run.
Not copying rows because this is a dry run.
Not swapping tables because this is a dry run.
Not dropping old table because this is a dry run.
Not dropping triggers because this is a dry run.
2014-02-12T09:27:27 Dropping new table...
2014-02-12T09:27:27 Dropped new table OK.
Dry run complete. `test`.`t` was not altered.