MySQL Bugs: #52793: mysqldump XML output does not include database options

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Thank you for the report.

Verified as described.