[Maria-discuss] New server, switch to MariaDB, different versions
Hello, My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases: postfixadmin and roundcube 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? I'd rather not update the current (production) server to MariaDB (I'm gunshy when it comes to major changes on a production system). If not, then my other option would be to downgrade MariaDB on the new server to 5.1.66... but again, I'd rather not do that if it isn't necessary. Thanks - I'm really looking forward to saying goodbye to mysql (for political reasons, the software itself has served me well these 8 years, it's just too bad that they got bought by Oracle)... Charles
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
Hi, On 4/27/2013 10:54 PM, Tanstaafl wrote:
Hello,
My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases:
postfixadmin and roundcube
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?
Yes, it would be a very reasonable expectation. It's supposed to work. Regards, Elena
I'd rather not update the current (production) server to MariaDB (I'm gunshy when it comes to major changes on a production system).
If not, then my other option would be to downgrade MariaDB on the new server to 5.1.66... but again, I'd rather not do that if it isn't necessary.
Thanks - I'm really looking forward to saying goodbye to mysql (for political reasons, the software itself has served me well these 8 years, it's just too bad that they got bought by Oracle)...
Charles
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On 2013-04-27 4:25 PM, Elena Stepanova <elenst@montyprogram.com> wrote:
Hi,
On 4/27/2013 10:54 PM, Tanstaafl wrote:
Hello,
My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases:
postfixadmin and roundcube
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?
Yes, it would be a very reasonable expectation. It's supposed to work.
And it appears that it did... zarro errors when running mysql_update. :) Now to get everything else installed/configged... Thanks
participants (3)
-
Elena Stepanova -
Reindl Harald -
Tanstaafl