How to export and restore HSQLDB

database export hsqldb restore
user1036817 picture user1036817 · Nov 9, 2011 · Viewed 16.1k times · Source

Does anyone know how to export HSQLDB to .sql file or something on a computer and restore on other computer.

Answer

Nkembe Gwankgo picture Nkembe Gwankgo · Sep 3, 2012

To get a dump of the hsqldb file using either the embedded or file/server mode.

In an sql tools dialog use:

SCRIPT 'c:\path\to\db\db_sql.sql';

This will not work with spaces in the path

Please see the hsqldb docs

Related questions

Export Postgresql table data using pgAdmin

I am using pgAdmin version 1.14.3. PostgreSQL database version is 9.1. I got all Db script for table creation but unable to export all data inside tables. Could not find any option to export data in db script form.

Read More
Export database schema into SQL file

Is it possible in MS SQL Server 2008 to export database structure into a T-SQL file? I want to export not only tables schema but also primary keys, foreign keys, constraints, indexes, stored procedures, user defined types/functions. Also I don't …

Read More
Can't export my database from mysql workbench

I am trying to export my database from MySQL Workbench but I get this during the export progress: Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmp2h91wa.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=…

Read More