Re: Mariadb Tables Still Compatible with Backup Server Running Earlier Version?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



"David C. Rankin" <drankinatty@xxxxxxxxxxxxxxxxxx> 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/(/*    Chris            cc -ox -xc - && ./x    */b/42*2-3)*42);}

Attachment: pgp8cjLJPL9tn.pgp
Description: OpenPGP digital signature


[Index of Archives]     [Linux Wireless]     [Linux Kernel]     [ATH6KL]     [Linux Bluetooth]     [Linux Netdev]     [Kernel Newbies]     [Share Photos]     [IDE]     [Security]     [Git]     [Netfilter]     [Bugtraq]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Linux ATA RAID]     [Samba]     [Device Mapper]

  Powered by Linux