How can I backup & restore the database? And is it possible to change PHP version as wish?

[bdkoder]

How can I backup & restore the database? And is it possible to change PHP version as wish?

[fsgreco]

Hi @bdkoder thanks for the question. So we you have a bunch of different paths of action here.

Regarding THE BACKUP:
Either you run an instance of phpmyadmin inside docker-compose.yml (then enter there and make the backup manually), or - if you fell confident - you can use a simple command from the shell, by taking advantage of the variables already inserted into docker-compose file you can tell it to use the db service to create a backup with mysqldump.

• For the first approach simple add this service on the docker-compose file:

  phpmyadmin:
    container_name: "php-my-admin"
    depends_on:
      - "db"
    image: phpmyadmin/phpmyadmin
    ports: 
      - "8081:80"
    environment:
      PMA_HOST: db

Then you can access to the php-my-admin interface at the localhost, port 8081.

• If you choose the second approach this simply command should work (I just tested it):

docker-compose exec db bash -c 'mysqldump -u root -p"$MYSQL_ROOT_PASSWORD" "$MYSQL_DATABASE" --skip-comments' > database-backup.sql

You should see the file database-backup.sql on the root of the project.

Beware that no matter the approach you choose, if you need to use this backup in production you will probably need to change some local values like the "host" and the "siteurl" values inside the `wp_options" table (when you work here they will be setted to "localhost:port_num").

As for RESTORING THE DB:
The most simple and easy way here (my preferred) is to kill the containers and then get rid of the volume linked to the database. This will force Mysql container to re apply the file sql file inside the folder /dump and you will have the db restored at the next docker-compose up.

Basically you can remove the volumes either with docker-compose down --volumes OR locate the volume manually:
docker volume ls and remove it docker volume rm VOL_NAME.

As for the PHP version:
Sure you can switch PHP version easily by changing it in the first line of the file Dockerfile.website:

FROM wordpress:php8.1-apache

Possible values could be found on the wordpress docker image tags: https://hub.docker.com/_/wordpress/tags
If you want to try php8.0 instead of 8.1 just change that line and then remove the image or forse the build.
e.g.

docker image rm fsg/wordpress:latest   
docker-compose up --build