Tried with this DB (shown i Access “relations” view”).
here you will have to set FOREIGN KEYS CHECK = 0 in Backup tool.
So it probably was a mere coincidence that with only two tables they came in the right order.
Actually I don't know if this is a bug. There can be DB-design's where no sort order will do and you will have to use FOREIGN KEYS CHECK = 0. A solution could be always using FOREIGN KEYS CHECK = 0 with InnoDB from export tool. However then it must be user's responsibility to always exprot related tables! Quite a difficult choice I believe …
I have the Enterprise version 😀