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