The Ultimate Guide to High Availability with MariaDB

Comments - Restoring to mariadb10.1 fails the first time, but succeeds when restoring again after recreating the database

1 year, 5 months ago kosuke shinoda
Re: Restoring to mariadb10.1 fails the first time, but succeeds when restoring again after recreating the database [Answer]

solved. After executing mysql_update between restoring mysql and restoring databasename, the error disappeared. It seems that FLUSH PRIVILEGES was necessary after restoring mysql. thank you very much.

 
1 year, 5 months ago Ian Gilfillan
Re: Restoring to mariadb10.1 fails the first time, but succeeds when restoring again after recreating the database

Yes, mysql_upgrade (now mariadb-upgrade) is always required as part of the upgrade process. See Upgrading MariaDB.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.