Migrating to New Server

Submitted by ttaylor57 on Fri, 05/19/2017 - 01:05

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

Submitted by andreychek on Fri, 05/19/2017 - 09:16

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?