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
2
votes
2 answers

Backup MySQL schema with foreign key table constraints

I created my MySQL schema that consists of multiple tables and I decided that I would add the foreign key constraints afterwards for each table, using the command: ALTER TABLE Orders ADD FOREIGN KEY (P_Id) REFERENCES Persons(P_Id) How can I get a…
Yiannis Tsimalis
  • 739
  • 2
  • 11
  • 23
2
votes
1 answer

How to compare two directory's files (using file names only) in Linux?

I wanted to ask if there is a command in Linux that can check recursively for two folder's contents and generate an output of the differences. What I need is a command that only compares the file name and structure of it and not the contents of each…
Fukkatsu
  • 149
  • 1
  • 12
2
votes
3 answers

Backup & compress specific tables/columns from extremely large MySQL database onto different server

My goal is to run a daily backup (overriding the previous day's backup) of specific portions of my database so I could easily download it and import it and have all my important data if anything goes wrong. I currently have a 20GB web server…
Andrew
  • 959
  • 14
  • 31
2
votes
1 answer

Mysql optimal ways of taking backup

I have requirement were I want to following things Mysql Full database backup Mysql Incremental backup Database that I am using is mysql. Regarding first requirement,i want to take a backup of entire table which includes one transaction table…
vmb
  • 2,878
  • 15
  • 60
  • 90
2
votes
0 answers

SQL Server - how to backup whole database except for data inside some tables?

I need to backup a database but leave some tables empty (not to backup their records). The scheme should stay the same, and the rest of the tables should stay populated. Is there a way to do so using .NET SMO or command line (batch is just as good)?…
Shay___
  • 163
  • 9
2
votes
2 answers

GitHub: "Some uncommitted changes would be over written by syncing"

I am attempting to update my project folder on my laptop. I was working on it on a iMac and my latest version is on that as well as on GitHub. When I attempt to sync it to my laptop I am getting the following error: Some uncommitted changes would…
Lonergan6275
  • 1,938
  • 6
  • 32
  • 63
2
votes
1 answer

How can I programmatically create a backup of my iOS Calendar and of the Reminders in iOS?

In the Mac Calendar app, I can save a backup archive with all calendar entries and all reminders. The backups file has the extension .icbu. Questions Is it possible to create this file programmatically on iOS? How can I programmatically restore…
John
  • 8,468
  • 5
  • 36
  • 61
2
votes
3 answers

svnadmin dump in git

I'm in the process of moving a bunch of my work from personal SVN repo's to git repo's. I've had a cron job setup that runs svnadmin dump every night on all my repos into a remote folder. Is there similar functionality in git? Also, I don't fully…
Corey Hart
  • 10,316
  • 9
  • 41
  • 47
2
votes
1 answer

how to send an email alert if backup fails via SQL Job

I'm going to run via a SQL Job a backup which will back up 4 databases. What I want to do is to be able to send an email via my Database Mail profile if any of the backup's fail. Now I know there is a very obvious way of doing this on the job…
user2841861
  • 423
  • 2
  • 8
  • 22
2
votes
1 answer

Backup ZFS pool metadata

Where does ZFS store metadata about pools (how they are use - as mirrors, RAIDs, etc.) on a Linux system (I'm on Ubuntu 13.10 now)? I would like to be able to recover from data destruction in the following scenario: everything runs on one Linux PC…
Kalle Richter
  • 8,008
  • 26
  • 77
  • 177
2
votes
1 answer

Mercurial between server and local?

I have a portal development work in process... I had some troubles time to time like losing, overwriting wrong files, etc... So I decided to go for Mercurial for this development. My first experience with Source Control. I work on server [bluehost]…
designer-trying-coding
  • 5,994
  • 17
  • 70
  • 99
2
votes
2 answers

Restoring to an old git checkout while keeping attached to a branch

I am deploying application to a production server by running git pull on that production server. As part of a backup, I am thinking of an idea to just store the current commit hash instead of copying all the files. Later on, during the restore, I…
alik
  • 2,244
  • 3
  • 31
  • 44
2
votes
4 answers

How to back up wordpress site to be restored after a clean installation

My Wordpress blog appears to have been hacked and now blogs do not save and any changes I make such as approving a comment do not have effect. I am trying to backup my website so as to uninstall wordpress and perform a clean re-instillation. I want…
KBP
  • 1,500
  • 2
  • 14
  • 14
2
votes
0 answers

Cordova 3 how to backup the web sql file

what is actually the best solution or best practice to backup a web Sql file of a iOS / Android based App? I have developed a routine to export the whole content of the sqlite tables in a collection of queries to re-populate and overwrite the…
sasha
  • 365
  • 1
  • 15
2
votes
1 answer

How do I back up a SVN repository with rsnapshot, when the timestamps differ every time?

I want to have rsnapshot backup a local on-disk SVN repository on a Linux machine. I know I can't just back it up off the file system, so before each snapshot I am making a copy with 'svnadmin hotcopy'. However, every time I do a hotcopy, the…
crb
  • 8,132
  • 6
  • 37
  • 48