db-table-list.txt contains the list of tables from a specific db, exported with:
use somedb;
SELECT * FROM somedb;
And filtered with:
cut -d’|’ -f 2 ./db-table-list.txt
Here’s the script:
#!/bin/bash
for tbl in $(cat ./db-table-list.txt); do
mysql –user=root \
–password=”suchsecure” \
–execute=”use somedb;” \
–execute=”ALTER TABLE $tbl ROW_FORMAT=Compressed;”
done <<< “$tbl”