search

mysugar / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Documentation improvement on the Backup To command (instructions on how to restore) #424

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 

The backup documentation is unclear as to how to restore the data from the 
newly backed up zip file.  Please add a paragraph stating that the backed up 
database is inside the zip file, and accessible using a URL similar to the 
following:
jdbc:h2:zip:<backupfile.zip>!/<original db>

Example:
if the original DB name is mydb (e.g. jdbc:h2:mydb), and the following command 
is executed:
backup to 'backup.zip'

Then, to access the backed up data, a new connection can be created using the 
following URL:
jdbc:h2:zip:backup.zip!/mydb

I spent a little while googling around until I opened the zip file, and saw the 
original DB.  I hope this helps save people's time in the future.

Original issue reported on code.google.com by lmart...@pontusnetworks.com on 25 Oct 2012 at 11:08

GoogleCodeExporter commented 9 years ago 
To restore a backup, use the Restore tool. This is documented.

Accessing the zip file directly is documented as well, but it is not a 
mechanism to restore it.

Original comment by thomas.t...@gmail.com on 30 Nov 2012 at 6:56