java - 恢复h2数据库

Question

我已将 h2 数据库用于基于桌面的应用程序(使用 swing)。我还备份了它并将其存储在我的文件系统中，扩展名为“.h2.db”。这不是一个可读文件。那么如何恢复我的 h2 备份文件呢？

Answer 1

建议使用特定工具创建 ZIP 文件。也应该可以在复制的文件上使用该工具:

The recommended way to backup a database is to create a compressed SQL script file. This will result in a small, human readable, and database version independent backup. Creating the script will also verify the checksums of the database file. The Script tool is ran as follows:
java org.h2.tools.Script -url jdbc:h2:~/test -user sa -script test.zip -options compression zip

然后可以使用 ZIP 文件来恢复数据库:

To restore a database from a SQL script file, you can use the RunScript tool:
java org.h2.tools.RunScript -url jdbc:h2:~/test -user sa -script test.zip -options compression zip

http://h2database.com/html/tutorial.html#upgrade_backup_restore