Skip to content

Instantly share code, notes, and snippets.

@dcampano

dcampano/alter_tables.sh

Last active August 29, 2015 14:13
Show Gist options
  • Save dcampano/9827ede7604ebf88a71a to your computer and use it in GitHub Desktop.
Save dcampano/9827ede7604ebf88a71a to your computer and use it in GitHub Desktop.
Download ZIP
Alter All Innodb Tables on a database server
Raw
alter_tables.sh
#!/bin/bash
#### USE THIS COMMAND TO GET THE DATABASES AND REMOVE mysql, information_schema, performance_schema
#### EVEN THOUGH IT SHOULDN'T HURT TO HAVE THEM IN THERE
#### mysql -s -e "SHOW DATABASES;"
DATABASES="
db_name_1
db_name_2
"
for DB in $DATABASES; do
TABLES=`mysql --skip-column-names -e "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = '$DB' AND engine = 'innodb';"`
for TABLE in $TABLES; do
echo " ====================== "
echo "Altering Table: $DB.$TABLE"
mysql --show-warnings -e "ALTER TABLE $DB.$TABLE FORCE"
echo " ====================== "
done
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment