Re: database problem update after upgrade to 15.0.2

--===============8205833548913995968==
Content-Type: multipart/alternative; boundary="0000000000000258910618b832e5"

--0000000000000258910618b832e5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, 18 May 2024 at 11:11, Ulrich Leodolter <[email protected]>
wrote:

> Hello Marcin,
>
> Thanks, this explains it pretty good.
>
> In the meantime I created a new datebase using make_mysql_tables and made
> a quick comparison of both schemas using mysqldump -d .
>
> I found some more (hopefully) minor differences (order of columns, int(11=
)
> vs. int(10) unsigned, missing indexes).   Not sure if everything is relat=
ed
> to bacula update scripts because we run bacula quite a long time and did =
a
> lot of bacula version updates, but also operating system and mysql/mariad=
b
> upgrades.
>

Hello Ulrich,

Great. Thanks for letting here know about it. It is useful.

Best regards,
Marcin Haba (gani)

--=20

"Greater love hath no man than this, that a man lay down his life for
his friends." Jesus Christ

"Wi=C4=99kszej mi=C5=82o=C5=9Bci nikt nie ma nad t=C4=99, jak gdy kto =C5=
=BCycie swoje k=C5=82adzie
za przyjaci=C3=B3=C5=82 swoich." Jezus Chrystus

--0000000000000258910618b832e5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, 18 May 2024 at 11:11, Ulrich Leod=
olter &lt;<a href=3D"mailto:[email protected]">ulrich.leodolter@obv=
sg.at</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div class=3D"msg8760806910863296782">




<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hello Marcin,</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Thanks, this explains it pretty good.</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
In the meantime I created a new datebase using make_mysql_tables and made a=
 quick comparison of both schemas using mysqldump -d .</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I found some more (hopefully) minor differences (order of columns, int(11) =
vs. int(10) unsigned, missing indexes).=C2=A0 =C2=A0Not sure if everything =
is related to bacula update scripts because we run bacula quite a long time=
 and did a lot of bacula version updates,
 but also operating system and mysql/mariadb upgrades.</div></div></div></b=
lockquote><div><br></div><div>Hello Ulrich,<br><br>Great. Thanks for lettin=
g here know about it. It is useful.<br><br>Best regards,<br>Marcin Haba (ga=
ni)<br></div><div>=C2=A0</div></div><span class=3D"gmail_signature_prefix">=
-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><=
pre>&quot;Greater love hath no man than this, that a man lay down his life =
for his friends.&quot; Jesus Christ

&quot;Wi=C4=99kszej mi=C5=82o=C5=9Bci nikt nie ma nad t=C4=99, jak gdy kto =
=C5=BCycie swoje k=C5=82adzie za przyjaci=C3=B3=C5=82 swoich.&quot; Jezus C=
hrystus</pre></div></div></div>

--0000000000000258910618b832e5--


--===============8205833548913995968==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============8205833548913995968==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

--===============8205833548913995968==--