[Toolserver-l] Backing up a user database

Carl (CBM) cbm.wikipedia at gmail.com
Wed Feb 2 12:10:31 UTC 2011


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



More information about the Toolserver-l mailing list