Can’t import database: Index column size too large. The maximum column size is 767 bytes

Symptoms

Importing a database fails with the following error:

Failed to create tmp table example_table. Index column size too large. The maximum column size is 767 bytes.

Cause

There are insufficient InnoDB values configured in MariaDB.

Resolution

Increase the InnoDB values directly on the server files; steps vary by OS.