1 of 2

mysqldump dump file size

ive uses mysql-administrator for backing up my mediawiki and bugzilla database. but now there is a issue i cant fix - with charsets.

And because i cannot adjust mysql admin, i deciced to try mysqldump with "-single-transaction --routines --triggers". ( Its a mix of inno and mysiam tables ).

And im confused about the different size of dump files.

While mysqldump is ~150 MB, the mysqladmin file is ~220MB.

I cannot explain this, and i cant analyze the dump files - too big for my notepad.

So here my two questions:

  1. Whats the cause of diferrent size?
  2. Anyone any suggestions about my options to backup?