Duplicate HSQLDB - Export/Import from one instance to a new instance.
Ken Lemoine <[email protected]> Fri, 5 Jul 2024 16:45:02 +0000
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <SN6PR06MB4144B357B9F0B4790D83540F89DF2@SN6PR06MB4144.namprd06.prod.outlook.com> |
--===============7341423283983772121==
Content-Language: en-US
Content-Type: multipart/alternative;
boundary="_000_SN6PR06MB4144B357B9F0B4790D83540F89DF2SN6PR06MB4144namp_"
--_000_SN6PR06MB4144B357B9F0B4790D83540F89DF2SN6PR06MB4144namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
Apologies in advance if this has been asked before, I'm just not finding mu=
ch 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 onc=
e 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 mac=
hine, 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 machi=
ne 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
[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]
--_000_SN6PR06MB4144B357B9F0B4790D83540F89DF2SN6PR06MB4144namp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Hello,</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Apologies in advance if this has been asked before, I'm just not findi=
ng much information in the archives. </div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
We have a hsqldb instance that needs to be replicated to a secondary.&=
nbsp; I've tried and failed 3 different methods, mostly using the sqltool.j=
ar and once by simply copying over the hsql.script file and crossing my fin=
gers. The final attempt I just completed
does seemingly create a valid 'exporteddata.sql' file, I can see it in the=
re. Then when I import it on the second machine, it also seemingly im=
ports it - it outputs to stdout so I know it did SOMEthing. But, the =
data is not showing up in the application.</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
This is the latest hsqldb, running on latest FreeBSD 14. </div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
I'll also be needing a way of fully automating this, to keep a second machi=
ne 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=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Any tips or hints, or a point in the right direction would be apprecia=
ted. </div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Thanks!</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Ken</div>
<p><strong>Ken Lemoine</strong> | Deployment Manager</p>
<p>(614) 344-6500</p>
<p>www.cyberzek.com</p>
<img src=3D"https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4=
b5d091e73f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_aut=
o/CYBERZEK%20Logo%20-%20Color%20-%20Horizontal.png" width=3D"222" height=3D=
"50">
</body>
</html>
--_000_SN6PR06MB4144B357B9F0B4790D83540F89DF2SN6PR06MB4144namp_--
--===============7341423283983772121==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============7341423283983772121==
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
--===============7341423283983772121==--