It clearly says in yellow box you will have to execute query that is above manually to your mysql server, mostlikely your mysql server is not version 8.0 which is required on v3.20.x
SSD Cloud VDS using server
Operation System : CentOS Linux 7.9.2009 (Core) - Plesk Obsidian v18.0.36_build1800210604.22 os_CentOS 7
MySQL : 10.2.39-MariaDB
PHP : 7.3.28-1centos.7.210430.1502
SSD Cloud VDS using server
Operation System : CentOS Linux 7.9.2009 (Core) - Plesk Obsidian v18.0.36_build1800210604.22 os_CentOS 7
MySQL : 10.2.39-MariaDB
PHP : 7.3.28-1centos.7.210430.1502
Hey there, If you have one of these: Error SQL query: Copy CREATE TABLE `chv_assets` ( `asset_id` bigint(32) NOT NULL AUTO_INCREMENT, `asset_key` varchar(255) NOT NULL, `asset_md5` varchar(32) NOT NULL, `asset_filename` varchar(255) NOT NULL, `asset_file_path` varchar(255) NOT NULL...
I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB. I am wondering if there is a way to quickly change all of them to InnoDB?
stackoverflow.com
This part specifically,
Run this SQL statement (in the MySQL client, phpMyAdmin, or wherever) to retrieve all the MyISAM tables in your database.
Replace value of the name_of_your_db variable with your database name.
SQL:
SET @DATABASE_NAME = 'name_of_your_db';
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = @DATABASE_NAME
AND `ENGINE` = 'MyISAM'
AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;