I have done the
SELECT table_name, table_schema, ROW_FORMAT
FROM information_schema.tables
WHERE engine = 'InnoDB' AND TABLE_SCHEMA = '<YOUR DATABASE NAME>' AND ROW_FORMAT = 'COMPACT'
And all 247 rows are "COMPACT" can anybody provide a SQL command to change all of them as I don't want to have to do every single row manually
Also should the forum be taken offline when doing this? Also I have no ssh access
Thanks