Hello. H2 can export a database in two formats.
1. Regular backup (BACKUP TO 'filename.zip'). You can unpack the generated archive and use it as a database. 2. Export format (SCRIPT TO 'filename.sql'). You can execute it in a new empty database with RUNSCRIPT FROM 'filename.sql'. So you need to delete an existing database. If the database is not damaged and you have an active connection to it, you can execute SET EXCLUSIVE 2; DROP ALL OBJECTS; RUNSCRIPT FROM 'filename.sql'; SET EXCLUSIVE 0; You don't need to go to the exclusive mode and back if you don't have other connections. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1f382994-4992-4cea-bd0e-0c4c106bf787%40googlegroups.com.