Re: Duplicate HSQLDB - Export/Import from one instance to a new instance.
David Anonymous Denny <[email protected]> Mon, 8 Jul 2024 17:03:27 -0500
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============1255361571948978733==
Content-Type: multipart/alternative;
boundary="------------S8MxB0Qcrenix0Muels90GPX"
Content-Language: en-GB
This is a multi-part message in MIME format.
--------------S8MxB0Qcrenix0Muels90GPX
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
I've been trying to do something similar, generate a standalone db for
offline access.
So I want to look into this conversation. If I get anywhere ("take a
seat") I'll post any results.
THANKS for the post & responses
David
On 5/07/2024 11:45, Ken Lemoine wrote:
> Hello,
>
> Apologies in advance if this has been asked before, I'm just not
> finding much information in the archives.
>
> We have a hsqldb instance that needs to be replicated to a secondary.
> I've tried and failed 3 different methods, mostly using the
> sqltool.jar and once by simply copying over the hsql.script file and
> crossing my fingers. The final attempt I just completed does
> seemingly create a valid 'exporteddata.sql' file, I can see it in
> there. Then when I import it on the second machine, it also seemingly
> imports it - it outputs to stdout so I know it did SOMEthing. But,
> the data is not showing up in the application.
>
> This is the latest hsqldb, running on latest FreeBSD 14.
>
> I'll also be needing a way of fully automating this, to keep a second
> machine up to date, and have struggled also getting a script to do
> this, but at this point, I really just want to see if I can get this
> working manually.
>
> Any tips or hints, or a point in the right direction would
> be appreciated.
>
> Thanks!
>
> Ken
>
> *Ken Lemoine* | Deployment Manager
>
> (614) 344-6500
>
> www.cyberzek.com
>
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--------------S8MxB0Qcrenix0Muels90GPX
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I've been trying to do something similar, generate a standalone
db for offline access.<br>
<br>
So I want to look into this conversation. If I get anywhere ("take
a seat") I'll post any results.<br>
<br>
THANKS for the post & responses<br>
David</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 5/07/2024 11:45, Ken Lemoine wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SN6PR06MB4144B357B9F0B4790D83540F89DF2@SN6PR06MB4144.namprd06.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello,</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Apologies in advance if this has been asked before, I'm just not
finding much information in the archives. </div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
We have a hsqldb instance that needs to be replicated to a
secondary. I've tried and failed 3 different methods, mostly
using the sqltool.jar and once by simply copying over the
hsql.script file and crossing my fingers. The final attempt I
just completed does seemingly create a valid 'exporteddata.sql'
file, I can see it in there. Then when I import it on the
second machine, it also seemingly imports it - it outputs to
stdout so I know it did SOMEthing. But, the data is not showing
up in the application.</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
This is the latest hsqldb, running on latest FreeBSD 14. </div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I'll also be needing a way of fully automating this, to keep a
second machine up to date, and have struggled also getting a
script to do this, but at this point, I really just want to see
if I can get this working manually.</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Any tips or hints, or a point in the right direction would
be appreciated. </div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks!</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Ken</div>
<p><strong>Ken Lemoine</strong> | Deployment Manager</p>
<p>(614) 344-6500</p>
<p><a class="moz-txt-link-abbreviated" href="http://www.cyberzek.com">www.cyberzek.com</a></p>
<img
src="https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4b5d091e73f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/CYBERZEK%20Logo%20-%20Color%20-%20Horizontal.png"
moz-do-not-send="true" width="222" height="50">
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Hsqldb-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a>
</pre>
</blockquote>
</body>
</html>
--------------S8MxB0Qcrenix0Muels90GPX--
--===============1255361571948978733==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============1255361571948978733==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--===============1255361571948978733==--