Hello,

I was wondering If I can use pt-online-schema-change tool to optimize multiple tables at a time. I have a shell script that gets the list of tables and loop through the table list and plugs in the pt-online-schem-change command and I have been receiving the below error:


Errors in command-line arguments:
* Specify only one DSN on the command line

Here is my script:
tb_name=$(mysql -BsN -u*** -p****** -D sandbox -e "select table_name from information_schema.tables where table_schema = 'sandbox';")


for tb in "${tb_name}"; do
pt-online-schema-change --alter "ENGINE=InnoDB" --host localhost --user ***** --password ***** D=sandbox,t=$tb --dry-run --statistics --print
done

Please help.

Thanks,
Sai