My Confluence not startup after try change database Collation in MySQL

Matti Kiviharju

My Confluence not startup after try change database Collation in MySQL.

I ran this bash code in command line for to try to fix collation:

#!/bin/bash

# mycollate.sh <database> [<charset> <collation>]
# changes MySQL/MariaDB charset and collation for one database - all tables and
# all columns in all tables

DB="$1"
CHARSET="$2"
COLL="$3"

[ -n "$DB" ] || exit 1
[ -n "$CHARSET" ] || CHARSET="utf8"
[ -n "$COLL" ] || COLL="utf8_bin"

echo $DB
echo "ALTER DATABASE $DB CHARACTER SET $CHARSET COLLATE $COLL;" | mysql -uroot -ppassword

echo "USE $DB; SHOW TABLES;" | mysql -s -uroot -ppassword| (
 while read TABLE; do
 echo $DB.$TABLE
 echo "ALTER TABLE $TABLE CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;" | mysql -uroot -ppassword $DB 
 done
)

How to fix this bash script to get Conflunence to startup again?

Shannon S

Hi Matti,

In order to properly fix the collation, you'll want to make sure that you've completed exactly the same steps as mentioned on our article:

• How to Fix the Collation and Character Set of a MySQL Database

The Table of Contents at the bottom discusses the set of changes you will need to perform.

Can you be sure that you edited the collation on both a table, column, and database level? 

Thank you!

Regards,

Shannon