way to get what I need (and I have tried this) is
to restore a 'usable' backup into a dummy database, and run through the
tables of the one which needs the partial restore (after backing it up
first, naturally) deleting records for that league (using the 3-4 letter
code), then insert ... select
We are shortly to go live with a new set of databases (InnoDB).
The data in each database is identical in fields and types, the only
difference being in the relevance of the data - they are soccer leagues,
and each database represents information on the leagues/teams for a
single season.