• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue InnoDB Barracuda support?

vincheesel

New Pleskian
Hi Team,

I'm running the latest available version of Plesk Onyx, and was hoping to migrate a CMS called Moodle.
mysql Version is 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1

The Moodle database is running InnoDB file format in Barracuda.

I have attempted to import it - and was given the error.

Code:
Unable to import the db_moodle2 dump:
ERROR 1071 (42000) at line 970: Specified key was too long; max key length is 767 bytes
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
restore(options, password)
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1

Would it be an issue to run in the Barracuda file format on Plesk Onyx and would Plesk still provide support?
set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;

Please advise
 
Back
Top