Question regarding pt-online command on MySQL 5.0 environment

MySQL & MariaDB Other MySQL® Questions
1

pt-online-schema-change --set-vars innodb_lock_wait_ti meout=50 --host=localhost --alter-foreign-keys-method=auto user=tfuser --ask -pass --alter " ADD INDEX indAppPostCodeAnywhere (Forename, Surname, DOB, Applic ationDate)" D=DBName,t=Application --dry-run

Usage: pt-online-schema-change [OPTIONS] DSN Errors [COLOR=#00008B]in command-line arguments: * Specify only one DSN [COLOR=#00008B]on the command line * The DSN must specify a [COLOR=#00008B]database (D) [COLOR=#00008B]and a [COLOR=#00008B]table (t) pt-online-schema-change alters a [COLOR=#00008B]table’s structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. For more details, please use the --help option, or try ‘perldoc /usr/bin/pt-online-schema-change’ [COLOR=#00008B]for complete documentation.

2

Hi,

Please try to run below command and let me know if you get any error. Kindly give whole command with output, if it doesn’t worked.

pt-online-schema-change --set-vars innodb_lock_wait_timeout=50 --host=localhost --alter-foreign-keys-method=auto --user=tfuser --ask-pass --alter " ADD INDEX indAppPostCodeAnywhere (Forename, Surname, DOB, ApplicationDate)" D=DBName,t=Application --dry-run