SQL import Error

Does anyone recognise this error when trying to import a SQL database that has been exported from a working site running core 8.2

CREATE TABLE `AreaLayoutColumns` (
  `arLayoutColumnID` int UNSIGNED NOT NULL,
  `arLayoutID` int UNSIGNED NOT NULL DEFAULT '0',
  `arLayoutColumnIndex` int UNSIGNED NOT NULL DEFAULT '0',
  `arID` int UNSIGNED NOT NULL DEFAULT '0',
  `arLayoutColumnDisplayID` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci

I think perhaps you pasted the wrong thing in. This is just a table query, not an error.

Thanks, I solved it. To import the SQL i needed to add the name of the databse first, it wouldn’t add it automatically.

1 Like