post
Skip to main content

Astuces pour le passage en Joomla 4.x

Script pour la conversion de la base de données
SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = 'mabase'
AND `ENGINE` = 'MyISAM'
AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;


SET SQL_MODE='ALLOW_INVALID_DATES';

.....

Sinon il y a un warning empechant toute conversion à partir de la version Mysql 5.7
  • Dernière mise à jour le .