Guidance on restoring mariabackup #390

rvernica · 2021-09-04T01:32:35Z

Assuming a common setup with /var/lib/mysql in a separate volume, some guidance would be helpful on how to restore a backup made mariabackup. The fist step is to stop MariaDB but that kills the container as well. Ideally, the restore would be done using the same Docker image (but not necessarily the same container) as the one running the MariaDB since I has the exact MariaDB version corresponding to the backup. The guidance should not assume that mariabackup is available on the host.

The text was updated successfully, but these errors were encountered:

grooverdan · 2021-09-04T02:21:36Z

You're right. Its a little lacking in documentation:

How does this look as some steps:

The backup:

$ podman volume create mdbdata
mdbdata

$ podman volume create mdbbackup
mdbbackup

$ podman run -d -e MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1 -v mdbdata:/var/lib/mysql -v mdbbackup:/backup  mariadb:10.5
28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43

$ podman exec 28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43 chown mysql: /backup

$ podman exec 28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43 mysql -e 'create database bob; create table bob.t ( i int primary key)'

$ podman exec -i  28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43 gosu mysql mariabackup --backup --target-dir=/backup --user=root
[00] 2021-09-04 02:10:51 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: /run/mysqld/mysqld.sock
[00] 2021-09-04 02:10:51 Using server version 10.5.12-MariaDB-1:10.5.12+maria~focal
mariabackup based on MariaDB server 10.5.12-MariaDB debian-linux-gnu (x86_64)
[00] 2021-09-04 02:10:51 uses posix_fadvise().
[00] 2021-09-04 02:10:51 cd to /var/lib/mysql/
[00] 2021-09-04 02:10:51 open files limit requested 0, set to 1048576
[00] 2021-09-04 02:10:51 mariabackup: using the following InnoDB configuration:
[00] 2021-09-04 02:10:51 innodb_data_home_dir = 
[00] 2021-09-04 02:10:51 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2021-09-04 02:10:51 innodb_log_group_home_dir = ./
[00] 2021-09-04 02:10:51 InnoDB: Using Linux native AIO
2021-09-04  2:10:51 0 [Note] InnoDB: Number of pools: 1
[00] 2021-09-04 02:10:51 mariabackup: Generating a list of tablespaces
[00] 2021-09-04 02:10:51 DDL tracking : create 5 "./bob/t.ibd"
[00] 2021-09-04 02:10:51 >> log scanned up to (46874)
[01] 2021-09-04 02:10:51 Copying ibdata1 to /backup/ibdata1
[01] 2021-09-04 02:10:52         ...done
[01] 2021-09-04 02:10:52 Copying ./bob/t.ibd to /backup/bob/t.ibd
[01] 2021-09-04 02:10:52         ...done
[01] 2021-09-04 02:10:52 Copying ./mysql/innodb_table_stats.ibd to /backup/mysql/innodb_table_stats.ibd
[01] 2021-09-04 02:10:52         ...done
[01] 2021-09-04 02:10:52 Copying ./mysql/transaction_registry.ibd to /backup/mysql/transaction_registry.ibd
[01] 2021-09-04 02:10:52         ...done
[01] 2021-09-04 02:10:52 Copying ./mysql/innodb_index_stats.ibd to /backup/mysql/innodb_index_stats.ibd
[01] 2021-09-04 02:10:52         ...done
[01] 2021-09-04 02:10:52 Copying ./mysql/gtid_slave_pos.ibd to /backup/mysql/gtid_slave_pos.ibd
[01] 2021-09-04 02:10:52         ...done
[00] 2021-09-04 02:10:52 >> log scanned up to (46874)
[00] 2021-09-04 02:10:52 Acquiring BACKUP LOCKS...
[00] 2021-09-04 02:10:53 Starting to backup non-InnoDB tables and files
[01] 2021-09-04 02:10:53 Copying ./bob/db.opt to /backup/bob/db.opt
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./bob/t.frm to /backup/bob/t.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/plugin.MAI to /backup/mysql/plugin.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_name.frm to /backup/mysql/time_zone_name.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/columns_priv.MAI to /backup/mysql/columns_priv.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/roles_mapping.frm to /backup/mysql/roles_mapping.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/gtid_slave_pos.frm to /backup/mysql/gtid_slave_pos.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/event.frm to /backup/mysql/event.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/global_priv.frm to /backup/mysql/global_priv.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition_type.MAI to /backup/mysql/time_zone_transition_type.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_leap_second.MAD to /backup/mysql/time_zone_leap_second.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_leap_second.MAI to /backup/mysql/time_zone_leap_second.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_category.frm to /backup/mysql/help_category.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone.MAI to /backup/mysql/time_zone.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proxies_priv.MAD to /backup/mysql/proxies_priv.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/db.opt to /backup/mysql/db.opt
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_category.MAD to /backup/mysql/help_category.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_keyword.MAD to /backup/mysql/help_keyword.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/user.frm to /backup/mysql/user.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_name.MAI to /backup/mysql/time_zone_name.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition.MAI to /backup/mysql/time_zone_transition.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/general_log.CSV to /backup/mysql/general_log.CSV
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/func.MAI to /backup/mysql/func.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_topic.MAD to /backup/mysql/help_topic.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/plugin.MAD to /backup/mysql/plugin.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/func.MAD to /backup/mysql/func.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/slow_log.CSV to /backup/mysql/slow_log.CSV
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition_type.MAD to /backup/mysql/time_zone_transition_type.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/slow_log.CSM to /backup/mysql/slow_log.CSM
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/columns_priv.MAD to /backup/mysql/columns_priv.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/tables_priv.MAI to /backup/mysql/tables_priv.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/db.MAD to /backup/mysql/db.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/innodb_table_stats.frm to /backup/mysql/innodb_table_stats.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/index_stats.MAD to /backup/mysql/index_stats.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proxies_priv.frm to /backup/mysql/proxies_priv.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/event.MAI to /backup/mysql/event.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/global_priv.MAD to /backup/mysql/global_priv.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/procs_priv.frm to /backup/mysql/procs_priv.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/roles_mapping.MAD to /backup/mysql/roles_mapping.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/func.frm to /backup/mysql/func.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proc.frm to /backup/mysql/proc.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/general_log.CSM to /backup/mysql/general_log.CSM
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proc.MAI to /backup/mysql/proc.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/tables_priv.frm to /backup/mysql/tables_priv.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/roles_mapping.MAI to /backup/mysql/roles_mapping.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/plugin.frm to /backup/mysql/plugin.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/event.MAD to /backup/mysql/event.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/columns_priv.frm to /backup/mysql/columns_priv.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_relation.frm to /backup/mysql/help_relation.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/table_stats.MAI to /backup/mysql/table_stats.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition.frm to /backup/mysql/time_zone_transition.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone.MAD to /backup/mysql/time_zone.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/column_stats.MAD to /backup/mysql/column_stats.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_keyword.MAI to /backup/mysql/help_keyword.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_category.MAI to /backup/mysql/help_category.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/general_log.frm to /backup/mysql/general_log.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/transaction_registry.frm to /backup/mysql/transaction_registry.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/innodb_index_stats.frm to /backup/mysql/innodb_index_stats.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/column_stats.frm to /backup/mysql/column_stats.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_relation.MAD to /backup/mysql/help_relation.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_topic.MAI to /backup/mysql/help_topic.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/servers.MAI to /backup/mysql/servers.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/global_priv.MAI to /backup/mysql/global_priv.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/tables_priv.MAD to /backup/mysql/tables_priv.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/procs_priv.MAD to /backup/mysql/procs_priv.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_topic.frm to /backup/mysql/help_topic.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition_type.frm to /backup/mysql/time_zone_transition_type.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/index_stats.frm to /backup/mysql/index_stats.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_name.MAD to /backup/mysql/time_zone_name.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/table_stats.MAD to /backup/mysql/table_stats.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/table_stats.frm to /backup/mysql/table_stats.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/servers.frm to /backup/mysql/servers.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_leap_second.frm to /backup/mysql/time_zone_leap_second.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proc.MAD to /backup/mysql/proc.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/procs_priv.MAI to /backup/mysql/procs_priv.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/index_stats.MAI to /backup/mysql/index_stats.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_relation.MAI to /backup/mysql/help_relation.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/servers.MAD to /backup/mysql/servers.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/db.MAI to /backup/mysql/db.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/column_stats.MAI to /backup/mysql/column_stats.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone_transition.MAD to /backup/mysql/time_zone_transition.MAD
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/slow_log.frm to /backup/mysql/slow_log.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/time_zone.frm to /backup/mysql/time_zone.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/help_keyword.frm to /backup/mysql/help_keyword.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/db.frm to /backup/mysql/db.frm
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./mysql/proxies_priv.MAI to /backup/mysql/proxies_priv.MAI
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./performance_schema/db.opt to /backup/performance_schema/db.opt
[01] 2021-09-04 02:10:53         ...done
[00] 2021-09-04 02:10:53 Finished backing up non-InnoDB tables and files
[01] 2021-09-04 02:10:53 Copying ./aria_log_control to /backup/aria_log_control
[01] 2021-09-04 02:10:53         ...done
[01] 2021-09-04 02:10:53 Copying ./aria_log.00000001 to /backup/aria_log.00000001
[01] 2021-09-04 02:10:53         ...done
[00] 2021-09-04 02:10:53 Waiting for log copy thread to read lsn 46874
[00] 2021-09-04 02:10:53 >> log scanned up to (46874)
[00] 2021-09-04 02:10:54 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
[00] 2021-09-04 02:10:54 mariabackup: The latest check point (for incremental): '45106'
mariabackup: Stopping log copying thread.[00] 2021-09-04 02:10:54 >> log scanned up to (46874)

[00] 2021-09-04 02:10:54 >> log scanned up to (46874)
[00] 2021-09-04 02:10:54 Executing BACKUP STAGE END
[00] 2021-09-04 02:10:54 All tables unlocked
[00] 2021-09-04 02:10:54 Copying ib_buffer_pool to /backup/ib_buffer_pool
[00] 2021-09-04 02:10:54         ...done
[00] 2021-09-04 02:10:54 Backup created in directory '/backup/'
[00] 2021-09-04 02:10:54 Writing backup-my.cnf
[00] 2021-09-04 02:10:54         ...done
[00] 2021-09-04 02:10:54 Writing xtrabackup_info
[00] 2021-09-04 02:10:54         ...done
[00] 2021-09-04 02:10:54 Redo log (from LSN 45106 to 46874) was copied.
[00] 2021-09-04 02:10:54 completed OK!

$ podman exec -i  28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43 gosu mysql mariabackup --prepare --target-dir=/backup
mariabackup based on MariaDB server 10.5.12-MariaDB debian-linux-gnu (x86_64)
[00] 2021-09-04 02:11:37 cd to /backup/
[00] 2021-09-04 02:11:37 open files limit requested 0, set to 1048576
[00] 2021-09-04 02:11:37 This target seems to be not prepared yet.
[00] 2021-09-04 02:11:37 mariabackup: using the following InnoDB configuration for recovery:
[00] 2021-09-04 02:11:37 innodb_data_home_dir = .
[00] 2021-09-04 02:11:37 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2021-09-04 02:11:37 innodb_log_group_home_dir = .
[00] 2021-09-04 02:11:37 InnoDB: Using Linux native AIO
[00] 2021-09-04 02:11:37 Starting InnoDB instance for recovery.
[00] 2021-09-04 02:11:37 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2021-09-04  2:11:37 0 [Note] InnoDB: Uses event mutexes
2021-09-04  2:11:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-04  2:11:37 0 [Note] InnoDB: Number of pools: 1
2021-09-04  2:11:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-09-04  2:11:37 0 [Note] InnoDB: Using Linux native AIO
2021-09-04  2:11:37 0 [Note] InnoDB: Initializing buffer pool, total size = 104857600, chunk size = 104857600
2021-09-04  2:11:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-04  2:11:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=45106,45106
2021-09-04  2:11:37 0 [Note] InnoDB: Starting final batch to recover 20 pages from redo log.
[00] 2021-09-04 02:11:38 Last binlog file , position 0
[00] 2021-09-04 02:11:38 completed OK!

The restore:

$ podman kill 28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43
28a3176fcc23e1566b12d40f7309afac6734a3e9fd0e6b55436de9a524815f43

$ podman volume create mdbdatarestore
mdbdatarestore

$ podman run --rm -i -v mdbdatarestore:/var/lib/mysql -v mdbbackup:/backup mariadb:10.5 gosu mysql mariabackup --copy-back --target-dir=/backup
mariabackup based on MariaDB server 10.5.12-MariaDB debian-linux-gnu (x86_64)
[01] 2021-09-04 02:16:32 Copying ibdata1 to /var/lib/mysql/ibdata1
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./aria_log_control to /var/lib/mysql/aria_log_control
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./bob/db.opt to /var/lib/mysql/bob/db.opt
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./bob/t.ibd to /var/lib/mysql/bob/t.ibd
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./bob/t.frm to /var/lib/mysql/bob/t.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/plugin.MAI to /var/lib/mysql/mysql/plugin.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/columns_priv.MAI to /var/lib/mysql/mysql/columns_priv.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/global_priv.frm to /var/lib/mysql/mysql/global_priv.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition_type.MAI to /var/lib/mysql/mysql/time_zone_transition_type.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_leap_second.MAD to /var/lib/mysql/mysql/time_zone_leap_second.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_leap_second.MAI to /var/lib/mysql/mysql/time_zone_leap_second.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone.MAI to /var/lib/mysql/mysql/time_zone.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/proxies_priv.MAD to /var/lib/mysql/mysql/proxies_priv.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_category.MAD to /var/lib/mysql/mysql/help_category.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_keyword.MAD to /var/lib/mysql/mysql/help_keyword.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_name.MAI to /var/lib/mysql/mysql/time_zone_name.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition.MAI to /var/lib/mysql/mysql/time_zone_transition.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/func.MAI to /var/lib/mysql/mysql/func.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_topic.MAD to /var/lib/mysql/mysql/help_topic.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/plugin.MAD to /var/lib/mysql/mysql/plugin.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/func.MAD to /var/lib/mysql/mysql/func.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition_type.MAD to /var/lib/mysql/mysql/time_zone_transition_type.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/columns_priv.MAD to /var/lib/mysql/mysql/columns_priv.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/tables_priv.MAI to /var/lib/mysql/mysql/tables_priv.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/db.MAD to /var/lib/mysql/mysql/db.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/index_stats.MAD to /var/lib/mysql/mysql/index_stats.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/event.MAI to /var/lib/mysql/mysql/event.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/global_priv.MAD to /var/lib/mysql/mysql/global_priv.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/roles_mapping.MAD to /var/lib/mysql/mysql/roles_mapping.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/proc.MAI to /var/lib/mysql/mysql/proc.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/roles_mapping.MAI to /var/lib/mysql/mysql/roles_mapping.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/event.MAD to /var/lib/mysql/mysql/event.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/transaction_registry.ibd to /var/lib/mysql/mysql/transaction_registry.ibd
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/table_stats.MAI to /var/lib/mysql/mysql/table_stats.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone.MAD to /var/lib/mysql/mysql/time_zone.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/column_stats.MAD to /var/lib/mysql/mysql/column_stats.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_keyword.MAI to /var/lib/mysql/mysql/help_keyword.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_category.MAI to /var/lib/mysql/mysql/help_category.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/transaction_registry.frm to /var/lib/mysql/mysql/transaction_registry.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_relation.MAD to /var/lib/mysql/mysql/help_relation.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_topic.MAI to /var/lib/mysql/mysql/help_topic.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/servers.MAI to /var/lib/mysql/mysql/servers.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/global_priv.MAI to /var/lib/mysql/mysql/global_priv.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/tables_priv.MAD to /var/lib/mysql/mysql/tables_priv.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/procs_priv.MAD to /var/lib/mysql/mysql/procs_priv.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_name.MAD to /var/lib/mysql/mysql/time_zone_name.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/table_stats.MAD to /var/lib/mysql/mysql/table_stats.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/proc.MAD to /var/lib/mysql/mysql/proc.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/procs_priv.MAI to /var/lib/mysql/mysql/procs_priv.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/index_stats.MAI to /var/lib/mysql/mysql/index_stats.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/help_relation.MAI to /var/lib/mysql/mysql/help_relation.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/servers.MAD to /var/lib/mysql/mysql/servers.MAD
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/db.MAI to /var/lib/mysql/mysql/db.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/column_stats.MAI to /var/lib/mysql/mysql/column_stats.MAI
[01] 2021-09-04 02:16:32         ...done
[01] 2021-09-04 02:16:32 Copying ./mysql/time_zone_transition.MAD to /var/lib/mysql/mysql/time_zone_transition.MAD
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./mysql/proxies_priv.MAI to /var/lib/mysql/mysql/proxies_priv.MAI
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
[01] 2021-09-04 02:16:33         ...done
[01] 2021-09-04 02:16:33 Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
[01] 2021-09-04 02:16:33         ...done
[00] 2021-09-04 02:16:33 completed OK!

$ podman run -d -v mdbdatarestore:/var/lib/mysql  mariadb:10.5
e5b030ffd45968e30e43bbe0a7eb89c854c9d8984e1c92fac96482331718439c

$ podman exec -ti e5b030ffd45968e30e43bbe0a7eb89c854c9d8984e1c92fac96482331718439c mysql -e 'show tables' bob
+---------------+
| Tables_in_bob |
+---------------+
| t             |
+---------------+

$ podman exec -ti e5b030ffd45968e30e43bbe0a7eb89c854c9d8984e1c92fac96482331718439c mysql -e 'show create table t' bob
+-------+--------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                           |
+-------+--------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `i` int(11) NOT NULL,
  PRIMARY KEY (`i`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+-------+--------------------------------------------------------------------------------------------------------+

So gosu is an exe in the container that's effectively a su minimal implementation to change to the mysql user. Do I need to clarify anything above?

grooverdan · 2021-09-04T02:38:37Z

$  podman exec -i e5b030ffd45968e30e43bbe0a7eb89c854c9d8984e1c92fac96482331718439c  cat /var/lib/mysql/xtrabackup_info
uuid = 558f781f-0d25-11ec-8d68-c2ab7eae5b3a
name = 
tool_name = mariabackup
tool_command = --backup --target-dir=/backup --user=root
tool_version = 10.5.12-MariaDB
ibbackup_version = 10.5.12-MariaDB
server_version = 10.5.12-MariaDB-1:10.5.12+maria~focal
start_time = 2021-09-04 02:10:51
end_time = 2021-09-04 02:10:54
lock_time = 0
binlog_pos = 
innodb_from_lsn = 0
innodb_to_lsn = 45106
partial = N
incremental = N
format = file
compressed = N

So mariadbbackup is already in the image. The mariadb container entrypoint without a cmd --arg or mysqld or mariadbd or blank just runs the exe without starting the server.

rvernica · 2021-09-04T03:38:07Z

Looks great. Good point about the entrypoint cmd.

Silversurfer79 · 2021-10-03T23:39:34Z

So what happens if you restore the database from a backup, is the version of the DB also reverted? Im trying find a simple way to do this in Portainer. I have 3 MariaDBs and i want to upgrade them to the latest version without breaking my wordpress sites. Thanks in advance, so lost here...

grooverdan · 2021-10-03T23:59:03Z

The restore of the data, is only the data, and is restored how it was backed up. You can run a later MariaDB version on the data by changing the container image on the startup.

You should run podman exec {container} mysql_upgrade after upgrading.

I haven't had the pleasure of using Portainer yet. I wish you a successful and simple upgrade.

Silversurfer79 · 2021-10-06T23:36:09Z

@grooverdan will test this weekend and report back ;-)

grooverdan · 2021-11-04T01:51:39Z

@Silversurfer79 how did it go?

Silversurfer79 · 2021-11-04T10:57:59Z

@Silversurfer79 how did it go?

Not great, I may have missed something clearly. I guess I need to look at this a little more. The WordPress frontend would not connect no matter what I tried to the MDB, as I did the DB update via command line.

So, I built a brand-new WP and MDB setup - all connect, basic with no config, takes about 5min. As I use a WP plugin called UpdraftPlus Backup/Restore, simply logged in with new admin account and installed the about plugin and did a full restore (DB, Plugins, Themes, Uploads and Other) and I was backup and ruining in 2-3 minutes.

I’m sure there is a better way to do it, because I’m still not 100% on the dependency between WP and MDB and the version... When I update things like Sonarr or Radarr, I simple selected Recreate and Pull the latest image, 2 seconds later its running. Now that said, containers only have Environment Variables (which are static) in Portainer which are reused and have no other decencies, but with WP and MDB they are dependent on each other.

I’m not sure if I’m using the correct terminology here, but I hope this makes sense ;-)

Closes: #MariaDB/mariadb-docker/issues/390

@yosifkit

gosu mysql -> --user mysql suggestion thanks @yosifkit Closes: #MariaDB/mariadb-docker/issues/390

@yosifkit

* mariadb: using --port As mentioned in #2708 docs documenting how to change the port, particular for host networking was requested. The example in "configuration without a cnf file section" was already the default anyway (utf8), so this was just replaced. Using MARIADB_ROOT_PASSWORD in the example to move away from MySQL naming (still supported however). Closes: #2078 * mariadb: added support for .sql.zst in /docker-entrypoint-initdb.d This was added a while ago in MariaDB/mariadb-docker#376 * mariadb: add Mariabackup (and restore) mechanism gosu mysql -> --user mysql suggestion thanks @yosifkit Closes: #MariaDB/mariadb-docker/issues/390 * mariadb: add password reset documentation Closes: #MariaDB/mariadb-docker/issues/365 * mariadb: installing plugins * Update mariadb/content.md Co-authored-by: yosifkit <[email protected]> * Update mariadb/content.md Formatting on INSTALL SONAME Co-authored-by: Tianon Gravi <[email protected]> * Update mariadb/content.md Compressed backup simplier Co-authored-by: Tianon Gravi <[email protected]> * Update mariadb/content.md better use of apt-get arguments Co-authored-by: Tianon Gravi <[email protected]> Co-authored-by: yosifkit <[email protected]> Co-authored-by: Tianon Gravi <[email protected]>

grooverdan · 2021-11-29T01:23:57Z

@Silversurfer79 , I'm sorry I'm not familiar enough with WordPress's dependency on MariaDB and if this is coded on installation. I'm also not familiar with the wordpress plugins mentioned. The nature of the dependency needs to be described more, but probably in a Wordpress forum. I'm happy to watch the discussion there after you link it here, and fill gaps if I see them.

For Mariabackup:

An updated version of this is now public https://hub.docker.com/_/mariadb

Please raise a new issue if anything needs correcting. Or if its just a documentation issue where you know the fix, you can edit https://github.com/docker-library/docs/blob/master/mariadb/content.md directly.

@yosifkit

Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [nats-streaming] Release v0.23.2 (docker-library#2084) Details can be found [here](https://github.com/nats-io/nats-streaming-server/releases/tag/v0.23.2) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh mariadb docs update (docker-library#2080) * mariadb: using --port As mentioned in #2708 docs documenting how to change the port, particular for host networking was requested. The example in "configuration without a cnf file section" was already the default anyway (utf8), so this was just replaced. Using MARIADB_ROOT_PASSWORD in the example to move away from MySQL naming (still supported however). Closes: docker-library#2078 * mariadb: added support for .sql.zst in /docker-entrypoint-initdb.d This was added a while ago in MariaDB/mariadb-docker#376 * mariadb: add Mariabackup (and restore) mechanism gosu mysql -> --user mysql suggestion thanks @yosifkit Closes: #MariaDB/mariadb-docker/issues/390 * mariadb: add password reset documentation Closes: #MariaDB/mariadb-docker/issues/365 * mariadb: installing plugins * Update mariadb/content.md Co-authored-by: yosifkit <[email protected]> * Update mariadb/content.md Formatting on INSTALL SONAME Co-authored-by: Tianon Gravi <[email protected]> * Update mariadb/content.md Compressed backup simplier Co-authored-by: Tianon Gravi <[email protected]> * Update mariadb/content.md better use of apt-get arguments Co-authored-by: Tianon Gravi <[email protected]> Co-authored-by: yosifkit <[email protected]> Co-authored-by: Tianon Gravi <[email protected]> Run update.sh Run update.sh Clarify Dart getting started steps (docker-library#2087) Run update.sh Run update.sh Fix typo in the varnish docs Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Fix typo in the varnish docs Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add rockylinux documentation pending library image addition (docker-library#2047) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update Solr's lading page on docker-hub with log4shell info (docker-library#2096) * Update Solr's lading page on docker-hub with log4shell info, and also refresh links, copyright year etc. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh nginx: removed Amplify notices. Service is in life-support mode since quite some time. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Re-add rabbitmq docs section for auth env vars (docker-library#2069) Run update.sh Run update.sh Run update.sh Friendica: Update doc Run update.sh Friendica - fix typo Run update.sh Run update.sh Run update.sh Run update.sh Add Haskell ARM64 notes And clarify old dockerfiles are no longer included in the repo. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [nats] Release v2.7.0 Details can be found [here](https://github.com/nats-io/nats-server/releases/tag/v2.7.0) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Run update.sh Update community links update monica branch name Update monica/license.md Co-authored-by: Tianon Gravi <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [README] Add comment about database host name (docker-library#2098) Update Bonita and Migration Tool versions (docker-library#2039) * Update Bonita and Migration Tool versions * Remove reference to MaxPermSize Co-authored-by: Emmanuel Duchastenier <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [nats-streaming] Release v0.24.0 Details can be found [here](https://github.com/nats-io/nats-streaming-server/releases/tag/v0.24.0) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Run update.sh convertigo: change some keywords in description Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add API-Firewall docs Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update Go example to use "go.mod" Run update.sh Run update.sh Update api-firewall content.md and logo.svg files (docker-library#2112) Co-authored-by: Nikolay Tkachenko <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update docs for registry v2.8.0 release (docker-library#2113) * Update docs for registry v2.8.0 release * leave the reference to Hub in * Put back the maintainers until we move the ownership of the image * Rename Docker Registry to Distribution Registry Run update.sh Update content.md to include public wording for AL 2022 Tech Preview Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh mariadb: stack example to use MARIADB_ROOT_PASSWORD Trying to use MariaDB names more so to highlight distinction from MySQL. mariadb: documentation update This includes the new features in the release https://mariadb.com/kb/en/mariadb-10242-release-notes/#docker-library The Mariabackup example has been modified to use a separate container for better isolation of backup and data. The mariadb-backup restore method includes an example using /docker-entrypoint-initdb.d. Edits thanks Daniel Rudolf and Ian Gilfillan. Run update.sh Run update.sh Run update.sh Run update.sh Haskell - add custom slim section Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update Ghost example to MySQL 8 Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update Eggdrop documentation (docker-library#2120) * Add package install directions * change IRC servers Run update.sh Run update.sh Run update.sh Run update.sh Golang 1.18 (docker-library#2123) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Fixed some capitalization and wording in README.md Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [varnish] adjust the tmpfs directory for permission reasons Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [varnish] add a few words about vmods Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add a new emqx image docs (docker-library#2032) Signed-off-by: zhanghongtong <[email protected]> Run update.sh Run update.sh Run update.sh Add "description cut off" warning at end too This has to be slightly more clever than the warning at the beginning to try and avoid weird markdown rendering (so it looks reasonably clean) but it isn't *too* horrible. Fix minor issues in nextcloud code blocks Adjust a few content oddities Esp. fixing cases of tianon/markdownfmt@91c4530 Run update.sh Run update.sh Run update.sh Run update.sh Update doc for bonita 2022.1 (docker-library#2127) Co-authored-by: Baptiste Mesta <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [nats] Release v2.8.0 Details can be found [here](https://github.com/nats-io/nats-server/releases/tag/v2.8.0) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Add deprecation notice to express-gateway Run update.sh Run update.sh update logo for emqx Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Clarify support for non Temurin vulnerabilities Replaced PNG with newer SVG logo and updated README-short.txt (docker-library#2139) Run update.sh Run update.sh Run update.sh Apply fixes from upstream Run update.sh Run update.sh Run update.sh Run update.sh Add more description around OpenJDK to make status more clear Switch to latest YOURLS logo Fix YOURLS GitHub link Run update.sh Run update.sh typo [varnish] document install vmods (docker-library#2134) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Remove ONBUILD references from Mono content.md The onbuild variant was removed a long time ago, but I wasn't aware of this doc. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add "jobber" deprecation notice Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update POSTGRES_HOST_AUTH_METHOD description Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update docs for Solr 9.0 (docker-library#2153) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add specific Windows note to Docker about the image being client-only Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh chore(mediawiki): add explicit volume definitions Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update "gcc" license link Closes docker-library#1772 Run update.sh Add a note about mysql_native_password next to our use of it Run update.sh Run update.sh Update Eggdrop docs (docker-library#2160) * Add package install directions * change irc servers * fix formatting * Update server env docs ...and remove old dns module comment * Finish sentence * typo fix Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Screenshot and port updates (docker-library#2163) * Update couchbase screenshots * Update ports * Update ports * Update ports * Remove ports, point at docs * Add current client-node ports * Add client->node ports to run commands Update some external links in the postgres readme (docker-library#2161) * Remove deprecated version element from stack.yml * Update links in content.md * Update version in dockerfile snippet * Revert commit 59a9d9d * Update postgres version in content.md to 14.3 * Use specific commit/version links in content.md * Remove "IPVS connection timeout issue" link Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh eclipse-temurin: update link to slack channel Run update.sh Run update.sh Run update.sh Run update.sh [oraclelinux] update docs to improve the first use experience Because Docker Hub's autogenerated pull command is invalid for this image, I'm trying to make that fact more obvious in the docs. Signed-off-by: Avi Miller <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Adjust OpenJDK image deprecation notice to fully deprecate (with an exclusion for EA tags) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Pin MariaDB to 10.5 (fix docker-library#2168) Run update.sh Run update.sh Run update.sh Update rocky linux documentation about latest tag and minimal builds Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add official image documentation for SATOSA SATOSA is a configurable proxy for translating between different authentication protocols such as SAML2, OpenID Connect, and OAuth2. It implements the Access Protocol Translation layer of [the Authentication and Authorization for Research Collaborations (AARC) Blueprint Architecture](https://aarc-project.eu/architecture/), and it is the foundation of several spoke-hub-style identity federations. Adopters include research institutions, higher education, and governments. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Map 443/udp to allow HTTP3 Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add permissions on ci GitHub workflow Upgrade actions/checkout to v3 Update the phpMyAdmin image docs Ref: docker-library/official-images#12931 Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Adjust ghost docs to use "development" mode to use sqlite MySQL is the default db for production mode now; to avoid all the envs for connecting to a mysql instance on every `docker run`, we'll just use dev mode; stack file still has an example of production mode with a MySQL server. Update Ghost documentation with more production mode pointers Run update.sh Run update.sh Adjust debian doc to not reference `jessie` or `stretch` Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Adjust `mongo` shell command to use `mongosh` - `mongo` was removed in 6.0 - `mongosh` is only available in 5+ Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add support for Launchpad URLs Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [nats] Release v2.9.0 Details can be found [here](https://github.com/nats-io/nats-server/releases/tag/v2.9.0) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Run update.sh ⬆ update to golang 1.19 Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update lightstreamer logo (docker-library#2201) eclipse-temurin: update JRE wording in docs Run update.sh Run update.sh Run update.sh Run update.sh Fix container path for cache dir The code block contains the paths that should be mapped, `/var/cache/nginx` and `/var/run` for readonly cases. However, the description immediately above the code block also listed two paths. The first, `/var/cache`, would require additional dirs to already exist within the dir. For example, the application will fail to start if the host didn't create an `nginx` dir prior to starting the container. This change updates the path in the description so it matches the path mapped in the code block and no dirs need to exist before starting the container. Run update.sh Update OpenJDK short description to be more precise added _HASH envs Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh mariadb: MARIADB_ROOT_PASSWORD_HASH to set of manditory vars Order the manditory MARIADB_ROOT_PASSWORD* by decreasing strength. Add ref MARIADB_PASSWORD_HASH to MARIADB_ROOT_PASSWORD_HASH for setting password. mariadb: custom configuration file Many people where custom mounting their configuration on /etc/mysql/my.cnf overriding many other defaults. The docs here simplify to the /etc/mysql/conf.d directory intended. A few people are doing user@hostname configurations and with the way skip-name-resolve is implemented in the server it not obvious how to disable this. Added docs to clarify this, and how to examine the final configuration. mariadb: use mariadb names instead of mysql ones These have existed since 10.4. While 10.3 won't have these, lets account for the common cases. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add deprecation notice for CentOS Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Add note that "hello-world" can run as an arbitrary user Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Fix mysql import in nextcloud readme (docker-library#2210) Run update.sh Run update.sh Run update.sh Link to more Stack Exchange sites Also, link directly to their "What topics can I ask about here?" pages instead of to a search. Update Bonita and Migration Tool versions Run update.sh Run update.sh Run update.sh Readme Typo when referring to pre-existing db folder (docker-library#2212) [nats] Release v2.9.3 Details can be found [here](https://github.com/nats-io/nats-server/releases/tag/v2.9.3) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Run update.sh Run update.sh [nats-streaming] Release v0.25.2 Details can be found [here](https://github.com/nats-io/nats-streaming-server/releases/tag/v0.25.2) Signed-off-by: Ivan Kozlovic <[email protected]> Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update the HAProxy Docs URL see https://www.mail-archive.com/[email protected]/msg42790.html Run update.sh Run update.sh Add Alpine locale information for Postgres 15 (docker-library#2220) Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Update community Slack link Run update.sh Update forwarded ports in example docker run commands (docker-library#2224) * Update ports in example docker run commands Run update.sh Run update.sh Tidy up port list Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh [varnish] add a few words about port variables remove line in jetty docs about JDK9 and HTTP2 (docker-library#2230) Signed-off-by: Lachlan Roberts <[email protected]> Run update.sh ubuntu: Update Git references to Launchpad Ubuntu base images rootfs tarballs are now fetched from Launchpad Git repository. The location https://partner-images.canonical.com/oci/ is no longer used. Update links in the documentation to refer to the https://git.launchpad.net/cloud-images/+oci/ubuntu-base Git repository URL instead. The Launchpad Git repository URL is also set in github-repo file. This shouldn't matter because the fact that an URL is a GitHub URL is used only to fetch badges from open-source CI/CD services, and in case the URL is not a GitHub URL, the HTTP request will just fail, and no badge will be included. Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh Run update.sh

grooverdan self-assigned this Sep 4, 2021

grooverdan mentioned this issue Oct 6, 2021

hub.docker.com Documents incomplete #396

Closed

grooverdan added a commit to grooverdan/docs that referenced this issue Nov 16, 2021

mariadb: add Mariabackup (and restore) mechanism

3f68095

Closes: #MariaDB/mariadb-docker/issues/390

grooverdan added a commit to grooverdan/docs that referenced this issue Nov 16, 2021

mariadb: add Mariabackup (and restore) mechanism

8403629

Closes: #MariaDB/mariadb-docker/issues/390

grooverdan added a commit to grooverdan/docs that referenced this issue Nov 16, 2021

mariadb: add Mariabackup (and restore) mechanism

3dcdcf9

Closes: #MariaDB/mariadb-docker/issues/390

grooverdan added a commit to grooverdan/docs that referenced this issue Nov 19, 2021

mariadb: add Mariabackup (and restore) mechanism

5ce6c3a

gosu mysql -> --user mysql suggestion thanks @yosifkit Closes: #MariaDB/mariadb-docker/issues/390

grooverdan closed this as completed Nov 29, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Guidance on restoring mariabackup #390

Guidance on restoring mariabackup #390

rvernica commented Sep 4, 2021

grooverdan commented Sep 4, 2021 •

edited

Loading

grooverdan commented Sep 4, 2021

rvernica commented Sep 4, 2021

Silversurfer79 commented Oct 3, 2021

grooverdan commented Oct 3, 2021

Silversurfer79 commented Oct 6, 2021

grooverdan commented Nov 4, 2021

Silversurfer79 commented Nov 4, 2021 •

edited

Loading

grooverdan commented Nov 29, 2021

Guidance on restoring mariabackup #390

Guidance on restoring mariabackup #390

Comments

rvernica commented Sep 4, 2021

grooverdan commented Sep 4, 2021 • edited Loading

grooverdan commented Sep 4, 2021

rvernica commented Sep 4, 2021

Silversurfer79 commented Oct 3, 2021

grooverdan commented Oct 3, 2021

Silversurfer79 commented Oct 6, 2021

grooverdan commented Nov 4, 2021

Silversurfer79 commented Nov 4, 2021 • edited Loading

grooverdan commented Nov 29, 2021

grooverdan commented Sep 4, 2021 •

edited

Loading

Silversurfer79 commented Nov 4, 2021 •

edited

Loading