Issue with composite datasets not returning a reversed iterator.

This results in tables being truncated in the same order they are created which in my case caused numerous foreign key issues.

Whilst creating the test for this I noticed some issues with the MySQL test setup which I have also updated.