diff options
author | Pedro Alvarez <pedro.alvarez@codethink.co.uk> | 2015-11-04 17:29:55 +0000 |
---|---|---|
committer | Pedro Alvarez <pedro.alvarez@codethink.co.uk> | 2015-11-05 10:33:15 +0000 |
commit | 2a3dd7d51faf5082be834849230e9873f4ab0730 (patch) | |
tree | 7f8a20b3ddd664953d7b5413c80d6206e076b1cb | |
parent | 4ef2961609b77a3bedd5aa1999b70422acdc7536 (diff) | |
download | infrastructure-2a3dd7d51faf5082be834849230e9873f4ab0730.tar.gz |
README.mdwn: Add extra help for restoring database backups
Change-Id: I7266a4cc19bf7973089cca0e229ff73ba423b394
-rw-r--r-- | README.mdwn | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/README.mdwn b/README.mdwn index 38630a52..0950a648 100644 --- a/README.mdwn +++ b/README.mdwn @@ -237,6 +237,15 @@ are done. sudo systemctl enable mariadb.service sudo systemctl start mariadb.service +NOTE: If you see the following message in the journal: + + The datadir located at /var/lib/mysql needs to be upgraded using 'mysql_upgrade' tool. This can be done using the following steps + +This is because the backup you are importing is from an older version of +MariaDB. To fix this, as the message says, you only need to run: + + sudo -u mysql mysql_upgrade -u root -p + If you are starting from scratch, you need to prepare the system by adding the required users and databases. Run the following playbook, which can be altered and rerun whenever you need to add more users or databases, or |