I'm a solo developer, working in a local Git repository. For backups, I want to send an exact copy of that repository off to another server. Is it sufficient to do this? git push --mirror I'm asking because I can sometimes run this command two or three times before Git tells me "Everything up-to-date", so apparently it's not an exact...
My question is straight forward, how can I program SQL SMO to take local backup, by connecting to a remote server. I want to save the bak file to a local machine which is connecting to the remote server. Also I want users with only certain privilege to be able to save backups locally. ...
Hi, I am working on C#.Net product. I am using VisualSVN source control server. I want to take sourcecode backup on every week from VisualSVN server. I don't have any idea taking backup. thanks ...
I am running this code: include '../includes/connection.php'; $conn = dbConnect('backup'); $tableName = 'orders'; $backupFile = '../backup/db-backup(' . $date . ').sql'; $query = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName"; $result = $conn->query($query) or die(mysqli_error($conn)); I am getting this error: Access...
I just migrated a SQL Server 2008 database while the sales staff went to lunch. I did a full backup and then copied the backup to the new server where I restored it to the new SQL Server installation. The staff got back from lunch and told me that a few of the recent deals they put in right before lunch were no longer showing up in the ...
I have sharepoint sites provisioned on two machines A and B. I would like to take the content database from machine A and restore it into the site on machine B. I used SQL backup to backup machine A's database, and restored it to machine B, overwriting the existing content database. However, my sharepoint site became unreachable - I woul...
I am working on an update for my new iphone app (FlashCards++) which will include the ability to back up & restore the core data store (sqlite). I have been looking for good options for how to do this but there are very few resources about this. What are the best practices that you have found for doing core data backup? I'd like to keep ...
Hi, For an automated web-backup solution we're thinking of, how can we access and copy a "locked" file from a user's system onto our webserver? This is of course with the user's permissions. Just seeking code that demonstrate this. Added: I know where the file is located, I do NOT want to prompt the user to select the file everytime. ...
Hi, I am not a server person and I am having issues with this particular transfer. I have transferred accounts in the past with success. With this particular transfer, I always come across this error: ERROR: tar of split archive ran out of space I increased the quota on the old server for this account but that did not correct the iss...
I need to back up my database but I don't have enough disk space to dump it. Can I just use duplicity to perform incremental backups on the data directory? Would that corrupt the backup somehow? I don't mind a few of the latest rows missing, but I would like my backup to not be destroyed. Does anyone know what the case is? Thanks! ...
I recently picked up a phone running android 2.1, and I have rooted it and I keep trying out new roms. My big problem is that I keep having to manually copy my files from the phone to my network share. I tried Titanium Backup, and it worked well enough, but I still have to move files from the sd card to a different location. Does anyo...
I do not have a backup available but I wrote over an existing database with a backup file. The problem is the one I wrote OVER had a Stored Proc that I need to get back. Any way to do this without a backup file of the database with the Stored Proc in it? ...
I would like to verify my Core Data store (SQLite file) before loading it so that if there is any corruption, the app won't simply crash and burn. Using the iPhone SDK, is there a way to verify an SQLite file (1) generally that it is not corrupted, and (2) more specifically, whether or not the SQLite file matches one of the possible data...
I am creating a bash script to backup my files with rsync. Backups all come from a single directory. I only want new or modified files to be backed up. Currently, I am telling rsync to backup the dir, and to check the files compared to the last backup. The way I am doing this is THE_TIME=`date "+%Y-%m-%dT%H:%M:%S"` rsync -aP --link...
I have a decent sized PostgreSQL database (approx 6GB & growing). A full backup/export of the database is done every few hours via cron & pg_dump. Specifically, can I export only the changes to the database since the last export? Or perhaps run a utility that compares the two exports and appends the differences to the original, etc? I...
I use tar --listed-incremental=... to perform incremental backups on my computer, and for the most part it works like a charm. However, it doesn't seem to play well with my old FAT partition. It thinks that all the files have changed and backs up everything. I read somewhere that tar incremental backups rely on inodes, and that's why ...
Hi all, after googling for a long time, I decided to ask this: I've uploaded a site to a shared hosting that does not allow remote DB connection due to security issues (according to them). the Data is very important to me and I'd like to back it up automatically on a daily basis (in addition to the hosts daily backup). I'm writing the ...
Hi there, i entered a company who runs an intranet page using wss 3.0. The guy who set it up isnt around anymore and there is no one else with any knowledge about wss so i was asked to get a feel for it. Working on Sites is pretty easy but i dont know anything about settings etc. I noticed that they never did any backups and looked in...
The problem is that I need to explain the different sizes of backups that are being made of a database in a plant. Sometimes the difference between the sizes is in negative, even though that there is no data being deleted from the system. Datum Backupfile-file Size KB Diff 6/1/10 backup201006010100.bak 3355914 ...
Hi-- I'm trying to script a backup system for several servers, some Windows, some Linux. I'd love to be able to use rsync but I can't (at least not in all situations, since some servers I can't install rsync to, and some are Win servers). I've tested with wget in FTP mode with the "timestamping" option, and it seems to work pretty well ...