maria-discuss team mailing list archive

Thread
Date

Re: New server, switch to MariaDB, different versions

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
Date: Sat, 27 Apr 2013 20:57:53 +0200
In-reply-to: <517C1ED7.2090001@libertytrek.org>
Openpgp: id=7F780279; url=http://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
Organization: the lounge interactive design
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130402 Thunderbird/17.0.5

Am 27.04.2013 20:54, schrieb Tanstaafl:
> I am setting up a shiny new virtualized (ESXi host) server, that now has MariaDB 5.5.30 on it...
> 
> My question is, can I do a dump from my old server running mysql 5.1.62, then restore that dump to my new server
> running MariaDB 5.5.30, run mysql_upgrade, and have any kind of reasonable expectation of it working?

why are you bothering with dumps?
this is not postgresql!

* stop mysqld on both machines
* rsync --force --delete-after --devices --specials -tPrlHpogEAX root@oldserver:/mdatadir/ /datadir/
* start mariadb on the new server
* mysql_upgrade
* done

and to save time use the rsync twice
a hot one while the old server is running and after stop the
old one a seond time to get the diffs quickly

Attachment: signature.asc
Description: OpenPGP digital signature

References

New server, switch to MariaDB, different versions
From: Tanstaafl, 2013-04-27