How to convert Nextcloud MariaDB/MySQL tables to ROW_FORMAT=Dynamic

In order to convert all tables in a MariaDB/MySQL database to use the ROW_FORMAT=DYNAMIC first set the default row format using the following SQL query:

convert_row_format.sql

SET GLOBAL innodb_default_row_format=DYNAMIC;

SET GLOBAL innodb_default_row_format=DYNAMIC;

After that, generate the queries to convert all tables to use the ROW_FORMAT=DYNAMIC:

example.sql

SELECT CONCAT('ALTER TABLE `', table_name, '` ROW_FORMAT=DYNAMIC;') AS sql_statements
FROM information_schema.tables
WHERE table_schema = 'nextcloud'
AND ROW_FORMAT != 'Dynamic';

SELECT CONCAT('ALTER TABLE `', table_name, '` ROW_FORMAT=DYNAMIC;') AS sql_statements
FROM information_schema.tables
WHERE table_schema = 'nextcloud'
AND ROW_FORMAT != 'Dynamic';

Copy the output of the query and run it in your database. This may take a while depending on the size of your database.

Check out similar posts by category: Nextcloud, MariaDB

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow

Buy me a coffee