The user_profiles table in my old backup really doesn’t contain column card_image_badge_id, so I edited the sql dump, added the new column (but not the profile_background_upload_id and card_background_upload_id that are present in newer schemas) - the CREATE TABLE now looks like this
CREATE TABLE public.user_profiles (
user_id integer NOT NULL,
location character varying,
website character varying,
bio_raw text,
bio_cooked text,
profile_background character varying(255),
dismissed_banner_key integer,
bio_cooked_version integer,
badge_granted_title boolean DEFAULT false,
card_background character varying(255),
card_image_badge_id integer,
views integer DEFAULT 0 NOT NULL
);
and the restore worked. I get 500 after logging in to the site, but that may be the problem I’ve tried to escape from by starting the new instance in the first place.