tickets #160053
closedRequest for old forums backup (vBulletin)
0%
Description
Looking to pull some old message history that didn't translate well in the
move to Discourse (URLs didn't get updated in messages, so references are
missing) as well as deleted messages (which I believe were maintained in
the vBulletin database but not included in the migration).
I've got a vBulletin sandbox VM image and Docker container that I can use
to restore the backup to so I can answer some questions that have come up
in admin/moderator discussions. Just need the data so I can do the
research.
Thanks
Updated by crameleon 8 months ago
- Status changed from New to Blocked
- Assignee set to crameleon
- Private changed from Yes to No
Hi,
there is no vBulletin backup, but the "production" database still exists on our MariaDB cluster. In fact, there are two VB databases - "webforums" and "webforums2".
As an interesting side effect of your request, I notice our MySQL backups to be incomplete, some databases are not getting dumped, including the webforums ones - I created https://progress.opensuse.org/issues/160086 for this.
I will repair this, and then there will also be a dump of webforums{,2} for your consumption.
Updated by crameleon 8 months ago
- Blocked by tickets #160086: MySQL/Galera backups incomplete (again) added
Updated by crameleon 8 months ago
- Status changed from In Progress to Feedback
Gave you read access to these files on mybackup.infra.opensuse.org:
-rw-r-----+ 1 root root 350115084 May 9 06:11 /backup/20240509/webforums2.sql.xz
-rw-r-----+ 1 root root 484455348 May 9 05:56 /backup/20240509/webforums.sql.xz
Note the directory is not world readable.
Let me know if this helps.
Updated by crameleon 8 months ago ยท Edited
You can find the source code of our backup tool in https://build.opensuse.org/package/show/openSUSE:infrastructure/mysql-backupscript. It runs daily.