I want to drop an existing schema (if it exist) in a MySQL database and create a new one ready for insertion.
The need is for setting up a "bacth" creation of several databases..

How can I do this in Hibernate, I have read about the SchemaExport option. But this requires me to save the generated sql to a file and then then continue from there.. there is not an option like the schemaUpdate in org.springframework.orm.hibernate3.LocalSessionFactoryBean that also created the schema if it does not exist???
Or if it of cource can be done in the code in som smart way.

Checkout the hibernate.hbm2ddl.auto property and the values that it takes from the Hibernate Reference Doc. If you want a scheme created at the beginning of your test and deleted at the end, you might want to use the "create-drop" scheme.