H2 Database - Backup
Donald Green
0
32
BACKUP is a command used to back up a database to a separate .zip file. Objects are not locked, and when a backup is performed, the transaction log is also copied. Administrator rights are required to run this command.
Syntax
Following is the general syntax of the backup command.
BACKUP TO fileNameString;
example
In this example, let's take a backup of the current database into a backup.zip file . Use the following command for the same.
BACKUP TO 'backup.zip' ;
By running the above command, you will get a backup.zip file on your local file system.
