I realized I have to make some character set changes on one of my user
databases, and I want to make a backup before I start. Of course
there are server backups as well, but I view those as an absolute last
resort.
I was planning to use mysqldump for this. Is there a better option
that I'm overlooking?
Is there any reason that the output of 'mysqldump -hSERVER DATABASE'
with no additional options would have problems restoring on the
toolserver databases?
Are there any subtle options that need to be set on mysqldump to make
sure the output is usable in that environment?
- Carl