Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Marcolino922's avatar

Problems with database import

Hi, I have encountered an oddity in importing the database on two different hosting plans of my provider.

In one with more features I have no problem importing the database, everything is created normally.

While in the lower floor, but with the same version of the database, it has problems importing.

In particular:

--
-- Indici per le tabelle `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) USING BTREE
Messaggio di MySQL: Documentazione

#1071 - The specified key is too long. The max length of the key is 767
0 likes
2 replies
Marcolino922's avatar

If I understand correctly, is the problem basically with an older version of MySQL?

Please or to participate in this conversation.