This is the error message that I get when trying to restore the automated dropbox backup to a mariadb 5.5.43 server, using phpmyadmin:
SQL query:
CREATE TABLE __Auth ( user varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, password varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (user),
KEY user (user)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;
MySQL said: #1709 - Index column size too large. The maximum column size is 767 bytes.
But, When I restore using the command line as you suggest:
bench --force --site sitename restore /home/ubuntu/en_test_may2015.sql
Then, enter mysql password
It does the restore, but I get “internal server error” when I try run the site