Migrating to New Server

Hi, I'm trying to migrate to a new server... I followed the documentation HERE: https://www.virtualmin.com/documentation/system/migrate

Everything seemed to go smoothly until the last domain... The readout is below... I'm wondering what the Error is or means and WHAT to do as my next step? What do I do if the restoration fails? Do I just "try" running it again?

Restoring backup for virtual server burneruniversity.com .. Restoring virtual server password, quota and other details .. .. done

Updating administration password and quotas .. .. done Restoring Cron jobs .. .. done Extracting TAR file of home directory .. .. done Setting ownership of home directory .. .. done Re-creating records in DNS domain .. .. done Restoring Apache virtual host configuration .. .. done Checking restored PHP execution mode .. .. mode FCGId OK for this system Updating home directory in PHP configuration .. .. done Restoring Apache log files .. .. done Restoring SSL Apache virtual host configuration and certificate .. .. done Restoring Logrotate configuration .. .. done Restoring allowed MySQL hosts .. .. done Re-loading MySQL database burneruniversity_com .. .. done Re-loading MySQL database burneruniversity_com_moodle .. Creating MySQL database burneruniversity_com_moodle .. .. done .. load failed! ERROR 1071 (42000) at line 1374: Specified key was too long; max key length is 767 bytes

Re-starting DNS server .. .. done

Applying web server configuration .. .. done

Restore failed!

hawk596:~#

Status: 
Active

Comments

Howdy -- I haven't run into that before, but doing some Googling, it looks like that can happen if an index that is particularly large is moved to another MySQL version with a character set that takes up more space... that new character set can push the large index over the size limit.

Try editing your /etc/mysql/my.cf file (possibly just /etc/my.cnf), and add this to the mysqld section:

innodb_large_prefix=on

Then restart the database.

After that, are you then able to import that domain?