Questions tagged [backup]

The act of saving one's files, data, applications, etc. to secondary media, allowing for the recovery of the files, data, applications, etc. in the event that the primary media becomes unavailable (fails). Also the secondary media used for storage.

5770 questions
52
votes
11 answers

How to get deleted files back with git pull?

I had up to date repository. Then I had deleted several files and this was mistake. I would like to get fresh repository back. I do $ git pull origin master And expect to get everything from server, but getting message that everything is up to…
vico
  • 17,051
  • 45
  • 159
  • 315
52
votes
9 answers

How do I back up a remote SVN repository

I am currently moving my SVN server from my home server to my remote server so I can access it more easily from other locations. My remote server is not backed up so I want to regularly back it up to my home server. Remote server is Windows 2003…
Roaders
  • 4,373
  • 8
  • 50
  • 71
51
votes
5 answers

Opening a SQL Server .bak file (Not restoring!)

I have been reading a LOT of google posts and StackOverflow questions about how to restore a database in SQL Server from a .bak file. But none of them states how to just READ the tables in the database-backup. (None that I could find anyway?) I just…
MicBehrens
  • 1,780
  • 8
  • 34
  • 57
51
votes
15 answers

s3cmd failed too many times

I used to be a happy s3cmd user. However recently when I try to transfer a large zip file (~7Gig) to Amazon S3, I am getting this error: $> s3cmd put thefile.tgz s3://thebucket/thefile.tgz .... 20480 of 7563176329 0% in 1s 14.97 kB/s …
qliq
  • 11,695
  • 15
  • 54
  • 66
50
votes
6 answers

How to skip row when importing bad MySQL dump

Given bad mysqldump that causes error on import: namtar backups # mysql -p < 2010-12-01.sql Enter password: ERROR 1062 (23000) at line 8020: Duplicate entry 'l�he?' for key 'wrd_txt' Is there an easy way to tell import to just skip given row and…
Almad
  • 5,753
  • 7
  • 35
  • 53
50
votes
11 answers

Speeding up mysql dumps and imports

Are there any documented techniques for speeding up mySQL dumps and imports? This would include my.cnf settings, using ramdisks, etc. Looking only for documented techniques, preferably with benchmarks showing potential speed-up.
deadprogrammer
  • 11,253
  • 24
  • 74
  • 85
50
votes
10 answers

Restore database backup over the network

How do you restore a database backup using SQL Server 2005 over the network? I recall doing this before but there was something odd about the way you had to do it.
Ryan
  • 4,602
  • 8
  • 37
  • 43
49
votes
5 answers

How should I backup & restore docker named volumes

I'm a little bit confused with the functionnality of named volumes in a docker compose file specifically when it comes to backup/restore my app. I'm actually testing this dockercompose file : version: '2' services: django: …
Plup
  • 750
  • 1
  • 6
  • 13
49
votes
4 answers

Override file while backup database

I want to back up a database using this code sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It works. But if the backup file already exists, the data gets appended to the file instead of replacing the file. Every time…
juergen d
  • 201,996
  • 37
  • 293
  • 362
47
votes
10 answers

How to backup Sql Database Programmatically in C#

I want to write a code to backup my Sql Server 2008 Database using C# in .Net 4 FrameWork. Can anyone help in this.
user1287692
47
votes
7 answers

How to remove all files ending with ~ made by Emacs

Whenever I edit files on emacs, it seems a temporary file is created with the same name with ~ appended to it. Does anyone know an quick/easy way to delete all of these files in the working directory?
jhchen
  • 14,355
  • 14
  • 63
  • 91
46
votes
6 answers

How to take a backup for the 'connection details' in sqldeveloper?

What is the process to take a backup of all the connection-details (viz. host,port,sid,etc.) in 'oracle sqldeveloper' software. How can we import these connection details to some other machine ?
Satyendra
  • 1,635
  • 3
  • 19
  • 33
46
votes
6 answers

What is the best way to backup Azure Blob Storage contents

I know that the Azure Storage entities (blobs, tables and queues) have a built-in resiliency, meaning that they are replicated to 3 different servers in the same datacenter. On top of that they may also be replicated to a different datacenter…
Archil Kublashvili
  • 696
  • 1
  • 8
  • 20
44
votes
6 answers

rsync prints "skipping non-regular file" for what appears to be a regular directory

I back up my files using rsync. Right after a sync, I ran it expecting to see nothing, but instead it looked like it was skipping directories. I've (obviously) changed names, but I believe I've still captured all the information I could. What's…
Richard
  • 441
  • 1
  • 4
  • 4
43
votes
5 answers

Backup of PostgreSQL database design - without data

I have tried to find a way to backup my database design without including the data stored in the database. Actually, one might say that I want to have a file that holds all "CREATE Scripts" in the database. Ideally, this file could be used to…
Helge
  • 673
  • 2
  • 6
  • 9