Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [backup]

Making copies of data so that the copies may be used to restore the original after a data loss event, or for historical retention.

3959 questions
40
votes
19 answers

Best practices to keep your computer(s) backed up efficiently?

I'm looking for a cheap and efficient strategy to keep my personal computers and laptops backed up. For example, currently I take a snapshot of my desktop once a week with Ghost and place the image on my external hard drive. Is this enough? Do you…
Bryan Denny
  • 549
  • 7
  • 6
39
votes
2 answers

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
warren
  • 18,369
  • 23
  • 84
  • 135
39
votes
4 answers

How To Backup "crontab -e" Files?

I want to do a complete server backup. I already have my backup script copying all of the html/php files for the web app, and the mysql databases, placing them into a .tar.gz file. How can I add the crontab files to that backup? Whenever I save the…
darkAsPitch
  • 1,931
  • 4
  • 25
  • 42
37
votes
7 answers

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and slower. Individual inserts are now taking 15+…
Dave Forgac
  • 3,546
  • 7
  • 37
  • 48
36
votes
6 answers

compressing dd backup on the fly

Maybe this will sound like dumb question but the way i'm trying to do it doesn't work. I'm on livecd, drive is unmounted, etc. When i do backup this way sudo dd if=/dev/sda2 of=/media/disk/sda2-backup-10august09.ext3 bs=64k ...normally it would…
Phil
  • 1,969
  • 6
  • 29
  • 33
35
votes
3 answers

How to perform incremental / continuous backups of zfs pool?

How can zfs pools be continuously/incrementally backed up offsite? I recognise the send/receive over ssh is one method however that involves having to manage snapshots manually. There are some tools I have found however most are no longer…
Greg
  • 1,657
  • 5
  • 27
  • 38
34
votes
7 answers

How can I use rsync with a FAT file system?

I would like to write a simple backup script that saves some data to a FAT drive. Should I reformat the drive and use a better file system or is it possible to use rsync with FAT? If so, what problems might I run into? Would performance be a lot…
Kim
  • 769
  • 1
  • 5
  • 12
33
votes
14 answers

Is it safe to store data on a hard drive for a long time?

Is it safe to backup data to a hard drive and then leave it for a number of years? Assuming the file system format can still be read, is this a safe thing to do. Or is it better to continually rewrite the data (every 6 months or so) to make sure it…
Nick R
  • 1,106
  • 3
  • 14
  • 19
33
votes
3 answers

How does dropbox version/upload large files?

I have a free dropbox account (2GB), and I was wondering how the versioning of large files works. I have a full backup of all my webfiles that sites @ just over 1GB. After the initial upload of 1GB, everytime it syncs will dropbox figure out the…
barfoon
  • 760
  • 4
  • 14
  • 29
32
votes
5 answers

Do I still need a backup if I have a redudant storage system with rollback capabilities?

My organization recently bought a storage system. It has 1.5Petabyte, with RAID6, and there is an online synced mirror in a physical different location. The system allows rollback / file recovery, by default allowing up to 30 days but this can be…
nsn
  • 501
  • 3
  • 12
29
votes
5 answers

Do you need -e ssh for rsync?

I always used to use the following command when copying from a server: rsync --progress -avze ssh user@host:/path/to/files ./here However, a friend of mine showed me that I can simply do: rsync --progress -avz user@host:/path/to/files ./here So…
mmirzadeh
  • 393
  • 1
  • 3
  • 5
28
votes
7 answers

Backing up a 22 GB MySQL database daily

Right now I am able to do the backup using mysqldump. But I have to take down the web server AND it takes around 5 minutes to do the backup. If I don't take down the web server, it takes forever and never finishes + the website becomes inaccessible…
unknown (yahoo)
28
votes
7 answers

Cliffhanger: The backups are right... here... right?

At my work, backups have a surprisingly low priority. The backup strategy was implemented a while ago, and since then it's just assumed the backups are fine. If you ask the sysadmins, they'll say everything is backed up. But then, when you ask for…
Andomar
  • 943
  • 1
  • 10
  • 23
28
votes
3 answers

Does Rsync Allow Files To Be Synced Both Ways?

I have backed up a linux web server using rsync with cygwin. I now have a perfect copy of the server on my windows laptop. If i delete or modify a file on my laptop and run rsync again with cygwin will it delete/update the same file on the server?…
Dan Hastings
  • 706
  • 1
  • 13
  • 24
27
votes
5 answers

What's the best way to automate backing-up of PostgreSQL databases?

I find it tedious to have to backup databases every week. And I also think weekly backups should be turned into daily backups. If I had to do that, I don't want to do it manually. What's the best way to automate the backing-up of PostgreSQL…
Randell
  • 1,173
  • 8
  • 18
  • 26
1
2
3
…
99 100