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.
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
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