[BlueOnyx:20520] Re: MariaDB database migration

Michael Aronoff maronoff at gmail.com
Sun Jan 15 05:16:42 -05 2017


That is all for older CentOS versions too. With CentOS 7 and MariaDB many of
the commands change.

I was able to figure it out.

For anyone else who needs them, the important changes are as follows:
To start, stop or get status for MariaDB
systemctl stop mariadb
systemctl start mariadb
systemctl status mariadb

Then when you import your databases you will probably need to "upgrade" them
is you are not coming from another 5209R running the same MariaDB version.
This is done with:
mysql_upgrade -prootpass
(replace rootpass with your root password for MySQL from the old server)

The upgrade was the biggest problem but I had been stupid. When you check
the status of MariaDB after trying to start it, it tells you to do that sort
of. Michael, you might want to add that to the instructions at 
http://www.blueonyx.it/index.php?page=cmu-migrations

Thanks,
______________________________
M Aronoff Out




More information about the Blueonyx mailing list