script to apply new innodb_log_file_size defined in /etc/mysql/my.cnf

innodb_log_file_size.sh

#!/bin/bash

echo "edit the variable innodb_log_file_size in /etc/mysql/my.cnf before launching this script"
echo "do you want to launch the script ? [y/n]"
read -r start

if [ "$start" = "n" ]; then
exit 1
elif [[ "$start" = "y" ]]; then

service mysql stop
sleep 5

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

service mysql start

fi