Following the documentation…
https://docs.bestpractical.com/rt/5.0.0/UPGRADING.mysql.html
I ran the command changing the db name, user & password:
perl etc/upgrade/upgrade-mysql-schema.pl db user pass > queries.sql
It worked but the import failed…
[root@rt ~/rt-5.0.1] # mysql -u root -p rt5 < queries.sql
Enter password:
ERROR 1283 (HY000) at line 11: Column ‘Content’ cannot be part of FULLTEXT index
So I ran each command one by one… This is the culprit:
mysql> ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL; ERROR 1283 (HY000): Column 'Content' cannot be part of FULLTEXT index
Any suggestions? Can this be safely ignored for now?