5,722 questions
Advice
0
votes
5
replies
76
views
Backup GIT Repository Azure DevOps
For disaster recovery, my company needs backups of our ADO Git repos. My predecessor set up a backup by cloning the repos with --no-checkout option:
git clone --no-checkout {ReposURL} {...
Advice
0
votes
2
replies
40
views
Is there a way to automatically back up a PostgreSQL log table when it is updated or deleted?
I have a log table in PostgreSQL (people_log) that tracks changes in my main tables.
The problem is, the log table can grow very large, so I cannot keep all the data in the table indefinitely.
I want ...
Best practices
0
votes
0
replies
27
views
Looking for recommendations for a resilient home setup
This might be a weird question but I'd like to run it by you. My current setup to store data is as follows:
NAS Synology DS224+ with 2x4TB HDD (avoiding Docker containers)
Daily backup on a Synology ...
0
votes
0
answers
36
views
How to make a backup to a remote server Apache Cloudberry
I’m currently configuring backups for an Apache Cloudberry 2.0.0-incubating cluster using the gpbackup utility.
When I run the backup locally, everything works correctly — gpbackup creates files on ...
0
votes
1
answer
49
views
Should I disallow backups of sqlite to the same physical media? [closed]
Looking at the Sqlite backup options
https://oldmoe.blog/2024/04/30/backup-strategies-for-sqlite-in-production/
I have a question that is orthogonal to the backup method used:
suppose on Windows I ...
0
votes
0
answers
66
views
Accessing sqlite fts5 from a Windows client, in particular for backup purposes
I have a large fts5 virtual table (currently about 90GB).
Because the sqlite ODBC driver, which I use (version 3.43.2) as my main sqlite scripting client, doesn't support fts5, I populate and use fts5 ...
1
vote
1
answer
388
views
Using gbak to upgrade Firebird 2.5.9 database to Firebird 5.0
I have an app using Firebird 2.5.9. We're going to be releasing a major new version of the app, and I want to migrate to FB 5.0. The database schema has changed dramatically between old and new app ...
1
vote
0
answers
45
views
Is it possible to perform a schema-only mongodump without exporting data?
I'm currently automating the mongodump process for both our staging and production databases using a Python script. For this use case, I only need to export the metadata—such as collection names, ...
1
vote
1
answer
82
views
Back Up Files During a WiX MSI Installation
I am using the WixToolset 6.0 with Visual Studio 2022. I am trying to create an installer that installs the following files:
<ComponentGroup Id="ApplicationFiles" Directory="...
0
votes
1
answer
81
views
The error message indicates that the database attachment failed for server 'SERVER\SSQ' due to a Transaction-SQL statement or batch execution issue
My client's SQL Server database file is corrupted, and there is no backup. We only found the MDF and LDF files copied using NAT backup software. I need to use these files to rebuild the database. The ...
1
vote
0
answers
46
views
What is PG archive_timeout alignment
Actually for the archive_timeout PG config option what is the alignment point.
Is it counting
from the last archive time (or the server start)
or just something like now() % archive_timeout
Thanks
1
vote
1
answer
385
views
Aws cross-account backup copy and restoration failing due to insufficient privileges
I am creating backups of my DynamoDB tables using AWS Backup in my source account A and storing the recovery point ARNs in a vault named X in source account A .
I need to copy and restore the backup ...
0
votes
0
answers
170
views
How can I backup digikam's MariaDB database, when mariadb-backup says Access denied for user...?
I'm trying to backup the digikam Mariadb 11.4 database on my Windows 11 PC. I could access earlier versions of the database for digikam/MariaDB, with root user, but now receive Access denied messages.
...
1
vote
0
answers
70
views
How to delete old app backups or keep the phone from restoring that data in Android?
We are developing an app for a client and the app had always set android:allowBackup="true" in the android manifest. We got the request to not allow backups, so we set allowBackup to false, ...
1
vote
2
answers
100
views
Is it okay to use a symlink for my local .git folder?
I like to keep a copy of my /etc folder in a git repository. That way, if something changes and breaks but I don't notice it right away, I'm likely to have a diff that helps me recover pretty quickly.
...
1
vote
1
answer
522
views
minimum postgresql permissions for pg_dump --schema-only
I'm trying to create a dedicated role/user in postgresql and I want to grant only the minium privileges for a schema inside a database, but I don't really understand how this works.
Of course I know I ...
1
vote
1
answer
412
views
Azure blob storage backup with large number of containers
I operate a SAAS software system in which user data is stored in Azure blob storage with a separate container for each user. The storage account currently contains just over 1000 containers. I need to ...
3
votes
0
answers
130
views
Backup SQL Server database on linux from PHP
I am using SQL Server 2022 Express on Ubuntu Server 22.04, and PHP 8.3.
I am trying to backup a database, the instruction is: BACKUP DATABASE WEBDEV TO DISK = '/temp/WEBDEV.bak', and when I execute it ...
0
votes
1
answer
369
views
PostgreSQL 17.2 Incremental backup
I am using PostgreSQL 17.2, and I would like to use the Incremental Backup feature.
Here are my conf-file settings:
wal_compression = on
wal_log_hints = on
max_wal_size = 4GB
min_wal_size = 80MB
...
2
votes
1
answer
5k
views
Simple way to backup/restore Docker named volumes [closed]
I have this Docker compose file with named volumes:
version: '3'
services:
db:
image: mysql:8.0
container_name: db
volumes:
- dbdata:/var/lib/mysql
wordpress:
image: ...
0
votes
2
answers
75
views
Shell script to backup dir from list
I have a backup script which does the job but takes a long time to complete because it tars Users dir against a list of servers in DEV_Servers.txt one by one.
Is there a way the tar command could run ...
0
votes
2
answers
345
views
High swap consumption during database backup with mariabackup
We are experiencing a swap consumption problem when backing up our database.
Every evening at 01am we run the mariabackup command and during the process swap usage rises sharply until it reaches 100% ...
1
vote
0
answers
19
views
spatie-backup to run on WAMP
I cannot configure laravel 10 spatie 9.3 to work on my local installation using anything else than the terminal (e.g. using it via controller / blade file...)
iam running WAMP , PHP8.2;Mysql8.2 and ...
0
votes
1
answer
164
views
problem in backing up mysql database in laravel 11 using a route
I want to backup mysql database in laravel 11 using a route. I tried some ways and all of them had problem:
using Spatie/db-dumper:
protected $signature = 'backup:database';
public function handle()
{...
1
vote
0
answers
58
views
Creating many hard links to a single file gradually slows down hard link creation
I've written a backup script in Python that uses hard links to create full backups while saving a lot of space. When a new backup is made, the most recent backup is compared to the source files. If a ...
-1
votes
1
answer
145
views
Remove azure fileshare with RSV backup enabled via terraform gives error of share or snapshots may have active leases
I have two recovery service vaults in two different regions, south east asia and west europe.
But I only get this error message when using terraform to destroy the azure fileshare that has snapshot ...
0
votes
1
answer
123
views
Configuring active passive hub clusters
I'm trying to configure 2 of my openshift hub (acm) clusters to work in active passive mode.
My clusters are installed on-premis. (Servers inside my company).
I started with this documentation. From ...
0
votes
1
answer
865
views
gitlab-backup create faile -> Backup::Error: gitaly-backup exit status 1
When I am using command "gitlab-backup create --trace" to backup my gitlab data, the errors as follows:
{"level":"error","msg":"create: pipeline: 3 ...
0
votes
2
answers
981
views
How to backup data including large objects from Postgres
I'm trying to backup from one database and restore on other database both with the same version(12.9). I have one table with large objects(OID) and when I restore the backup the large objects are ...
0
votes
0
answers
62
views
Backup github and restore when github down
I need to backup github repo and restore it to another git server (eg: gitlab/bitbucket etc, with all those issue/pull request/tag/branches restore)
Assumption:
The backup will not be sync to ...
3
votes
0
answers
756
views
Enable cross-region automated backup replication for Multi-AZ RDS Aurora Cluster [closed]
I have a question regarding implementing cross-region automated backups replication for RDS Aurora Postgres cluster in Terraform (ideally using 'internal' RDS service functionalities /API endpoints).
...
1
vote
0
answers
69
views
Lotus Notes 9.1 Backup and LotusScript
I’m working with IBM Notes 9.1 and need some assistance. My manager mentioned that they want to back up the existing information. One option they explored was manually downloading each incident along ...
0
votes
1
answer
259
views
Error :TF254078 No attachable database were found
Azure Devops Server 2022.2
I have upgraded the Test Environment with new Azure DevOps Server 2022.2, Then restore the tfs_configuration and tfs_DefaultCollection latest backup from another production ...
0
votes
1
answer
63
views
How much data in S3 will be backup for the first time?
Let say I have a S3 bucket which I created it and uploaded files to it a year ago. I kept it unchanged for a year. Now I turn on backup on it using continuous backup and set the total retention period ...
0
votes
0
answers
154
views
How to Completely Restore a WordPress Site from a Manual Backup
I’ve been (slowly) designing a new WordPress site locally on my Windows 11 hard drive. I’ve been using Apache and MySQL via the XAMPP Control Panel.
I keep running into a situation in which MySQL ...
0
votes
1
answer
255
views
APISIX Backup and Restore Steps 3.8.0 version
Requirement: Backup and Restore steps for Apisix 3.8.0 version.
its Etcd pods method or any other,
1
vote
2
answers
2k
views
How to upgrade Jenkins which is running in a docker container withour losing any data?
So the problem is my Jenkins is running on a docker container and that Jenkins needs update. So that cannot happen while this Jenkins is running. If I download the latest Jenkins image , I will have ...
0
votes
0
answers
211
views
Rsync --compare-dest with remote directory giving errors
On local Win11 machine, I'm using rsync v3.3 through Cygwin v3.5.3 and on my remote ubuntu 22.04 machine, I'm using rsync v3.2.7.
I have a source directory in my local machine whilst compare and ...
0
votes
0
answers
35
views
Docker container cant connect with mongoDb
Issue Summary: I'm encountering a connection error between my Spring Boot application and a MongoDB database running in separate Docker containers.
Error Description: I'm receiving the following error:...
1
vote
1
answer
335
views
recover deleted firestore collection
I accidentally deleted firestore collection. then I interuppted that in between and it resulted in partial deletion. I want to restore my data.
Point in time recovery was not enabled and I made above ...
0
votes
1
answer
174
views
Does Zscaler has api endpoints to Backup configurations?
Does Zscaler has exposed api endpoints to backup configuration or any python library available to backup configuration settings ?
I have the documentation of common endpoints which zscaler has exposed ...
0
votes
0
answers
73
views
Solr backup not getting created in both solr nodes
I have solr cloud version 9.5 with two nodes deployed in kubernetes cluster. I am trying to take solr backup using the Solr backup API
Bakup API -
http://localhost:8982/solr/admin/collections?action=...
0
votes
1
answer
328
views
how backup and restore in Visual Studio 2019
I am looking for a way to restore my past data and settings. But I can't find a suitable way. If possible, suggest a principled and professional way, if possible, with a video link. Thank you in ...
-1
votes
1
answer
394
views
All my chats got revealed in my previous phone when someone else tried to login their whatsapp
I used to use whatsapp on my previous phone which i do not anymore. That phone doesnt have my sim nor any of my google accounts in it anymore. Recently a family member put their sim card in this phone ...
0
votes
1
answer
2k
views
Best practice when backing up up persistent container data in Podman
I'm using Vaultwarden to store passwords and other sensitive data. Vaultwarden runs in a container, where the SQLite database is hosted on a volume mapped to the host. The configuration is stored in a ...
1
vote
0
answers
197
views
How can I dump rdb file into running/existing redis-sentinel without destroying or overwriting existing data-set?
My aim is to try in case of disaster for one of the sentinel installation, I'd like to restore that dataset on the second redis-sentinel installation. So, it's basically a geographical redundancy and ...
0
votes
1
answer
426
views
RDS snapshot only restored writer instance
I restored an RDS aurora mysql snapshot , the original DB cluster has a reader and writer instance both. But when I took a snapshot of it and restored, i noticed that it only created a writer instance ...
0
votes
1
answer
95
views
Docker volume backup creates root:root owned files
I'm trying to backup a docker volume by tar-ing the contents and copying that out of the container using a bind mount (I think). The command is:
docker run --rm -v ./$BACKUPDIR:/backup -v ...
0
votes
1
answer
67
views
Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '@certificateName'
I'm trying to encrypt my SQL Server database backup using certificate name in C#, but I'm encountering issues.
Here is the code that works with a hardcoded certificate name:
string encryptionClause = &...
0
votes
1
answer
73
views
Modify and delete tables and apply to DBContext
I had an old bank and store that stored user information and product information in the database.
Now I updated the store and changed many tables
On the other hand, I need to extract the previous ...