Skip to content

Instantly share code, notes, and snippets.

@tkawachi
Created November 2, 2011 03:45
Show Gist options
  • Save tkawachi/1332807 to your computer and use it in GitHub Desktop.
Save tkawachi/1332807 to your computer and use it in GitHub Desktop.
Set charset as utf8 for RDS
#!/usr/bin/env bash
set -u
set -e
GROUP="$1"
PARAMS="character_set_client character_set_connection character_set_database character_set_results character_set_server"
for param in $PARAMS; do
echo Set $param to utf8
rds-modify-db-parameter-group "$GROUP" -p "name=$param, value=utf8, method=immediate"
done
# set lower_case_table_names=1 (requires reboot), rds-reboot-db-instance "$GROUP"
rds-modify-db-parameter-group "$GROUP" -p "name=lower_case_table_names, value=1, method=pending-reboot"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment