nextcloud and mariadb docker containers update detailed
In this video I show how to upgrade nextcloud container and MariaDB container. The concept is the same for other containers. Any questions or video ideas drop them down in the comments. Thanks.
*Commands used in the video*
*To fix the error message that came up after upgrading
docker exec -it nextcloud occ db:add-missing-indices
*This export database (nextcloud-mariadb is my mariadb container name)
I can't put the angle bracket change to right facing bracket below refer to video. Sorry.
docker exec -it nextcloud-mariadb mysqldump -u root -p --all-databases ▶️ nextcloud-db-backup.sql
*To check database file after backing up
head -n 5 data-dump.sql
This is the command used to upgrade the database to newer version
(Change nextcloud-mariadb with your mariadb container name)
*docker exec -it nextcloud-mariadb mysql_upgrade -u root -p --force
0:00 Intro
1:00 Upgrading nextcloud container
5:56 Prep for upgrade mariadb container
8:22 Exporting mariadb database (safe measures)
13:09 mysql_upgrade
15:40 Checking nextcloud and mariadb
16:31 Checking and clearing logs (bonus footage)
15:36 Bonus content fixing administration settings