I'm trying to migrate an old discourse by creating a new discourse, but I'm having trouble

See Restore a backup from command line (which I believe will tell you how to restore from the command line). That will give you the full error message.