Questions tagged [backup-strategies]
169 questions
82
votes
6 answers
How can I slow down a MySQL dump as to not affect current load on the server?
While doing a MySQL dump is easy enough, I have a live dedicated MySQL server that I am wanting to setup replication on. To do this, I need dumps of the databases to import to my replication slave.
The issue comes when I do the dumps, MySQL goes…

z33k3r
- 831
- 1
- 7
- 5
61
votes
1 answer
How to transfer pgp private key to another computer?
I read this article (archived link) which explained very well how to setup PGP on macOS. But I'm planning to use the keys generated for signing Git commits, so I figure I need to transfer the keys to other computers. Is this correct? And, if so,…

erikvold
- 15,988
- 11
- 54
- 98
23
votes
5 answers
How to backup SVN repository?
I often hear that having an SVN repository doesn't cancel need for backups.
How is such backup done? I mean the repository will inflate over time, won't it? So do I back it up as a whole every time or what do I do?
What's the easiest way to do such…

sharptooth
- 167,383
- 100
- 513
- 979
17
votes
2 answers
How do I pipe a git clone to archive (tar or gzip)
I am trying to make a simple backup script for my remotely hosted git repos. In the script I have a few lines that currently look like this:
git clone git@server:repo.git $DEST
tar czvf repo.tgz $DEST
rm -rf $DEST
Is there a way to make this all…

bryan kennedy
- 6,969
- 5
- 43
- 64
14
votes
2 answers
How to verify the integrity of the files that result from a mongodump operation?
From the research I have done, mongodump doesn't have a built-in check to verify the integrity of a mongodump operation; at least, nothing apparent to the user. I may be wrong. If I am, please inform me. Otherwise, I'm sure I'm not the only one who…

tlovely
- 645
- 1
- 5
- 15
11
votes
1 answer
Magento: backup options
I have a question regarding the Magento options found under:
Admin Panel -> System -> Tools -> Backups
What is the difference between "System Backup",
"Database and Media Backup", and "Database Backup".
I think I can figure out the difference…

user1527429
- 727
- 5
- 10
- 17
8
votes
3 answers
How can I configure a structure for backing up elasticsearch data on Google Compute Engine?
I have e elasticsearch environment configured on GCE (Google Compute Engine) with two nodes, therefore two VM's and I need to create a backup strategy for this.
I first thought I could use the elasticsearch snapshot API to backup all my data to a…

Edmar Miyake
- 12,047
- 3
- 37
- 38
7
votes
1 answer
Android SharedPreferences Backup Not Working
I've been doing my homework on how to backup SharedPreferences in my Android application, especially using reflection to maintain backwards compatibility. At least I've been trying. Unfortunately, none of my code actually ends up creating a backup!…

permafrost91
- 71
- 1
- 3
7
votes
2 answers
Backup & restore DynamoDb tables
My aim is to back up and restore a dynamodb table to/from S3.
I'm aware about the Import/Export using data pipelines and DynamoDb streams.
My concern using Data Pipeline is that when the backup process is complete, I cannot be sure as to what…

Mustafa
- 161
- 1
- 5
6
votes
1 answer
Best practice for website database writes during cold backups?
Lets say you have a large, popular database-driven website. There are people on the site all day and all night. They access pages that both read and write to the database.
When implementing a daily database backup plan, it involves doing cold…

Jake Wilson
- 88,616
- 93
- 252
- 370
6
votes
3 answers
Can you retrieve source from a debug-compiled binary?
I was digging around and found an executable for something I wrote in Visual C++ 6.0 about 8 years ago. I never backed up the source code, but I think I always compiled everything in debug mode. I also vaguely remember hearing somewhere that "you…

Michael Burge
- 425
- 9
- 16
6
votes
2 answers
Windows Azure Active Directory Backup/Restore
I am looking for a way to backup/restore Windows Azure Active Directory to protect against user error. I recognize the robust nature of Azure and am not concerned with infrastructure failure and the like.
What I am concerned with is protection from…

Hydroslide
- 155
- 2
- 10
5
votes
8 answers
How do you handle off-site backups of terabytes of data?
I have terabytes of files and database dumps that I need to backup off-site.
What's the best way to accomplish this?
I'm currently weighing rsyinc to Amazon EBS or getting an appliance (eg barracuda).
I called a buddy of mine, and he said he uses…

Scott
- 7,034
- 4
- 24
- 26
4
votes
4 answers
Database mirroring/Replication, SQL Server 2005
I have two database servers running SQL Server 2005 Enterprise that I want to make one of them as mirror database server.
What I need is; to create an exact copy database from primary server on mirror server, so when the primary server was down, we…

Dels
- 2,375
- 9
- 39
- 59
4
votes
1 answer
Restoring Daily Differential Backup - No Files Are Ready To Rollforward Issue
I use SQL Server. There is a problem with my differential backups. I take full backup of my database at the end of the week and beside, i also take differential backup of the database daily. I have created a job which makes these backing up tasks…

Omer
- 43
- 1
- 1
- 6