CODEWITHSUNDEEP
javasqlhsqldb
ALV
ALV

Reputation: 569

Backup and restore of Hsqldb database through java code

I am new in Hsqldb database. I want to know how to take backup and restore of hsqldb database through java code.Please suggest answer.

Upvotes: 4

Views: 1603

Answers (1)

fredt
fredt

Reputation: 24352

If you want to perform the backup while database is being used, you use an SQL command like this:

BACKUP DATABASE TO ...

To restore the database, you use the main() method of the org.hsqldb.tar.DbBackup or org.hsqldb.tar.DbBackupMain (version 2.3.2 or later) depending on the version of HSQLDB.

The commands are explained here:

http://www.hsqldb.org/doc/2.0/guide/management-chapt.html#mtc_backup

Upvotes: 1

Related Questions