Mysqldump xml problem

[Henrikki Almusa]

I wanted a schema of a database which uses InnoDB and foreign keys. The command used was

mysqldump --xml --no-data -u <username> -p --database <database> > database_schema.xml

The problem with this is that it doesn't show the foreign key information correctly. They are stuck into a comment field of the engine which cuts the text after some lenght leaving only partial foreign keys shown. Is there any way to get this information properly in xml format? I would parse that to another format (for Molgenis actually) and it would be much more enjoyable to use xml format than just default mysqldump text file.

Edit: I tried to actually make a bug report from this but the login fails if I try to do that, so this I resort to forums instead :).



Edited 1 time(s). Last edit at 09/30/2008 12:39AM by Henrikki Almusa.