
16 Aug
2012
16 Aug
'12
3:08 a.m.
SQL dumps are not by definition good either, the appropriate command line options depend on things like which storage engine(s) are used and what character sets. We regularly encounter dumps that cannot be sanely loaded, primarily due to character set issues. People are exceedingly slack in this respect, and only "start caring" when there's a drama which is obviously rather late. Cheers, Arjen. Is there a generic set of commands that should be applied to a mysqldump to guard against such things? Roger