16 lines
No EOL
617 B
Bash
Executable file
16 lines
No EOL
617 B
Bash
Executable file
#!/bin/sh
|
|
|
|
# Source: https://help.nextcloud.com/t/upgrade-to-nextcloud-hub-10-31-0-0-incorrect-row-format-found-in-your-database/218366/13
|
|
|
|
# # Prompt for database credentials
|
|
# read -p "Enter Database Name: " MYSQL_DATABASE
|
|
# read -p "Enter Username: " MYSQL_USER
|
|
# read -s -p "Enter Password: " MYSQL_PASSWORD
|
|
# echo
|
|
|
|
mysql -u "$MYSQL_USER" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE" -Bse "
|
|
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;')
|
|
FROM INFORMATION_SCHEMA.TABLES
|
|
WHERE TABLE_SCHEMA = '$MYSQL_DATABASE'
|
|
AND ENGINE = 'InnoDB'
|
|
" | mysql -u "$MYSQL_USER" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE" |