ok have setup new instance and compared tables etc. when I try to import sql backup from old instance no data populates and I get a few errors. Not sure if they are relevant or not but new instance has no clients or data etc. what else am I missing on restoring data?
`account_type_description` text DEFAULT NULL,
`account_type_created_at` datetime NOT NULL DEFAULT current_timestamp(),
`account_type_updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
`account_type_archived_at` datetime DEFAULT NULL,
PRIMARY KEY (`account_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
MySQL said:
#1050 - Table 'account_types' already exists