I have used mysql-administrator to back up my mediawiki and bugzilla database.
Now there is an issue with charsets I can't fix.
So I deciced to try mysqldump
-single-transaction --routines --triggers. My database is a mix of inno and mysiam tables.
I am confused about the different size of the dump files. While the mysqldump is ~150 MB, the mysqladmin file is ~220MB. I cannot explain this, and I can't analyze the dump files, it is too big for my notepad.
I have two questions:
- What's the cause of the different sizes?
- Anyone any suggestions about my options to backup?