Re: Duplicate HSQLDB - Export/Import from one instance to a new instance.
Fred Toussi via Hsqldb-user <[email protected]> Wed, 10 Jul 2024 17:36:18 +0100
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
--===============8563274878808937199== Content-Type: multipart/alternative; boundary=395cfedbc2c64b2f88100b137e1b250d --395cfedbc2c64b2f88100b137e1b250d Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable There is no need for the Transfer Tool. You can create a dump of the database using the PERFORM EXPORT statement= . You can then use PERFORM IMPORT statement to load the dump into the cu= rrent database. If you want to sync only the changes in the primary database with the se= condary, enable system versioning for the tables. See the guide at http:= //hsqldb.org/doc/2.0/guide/management-chapt.html#mtc_system_versioned_ta= bles and the addtional description of the syntax in the Guide. Fred Toussi On Wed, Jul 10, 2024, at 15:37, Ken Lemoine wrote: > Thanks, I'm still unable to get a simple export to work using this tra= nsfer tool. Can anyone give me the command syntax? If the usage is onl= y --dump, how can I pass it the connection details and authentication (s= a) ? Is there a transfer tool documentation that explains all this in m= ore detail? >=20 > Here's roughly how I'm trying it now >=20 > java -cp hsqldbutil.jar org.hsqldb.util.Transfer jdbc:hsqldb:hsql:/pat= h/to/prod/db/hsql;user=3Dsa;password=3D --dump >=20 > *-bash: --dump: command not found* > ** > Same error. I'm stuck, any help would be appreciated. Thanks! >=20 > Sincerely, > Ken >=20 >=20 >=20 > *From:* Andrew Richardson <[email protected]> > *Sent:* Tuesday, July 9, 2024 7:14 AM > *To:* User discussions about HyperSQL Database Engine. <hsqldb-user@li= sts.sourceforge.net> > *Subject:* Re: [Hsqldb-user] Duplicate HSQLDB - Export/Import from one= instance to a new instance. > =20 > Per the help text, the tool only supports the switches specified. Thu= s the " --database1 jdbc:hsqldb:hsql:/path/to/prod/db/hsql;user=3Dsa;pas= sword=3D " text is a problem.=20 > Suspect command line use is not supported presently...you might need t= o add that support yourself, the source code is there. > I was able to get the dump file generated using the GUI, but did not t= ry the restore function. > I do not have any further input for you. =20 > Good luck with your project! >=20 > On Mon, Jul 8, 2024 at 8:59=E2=80=AFPM Ken Lemoine <ken.lemoine@cyberz= ek.com> wrote: >> Thanks for the timely response, Andrew. >>=20 >> I've got a shiny new transfer tool (hsqldbutil.jar) compiled and trie= d it every which way to no avail. >>=20 >> Here's my last attempt, with the response - I'm sure there's somethin= g I'm missing still. The hsqldbutil.jar is in my local directory. >>=20 >>> java -cp hsqldbutil.jar org.hsqldb.util.Transfer --database1 jdbc:hs= qldb:hsql:/path/to/prod/db/hsql;user=3Dsa;password=3D --dump >>=20 >> Wondering if I need to change the jdbc connection to use 'file' vice = 'hsql' since we're using a .script file, but I can't seem to get past th= is message, as if it doesn't know what the --dump parameter is: >>=20 >> *Exception in thread "main" java.lang.IllegalArgumentException: Try: = java org.hsqldb.util.Transfer --help* >> *=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82at org.hsqldb.= util.Transfer.main(Unknown Source)* >> *-bash: --dump: command not found* >>=20 >>=20 >> All the --help gives me is the usage (-help,-dump,-restore). It also= seems to sometimes complain of the lack of X11 since it can also be run= graphically, but I do not want that, the goal here is to have a script = that can export data frequently, xfer it to another machine and have ano= ther script to import it. >>=20 >> Appreciate any help you can provide, and happy Monday! >>=20 >> Regards,=20 >>=20 >>=20 >> *From:* Andrew Richardson <[email protected]> >> *Sent:* Saturday, July 6, 2024 1:57 PM >> *To:* User discussions about HyperSQL Database Engine. <hsqldb-user@l= ists.sourceforge.net> >> *Subject:* Re: [Hsqldb-user] Duplicate HSQLDB - Export/Import from on= e instance to a new instance. >> =20 >> Hello again <sorry for the spam> >> Out of curiosity, I looked into how to generate the Transfer Tool. H= ere is what worked for me on Windows. >>=20 >> cd hsqldb-2.7.3\hsqldb\build >> gradlew hsqldbutil >> java -cp ..\lib\hsqldbutil.jar org.hsqldb.util.Transfer --dump >>=20 >> Maybe this saves you a little time. >> Cheers! >>=20 >> On Sat, Jul 6, 2024 at 12:59=E2=80=AFPM Andrew Richardson <spun69@gma= il.com> wrote: >>> Hello Ken >>> Not sure if this will cover all your requirements, but have a look a= t the "Transfer Tool" utility. Might be a place to start. >>> https://hsqldb.org/doc/2.0/util-guide/transfer-tool-chapt.html >>>=20 >>> Cheers, >>> Andrew Richardson >>>=20 >>> On Fri, Jul 5, 2024 at 4:18=E2=80=AFPM Ken Lemoine <ken.lemoine@cybe= rzek.com> wrote: >>>> Hello, >>>>=20 >>>> Apologies in advance if this has been asked before, I'm just not fi= nding much information in the archives.=20 >>>>=20 >>>> We have a hsqldb instance that needs to be replicated to a secondar= y. 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 va= lid '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 s= tdout so I know it did SOMEthing. But, the data is not showing up in th= e application. >>>>=20 >>>> This is the latest hsqldb, running on latest FreeBSD 14. =20 >>>>=20 >>>> I'll also be needing a way of fully automating this, to keep a seco= nd machine up to date, and have struggled also getting a script to do th= is, but at this point, I really just want to see if I can get this worki= ng manually. >>>>=20 >>>> Any tips or hints, or a point in the right direction would be appre= ciated. =20 >>>>=20 >>>> Thanks! >>>>=20 >>>> Ken >>>> *Ken Lemoine* | Deployment Manager >>>>=20 >>>> (614) 344-6500 >>>>=20 >>>> www.cyberzek.com >>>>=20 >>>>=20 >>>> _______________________________________________ >>>> Hsqldb-user mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user >> *Ken Lemoine* | Deployment Manager >>=20 >> (614) 344-6500 >>=20 >> www.cyberzek.com >>=20 >>=20 >> _______________________________________________ >> Hsqldb-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/hsqldb-user > *Ken Lemoine* | Deployment Manager >=20 > (614) 344-6500 >=20 > www.cyberzek.com >=20 >=20 >=20 > _______________________________________________ > Hsqldb-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hsqldb-user >=20 --395cfedbc2c64b2f88100b137e1b250d Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: quoted-printable <!DOCTYPE html><html><head><title></title><style type=3D"text/css">#qt P= {margin-top:0px;margin-bottom:0px;} p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div style=3D"f= ont-family:Arial;">There is no need for the Transfer Tool.<br></div><div= style=3D"font-family:Arial;"><br></div><div style=3D"font-family:Arial;= ">You can create a dump of the database using the PERFORM EXPORT stateme= nt. You can then use PERFORM IMPORT statement to load the dump into the = current database.<br></div><div style=3D"font-family:Arial;"><br></div><= div style=3D"font-family:Arial;">If you want to sync only the changes in= the primary database with the secondary, enable system versioning for t= he tables. See the guide at <a href=3D"http://hsqldb.org/doc/2.0/guide/m= anagement-chapt.html#mtc_system_versioned_tables">http://hsqldb.org/doc/= 2.0/guide/management-chapt.html#mtc_system_versioned_tables</a> and the = addtional description of the syntax in the Guide.<br></div><div style=3D= "font-family:Arial;"><br></div><div style=3D"font-family:Arial;">Fred To= ussi<br></div><div style=3D"font-family:Arial;"><br></div><div>On Wed, J= ul 10, 2024, at 15:37, Ken Lemoine wrote:<br></div><blockquote type=3D"c= ite" id=3D"qt" style=3D""><div class=3D"qt-elementToProof" style=3D"font= -family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helveti= ca, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Thanks, I'm still una= ble to get a simple export to work using this transfer tool. Can a= nyone give me the command syntax? If the usage is only --dump, how= can I pass it the connection details and authentication (sa) ? Is= there a transfer tool documentation that explains all this in more detail?<br></div><div class=3D"qt-elemen= tToProof" style=3D"font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontSe= rvice, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);= "><br></div><div class=3D"qt-elementToProof" style=3D"font-family:Aptos,= Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif= ;font-size:12pt;color:rgb(0, 0, 0);">Here's roughly how I'm trying it no= w<br></div><div class=3D"qt-elementToProof" style=3D"font-family:Aptos, = Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;= font-size:12pt;color:rgb(0, 0, 0);"><br></div><div class=3D"qt-elementTo= Proof" style=3D"font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi= ce, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">j= ava -cp hsqldbutil.jar org.hsqldb.util.Transfer jdbc:hsqldb:hsql:/path/t= o/prod/db/hsql;user=3Dsa;password=3D --dump<br></div><div class=3D= "qt-elementToProof" style=3D"font-family:Aptos, Aptos_EmbeddedFont, Apto= s_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb= (0, 0, 0);"><br></div><div class=3D"qt-elementToProof" style=3D"font-fam= ily:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, = sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><b>-bash: --dump: command= not found</b><br></div><div class=3D"qt-elementToProof" style=3D"font-f= amily:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica= , sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><b></b><br></div><div c= lass=3D"qt-elementToProof" style=3D"font-family:Aptos, Aptos_EmbeddedFon= t, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;co= lor:rgb(0, 0, 0);">Same error. I'm stuck, any help would be appreci= ated. Thanks!<br></div><div class=3D"qt-elementToProof" style=3D"f= ont-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helv= etica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><div cla= ss=3D"qt-elementToProof" style=3D"font-family:Aptos, Aptos_EmbeddedFont,= Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;colo= r:rgb(0, 0, 0);">Sincerely,<br></div><div class=3D"qt-elementToProof" st= yle=3D"font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calib= ri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Ken<br></d= iv><div id=3D"qt-appendonsend"><br></div><div style=3D"font-family:Aptos= , Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-seri= f;font-size:12pt;color:rgb(0, 0, 0);"><br></div><div><hr style=3D"displa= y:inline-block;width:98%;"><br></div><div id=3D"qt-divRplyFwdMsg" dir=3D= "ltr"><div><span style=3D"color:rgb(0, 0, 0);"><span class=3D"font" styl= e=3D"font-family:Calibri, sans-serif;"><span class=3D"size" style=3D"fon= t-size:11pt;"><b>From:</b> Andrew Richardson <[email protected]&g= t;<br> <b>Sent:</b> Tuesday, July 9, 2024 7:14 AM<br> <b>To:</b>&nb= sp;User discussions about HyperSQL Database Engine. <hsqldb-user@list= s.sourceforge.net><br> <b>Subject:</b> Re: [Hsqldb-user] Duplica= te HSQLDB - Export/Import from one instance to a new instance.</span></s= pan></span></div><div> <br></div></div><div style=3D"direction:ltr;= ">Per the help text, the tool only supports the switches specified. = ; Thus the " --database1 jdbc:hsqldb:hsql:/path/to/prod/db/hsql;user=3Ds= a;password=3D " text is a problem. <br></div><div style=3D"directio= n:ltr;">Suspect command line use is not supported presently...you might = need to add that support yourself, the source code is there.<br></div><d= iv style=3D"direction:ltr;">I was able to get the dump file generated us= ing the GUI, but did not try the restore function.<br></div><div style=3D= "direction:ltr;">I do not have any further input for you. <br= ></div><div style=3D"direction:ltr;">Good luck with your project!<br></d= iv><div><br></div><div style=3D"direction:ltr;">On Mon, Jul 8, 2024 at 8= :59=E2=80=AFPM Ken Lemoine <<a href=3D"mailto:[email protected]= m" id=3D"qt-OWAe1070568-43cb-c428-8746-3214a587bb3f" class=3D"qt-OWAAuto= Link">[email protected]</a>> wrote:<br></div><blockquote style= =3D"margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;= padding-left:1ex;border-left-color:rgb(204, 204, 204);border-left-style:= solid;border-left-width:1px;"><div style=3D"direction:ltr;font-family:Ap= tos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-s= erif;font-size:12pt;color:rgb(0, 0, 0);">Thanks for the timely response,= Andrew.<br></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_E= mbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-si= ze:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction:ltr;font-= family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetic= a, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">I've got a shiny new t= ransfer tool (hsqldbutil.jar) compiled and tried it every which way to n= o avail.<br></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_E= mbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-si= ze:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction:ltr;font-= family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetic= a, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Here's my last attempt= , with the response - I'm sure there's something I'm missing still. The = hsqldbutil.jar is in my local directory.<br></div><div style=3D"directio= n:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibr= i, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><= blockquote style=3D"margin-left:0.8ex;padding-left:1ex;border-left-color= :rgb(200, 200, 200);border-left-style:solid;border-left-width:3px;"><div= style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSF= ontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0= , 0);">java -cp hsqldbutil.jar org.hsqldb.util.Transfer --database1 jdbc= :hsqldb:hsql:/path/to/prod/db/hsql;user=3Dsa;password=3D --dump<br= ></div></blockquote><div style=3D"direction:ltr;font-family:Aptos, Aptos= _EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-= size:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction:ltr;fon= t-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvet= ica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Wondering if I need = to change the jdbc connection to use 'file' vice 'hsql' since we're usin= g a .script file, but I can't seem to get past this message, as if it do= esn't know what the --dump parameter is:<br></div><div style=3D"directio= n:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibr= i, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><= div style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_= MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0= , 0, 0);"><b>Exception in thread "main" java.lang.IllegalArgumentExcepti= on: Try: java org.hsqldb.util.Transfer --help</b><br></div><div st= yle=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFont= Service, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0= );"><b>=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82=E2=80=82at org.hsql= db.util.Transfer.main(Unknown Source)</b><br></div><div style=3D"directi= on:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calib= ri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><b>-bash: = --dump: command not found</b><br></div><div id=3D"qt-x_m_317234252140516= 1930appendonsend"><br></div><div style=3D"direction:ltr;font-family:Apto= s, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-ser= if;font-size:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction= :ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri= , Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">All the --he= lp gives me is the usage (-help,-dump,-restore). It also seems to = sometimes complain of the lack of X11 since it can also be run graphical= ly, but I do not want that, the goal here is to have a script that can e= xport data frequently, xfer it to another machine and have another script to import it.<br></div><div sty= le=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontS= ervice, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0)= ;"><br></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_Embedd= edFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12= pt;color:rgb(0, 0, 0);">Appreciate any help you can provide, and ha= ppy Monday!<br></div><div style=3D"direction:ltr;font-family:Aptos, Apto= s_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font= -size:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction:ltr;fo= nt-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helve= tica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Regards, <br><= /div><div style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, = Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color= :rgb(0, 0, 0);"><br></div><div><hr style=3D"direction:ltr;display:inline= -block;width:98%;"><br></div><div id=3D"qt-x_m_3172342521405161930divRpl= yFwdMsg" dir=3D"ltr"><div><span style=3D"color:rgb(0, 0, 0);"><span clas= s=3D"font" style=3D"font-family:Calibri, sans-serif;"><span class=3D"siz= e" style=3D"font-size:11pt;"><b>From:</b> Andrew Richardson <<a = href=3D"mailto:[email protected]" id=3D"qt-OWA92c47bb2-8963-9ea7-0d2c-90f= 20b2e8e1e" class=3D"qt-OWAAutoLink">[email protected]</a>><br> <b>Sent= :</b> Saturday, July 6, 2024 1:57 PM<br> <b>To:</b> User discu= ssions about HyperSQL Database Engine. <<a href=3D"mailto:hsqldb-user= @lists.sourceforge.net" id=3D"qt-OWA9df178c1-42b4-4152-9e35-013f26262346= " class=3D"qt-OWAAutoLink">[email protected]</a>><br>= <b>Subject:</b> Re: [Hsqldb-user] Duplicate HSQLDB - Export/Import= from one instance to a new instance.</span></span></span></div><div>&nb= sp;<br></div></div><div style=3D"direction:ltr;">Hello again <sorry f= or the spam><br></div><div style=3D"direction:ltr;">Out of curiosity,= I looked into how to generate the Transfer Tool. Here is what wor= ked for me on Windows.<br></div><div style=3D"direction:ltr;margin-left:= 40px;"><br></div><div style=3D"direction:ltr;margin-left:40px;"><div>cd = hsqldb-2.7.3\hsqldb\build<br></div><div> gradlew hsqldbutil<br></div><di= v> java -cp ..\lib\hsqldbutil.jar org.hsqldb.util.Transfer --dump<br></d= iv></div><div style=3D"direction:ltr;"><br></div><div style=3D"direction= :ltr;">Maybe this saves you a little time.<br></div><div style=3D"direct= ion:ltr;">Cheers!<br></div><div style=3D"direction:ltr;"><br></div><div = style=3D"direction:ltr;">On Sat, Jul 6, 2024 at 12:59=E2=80=AFPM Andrew = Richardson <<a href=3D"mailto:[email protected]" id=3D"qt-OWA7fd106bd-= 4ade-54a6-18fc-083f18a5ee1a" class=3D"qt-OWAAutoLink">[email protected]</= a>> wrote:<br></div><blockquote style=3D"margin-top:0px;margin-right:= 0px;margin-bottom:0px;margin-left:0.8ex;padding-left:1ex;border-left-col= or:rgb(204, 204, 204);border-left-style:solid;border-left-width:1px;"><d= iv style=3D"direction:ltr;">Hello Ken<br></div><div style=3D"direction:l= tr;">Not sure if this will cover all your requirements, but have a look = at the "Transfer Tool" utility. Might be a place to start.<br></di= v><div style=3D"direction:ltr;"><a href=3D"https://hsqldb.org/doc/2.0/ut= il-guide/transfer-tool-chapt.html" id=3D"qt-OWA9519d58d-a7ce-846b-1b7e-0= 431bf4c75f9" class=3D"qt-OWAAutoLink">https://hsqldb.org/doc/2.0/util-gu= ide/transfer-tool-chapt.html</a><br></div><div style=3D"direction:ltr;">= <br></div><div style=3D"direction:ltr;">Cheers,<br></div><div style=3D"d= irection:ltr;">Andrew Richardson<br></div><div style=3D"direction:ltr;">= <br></div><div style=3D"direction:ltr;">On Fri, Jul 5, 2024 at 4:18=E2=80= =AFPM Ken Lemoine <<a href=3D"mailto:[email protected]" id=3D"= qt-OWAec270083-2f07-a6f1-d81f-cfba6bda62d9" class=3D"qt-OWAAutoLink">ken= [email protected]</a>> wrote:<br></div><blockquote style=3D"margi= n-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;padding-l= eft:1ex;border-left-color:rgb(204, 204, 204);border-left-style:solid;bor= der-left-width:1px;"><div style=3D"direction:ltr;font-family:Aptos, Apto= s_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font= -size:12pt;color:rgb(0, 0, 0);">Hello,<br></div><div style=3D"direction:= ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri,= Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><di= v style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MS= FontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, = 0, 0);">Apologies in advance if this has been asked before, I'm jus= t not finding much information in the archives. <br></div><div styl= e=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontSe= rvice, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);= "><br></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_Embedde= dFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12p= t;color:rgb(0, 0, 0);">We have a hsqldb instance that needs to be r= eplicated to a secondary. I've tried and failed 3 different method= s, mostly using the sqltool.jar and once by simply copying over the hsql= .script file and crossing my fingers. The final attempt I just com= pleted 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 seemin= gly imports it - it outputs to stdout so I know it did SOMEthing. = But, the data is not showing up in the application.<br></div><div style=3D= "direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontServic= e, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><b= r></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFon= t, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;co= lor:rgb(0, 0, 0);">This is the latest hsqldb, running on latest FreeBSD = 14. <br></div><div style=3D"direction:ltr;font-family:Aptos, = Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;= font-size:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D"direction:lt= r;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, H= elvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">I'll also be ne= eding a way of fully automating this, to keep a second machine up to dat= e, and have struggled also getting a script to do this, but at this poin= t, I really just want to see if I can get this working manually.<br></di= v><div style=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Apt= os_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rg= b(0, 0, 0);"><br></div><div style=3D"direction:ltr;font-family:Aptos, Ap= tos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;fo= nt-size:12pt;color:rgb(0, 0, 0);">Any tips or hints, or a point in the r= ight direction would be appreciated. <br></div><div styl= e=3D"direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontSe= rvice, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);= "><br></div><div style=3D"direction:ltr;font-family:Aptos, Aptos_Embedde= dFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12p= t;color:rgb(0, 0, 0);">Thanks!<br></div><div style=3D"direction:ltr;font= -family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helveti= ca, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><div style=3D= "direction:ltr;font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontServic= e, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Ke= n<br></div><p style=3D"direction:ltr;"><b>Ken Lemoine</b> | Deploym= ent Manager<br></p><p style=3D"direction:ltr;">(614) 344-6500<br></p><p = style=3D"direction:ltr;"><a href=3D"http://www.cyberzek.com" id=3D"qt-OW= A6dc2e0a9-459d-ed74-0e1d-1dedf72cbb12" class=3D"qt-OWAAutoLink" style=3D= "margin-top:0px;margin-bottom:0px;">www.cyberzek.com</a><br></p><div sty= le=3D"direction:ltr;"><span><img style=3D"width:222px;height:50px;" src=3D= "https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4b5d091e7= 3f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/CYB= ERZEK%20Logo%20-%20Color%20-%20Horizontal.png" width=3D"222" height=3D"5= 0"></span><br></div><div style=3D"direction:ltr;"><div>_________________= ______________________________<br></div><div> Hsqldb-user mailing list<b= r></div><div> <a href=3D"mailto:[email protected]" id=3D= "qt-OWA947c8451-bb93-726f-a832-6f1298dc2b97" class=3D"qt-OWAAutoLink">Hs= [email protected]</a><br></div><div> <a href=3D"https://li= sts.sourceforge.net/lists/listinfo/hsqldb-user" id=3D"qt-OWAc1fb859b-6e3= b-e879-9aa2-fbdaaf21734b" class=3D"qt-OWAAutoLink">https://lists.sourcef= orge.net/lists/listinfo/hsqldb-user</a><br></div></div></blockquote></bl= ockquote><p style=3D"direction:ltr;"><b>Ken Lemoine</b> | Deploymen= t Manager<br></p><p style=3D"direction:ltr;">(614) 344-6500<br></p><p st= yle=3D"direction:ltr;"><a href=3D"http://www.cyberzek.com" id=3D"qt-OWA1= 52b2acb-244d-8b69-c0ff-4c66e7e5a593" class=3D"qt-OWAAutoLink" style=3D"m= argin-top:0px;margin-bottom:0px;">www.cyberzek.com</a><br></p><div style= =3D"direction:ltr;"><span><img style=3D"width:222px;height:50px;" src=3D= "https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4b5d091e7= 3f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/CYB= ERZEK%20Logo%20-%20Color%20-%20Horizontal.png" width=3D"222" height=3D"5= 0"></span><br></div><div>_______________________________________________= <br></div><div> Hsqldb-user mailing list<br></div><div> <a href=3D"mailt= o:[email protected]" id=3D"qt-OWA875b3fd9-8a30-ab51-f4dd= -f485413452c4" class=3D"qt-OWAAutoLink">[email protected]= t</a><br></div><div> <a href=3D"https://lists.sourceforge.net/lists/list= info/hsqldb-user" id=3D"qt-OWA16c87203-68c8-1b63-d8fe-8c7898a5e7cf" clas= s=3D"qt-OWAAutoLink">https://lists.sourceforge.net/lists/listinfo/hsqldb= -user</a><br></div></blockquote><p><b>Ken Lemoine</b> | Deployment Manag= er<br></p><p>(614) 344-6500<br></p><p>www.cyberzek.com<br></p><div><img = src=3D"https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4b5= d091e73f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_au= to/CYBERZEK%20Logo%20-%20Color%20-%20Horizontal.png" width=3D"222" heigh= t=3D"50"><br></div><div><br></div><div>_________________________________= ______________<br></div><div>Hsqldb-user mailing list<br></div><div><a h= ref=3D"mailto:[email protected]">[email protected]= eforge.net</a><br></div><div><a href=3D"https://lists.sourceforge.net/li= sts/listinfo/hsqldb-user">https://lists.sourceforge.net/lists/listinfo/h= sqldb-user</a><br></div><div><br></div></blockquote><div style=3D"font-f= amily:Arial;"><br></div></body></html> --395cfedbc2c64b2f88100b137e1b250d-- --===============8563274878808937199== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============8563274878808937199== 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 --===============8563274878808937199==--