I have some questions about H2DB. I have H2DB database which stores data in files, I have 3 files test.18.log.db, test.data.db, test.index.db. I want get sql dump file like when I use mysqldump. Is it possible?
相关问题
- Analyzing Outlook HANG dump (with GoogleCalendarSy
- H2 database: clustered indexes support
- Generate dump with unmanaged code crash?
- How to run 2 SQL “SELECT”s atomically? Or any othe
- Can you create multiple catalogs in H2?
相关文章
- 小型数据库(SQLite,Derby,H2)可以存储多少数据?
- Can I selectively create a backup of Postgres data
- SQL Dump from DB2
- Setup password for H2
- Any ideas for persisting H2 Database In-Memory mod
- How to write sql query whose conditions are option
- Dumping CLOB fields into files?
- GDB cannot show the stack and shows “#1 0x00000000
Yes, there are multiple solutions. One is to run the SCRIPT SQL statement:
Another is to use the Script tool:
Then, there are also the RUNSCRIPT statement and RunScript tool.
By the way, you should consider upgrading to a more recent version of H2. With newer versions, the two files .data.db and .index.db are combined in to a .h2.db file.