ok so as the mediawiki upgrade guide I made a backup of my database in both sql and xml formats turns out the xml dump is twice as big but it compresses better so both dumps ended up with a similar file size compressed so uh, reminder to compress your database dumps