Not the answer you need?
Register and ask your own question!

Question regarding pt-online command on MySQL 5.0 environment

savoymsavoym EntrantInactive User Role Beginner
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 in command-line arguments: * Specify only one DSN on the command line * The DSN must specify a database (D) and a table (t) pt-online-schema-change alters a 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' for complete documentation.

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.