Got it to work. Thanks to me (GRIN).
I am using Eclipse IDE with the hibernate tools installed.
I put the mysql connector jar in the lib folder
I un-commented the part in hibernate.cfg.xml that says for MySQL database but modified it this way:
Then I edited all the mapping files; did the following:
Removed the part that references the globals.dtd
Replaced the identifier reference by 'native'
I am able to export the schema to MySQL with the graphical tools.