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:
- Whats the cause of diferrent size?
- Anyone any suggestions about my options to backup?