After upgrade to version 31.0.5 . I see Incorrect row format found in your database. ROW_FORMAT=Dynamic offers the best database performances for Nextcloud. Please update row format on the following list:
command ./occ_convert_charset
report :
All tables already have the correct collation → nothing to do
database query report :
select table_name, row_format from information_schema.tables where table_schema = ‘nextcloud’ AND ROW_FORMAT <> ‘Dynamic’;
Empty set (0.001 sec)
hello @Spinning8429 ,
maybe this could help you:
Hello,
Your script changes the ROW_FORMAT of the InnoDB tables to DYNAMIC, but it has a problem: it generates the queries in a first mysql -e and then executes them separately in a loop, which can be problematic if the password is asked for each query. Here is an optimized version that executes everything in one command:
#!/bin/bash
# Prompt for database credentials
read -p "Enter Database Name: " DB_NAME
read -p "Enter Username: " DB_USER
read -s -p "Enter Password: " DB_PASS
echo
# Execute…
1 Like