Bug #52793 mysqldump XML output does not include database options
Submitted: 13 Apr 2010 19:34 Modified: 13 Apr 2010 20:25
Reporter: Roland Bouman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.1, 5.6.99 OS:Any
Assigned to: CPU Architecture:Any

[13 Apr 2010 19:34] Roland Bouman
Description:
When using XML output for mysqldump, database options like default character set are not included. 

How to repeat:
mysqldump -uroot -pmysql -P3351 -X --no-data --hex-blob --create-options  -R --databases sakila > sakila-xml.txt

open output file. check <database> tag. nothing there indicating what character set / collation.

Suggested fix:
include database creation options.
[13 Apr 2010 20:25] Sveta Smirnova
Thank you for the report.

Verified as described.