Project

General

Profile

Actions

tickets #160086

closed

MySQL/Galera backups incomplete (again)

Added by crameleon 2 months ago. Updated 2 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Backup
Target version:
-
Start date:
2024-05-08
Due date:
% Done:

0%

Estimated time:

Description

In https://progress.opensuse.org/issues/155032 I resolved the missing database backups. Or so I thought.

Databases:

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| chocolate          |
| conference_osem    |
| etherpad           |
| information_schema |
| limesurvey         |
| matomo             |
| members            |
| mirrorcache        |
| mysql              |
| performance_schema |
| redmine            |
| redmine_test       |
| suse_hackweek      |
| sys                |
| webforums          |
| webforums2         |
| wiki_cn            |
| wiki_cs            |
| wiki_de            |
| wiki_el            |
| wiki_en            |
| wiki_en_test       |
| wiki_es            |
| wiki_fr            |
| wiki_hu            |
| wiki_it            |
| wiki_ja            |
| wiki_languages     |
| wiki_nl            |
| wiki_old_de        |
| wiki_old_en        |
| wiki_pl            |
| wiki_pt            |
| wiki_ru            |
| wiki_sv            |
| wiki_tr            |
| wiki_zh            |
| wiki_zh_tw         |
| wsrep              |
| xbttracker         |
+--------------------+
40 rows in set (0.001 sec)

Backup:

crameleon@mybackup:/home/crameleon> sudo ls -l /backup/20240504/
total 3069664
-rw-r----- 1 root root        852 May  4 03:00 chocolate.sql.xz
-rw-r----- 1 root root    4260248 May  4 03:00 conference_osem.sql.xz
-rw-r----- 1 root root  106788020 May  4 03:00 etherpad.sql.xz
-rw-r----- 1 root root     866524 May  4 03:02 limesurvey.sql.xz
-rw-r----- 1 root root 3030961632 May  4 03:03 matomo.sql.xz
-rw-r----- 1 root root       3782 May  4 03:00 my.cnf
drwxr-x--- 2 root root        164 May  4 03:00 my.cnf.d
-rw-r----- 1 root root     381988 May  4 03:19 mysql.sql.xz
-rw-r----- 1 root root       7768 May  4 03:19 percona.sql.xz
-rw-r----- 1 root root      44708 May  4 03:19 sys.sql.xz
-rw-r----- 1 root root        848 May  4 03:19 test.sql.xz

Related issues 2 (0 open2 closed)

Related to openSUSE admin - tickets #155032: MySQL/Galera backups incompleteResolvedcrameleon2024-02-07

Actions
Blocks openSUSE admin - tickets #160053: Request for old forums backup (vBulletin)Resolvedcrameleon2024-05-08

Actions
Actions

Also available in: Atom PDF