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

Support
6

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.