#! /bin/bash
echo -n 'Select the Drupal database to convert: '
read -e DRUPAL_NAME
echo -n 'Enter MySQL server: '
read -e MYSQL_SERVER
echo -n 'Enter MySQL username: '
read -e MYSQL_USERNAME
echo -n 'Enter MySQL password: '
read -es MYSQL_PASS
echo ''
echo -n "Converting $DRUPAL_NAME..."
mysqldump -u $MYSQL_USERNAME -p$MYSQL_PASS $DRUPAL_NAME -h $MYSQL_SERVER --add-drop-table > dump.corrupt.mysql
echo -n '..'
cat dump.corrupt.mysql | sed s/DEFAULT\ CHARSET=latin1/DEFAULT\ CHARSET=utf8/ > dump.fixed.mysql
echo '..'
echo 'Commit fixed version'
mysql -u $MYSQL_USERNAME -p$MYSQL_PASS $DRUPAL_NAME -h $MYSQL_SERVER -f --default-character-set=utf8 < dump.fixed.mysql
echo 'Finished'