Re: [arch-general] Mariadb Tables Still Compatible with Backup Server Running Earlier Version?

2019-06-28 Thread Christian Hesse
"David C. Rankin"  on Thu, 2019/06/27 21:29:
> This is more a general question following the mariadb feature update to
> 10.4.6-1. Do the tables remain compatible with servers running earlier
> versions of mariadb?

You should not expect the binary format to be compatible.

> What happens if a backup from an earlier version has to be rolled into the
> new version?

That should work without problem. Just make sure to run mariadb-upgrade again.

> Or more importantly, can a backup from the new version be used to update
> servers running earlier versions of mariadb?

This should be handled with care. Most dumps should work - as long as you do
not use features not available in earlier versions.
You should *not* restore the mysql schema into an older server.

> (I have the same database running on Arch with backup handled by openSuSE,
> still running 10.0.35)

Hmm... Wondering what this means. You run mysqldump from an openSuSE system
or is the older mariadb server involved?
-- 
main(a){char*c=/*Schoene Gruesse */"B?IJj;MEH"
"CX:;",b;for(a/*Best regards my address:*/=0;b=c[a++];)
putchar(b-1/(/*Chriscc -ox -xc - && ./x*/b/42*2-3)*42);}


pgp5GHig8yto6.pgp
Description: OpenPGP digital signature


[arch-general] Mariadb Tables Still Compatible with Backup Server Running Earlier Version?

2019-06-27 Thread David C. Rankin
This is more a general question following the mariadb feature update to
10.4.6-1. Do the tables remain compatible with servers running earlier
versions of mariadb?

What happens if a backup from an earlier version has to be rolled into the new
version?

Or more importantly, can a backup from the new version be used to update
servers running earlier versions of mariadb?

(I have the same database running on Arch with backup handled by openSuSE,
still running 10.0.35)

https://wiki.archlinux.org/index.php/MariaDB doesn't mention anything special.
Nor does https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/

Any help or comment would be appreciated.


-- 
David C. Rankin, J.D.,P.E.