I'm getting pretty tired of my development box dying and then I end up having to reinstall a laundry list of tools that I use in development. This time I think I'm going to set the development environment up on a Virtual Box VM and save it to an external HDD so that way I can bring the development environment back up quickly after I f...
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 backula to get all the files on a single disk, then backs that disk up to tape, then send...
Our Development environment has many layers and is complicated to replicate or even backup effectively. Basically the File system (ie. /usr/appdir/webapp...) has other applications serving our web application, those application we update doing svn updates from their repository. The use of the web application itself (as a user) will a...
What is best practice for backing up a production MySQL database (i.e. on a live website and potentially being updated)? Some goals I have in mind are: the DB backup should be an internally consistent snapshot not lock out the website while the backup is in progress (nice to have) incremental backups of changes only automated able to ...
I have the following scenario: Our system is running a SQL Server Express 2005 database locally (on each users desktop, if you will). The system is storing a lot of production data from a machine. There are high demands on the safety of the data, and doing a backup each night, or even each hour is not enough. We need a backup strategy t...
So at work, my team is using a central SQL server 2005 database server for integration testing and I want to move to testing on my local database. The only problem is that the central database is in excess of 10 Gb. I am interested in importing the data objects and a rows for each table to ensure I can be up and running. Can you guys ad...
After finding this question, What's the best linux backup solution? I'm wanting to know what the best backup solution for windows is? I have a web application which has a decent amount of content and pages that get updated frequently and I am currently backing it up by hand. Preferably, I would like to have it backup to a specified F...
Duplicate: http://stackoverflow.com/questions/15208/whats-the-best-linux-backup-solution I am about to purchase a dedicated linux server that has 160GB hard disk and will be used primarily for website hosting. The server doesn't come with backup/restore facilities and wondered if anyone knows how / what is the best (and cheapest)...
Hi there, 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, create exact copy a database from primary server on mirror server, so when the primary server was down, we could switch database IP on application to use mirror server. I have examined "mi...
Hi All, Me and my colleague are trying to implement a mechanism to get recovery from broken files on an embedded equipment. This could be happened during certain circumstances, e.g. user takes off the battery during file writing. Orz, but now we have just one idea: Create duplicated backup files, and copy them back if dangerous file...
Hi guys is there any backup software that can take periodic backups of online website folders and store them offline on a local system. Need something robust and would be nice if theres something free that can do the job :) Thanks for the links - I have ftp access and its my website and its a bit of a documents sharing website with us...
Hy guys, i have a postgresql 8.3 server with many database. Actually, im planning to backup those db with a script that will store all the backup in a folder with the same name of the db, for example: /mypath/backup/my_database1/ /mypath/backup/my_database2/ /mypath/backup/foo_database/ Every day i make 1 dump each 2 hours, overwriti...
For my backup plan for SQL Server 2005, I want to do a full on Sunday: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT GO Then I want to do a differential nightly the rest of the week: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_Diff.bak' WITH DIFFERENTIAL GO My a...
while I find the apache portion of mamp pretty easy to backup, what is everyone using or how are you performing a scheduled backup of your mysql databases? It would be kinda annoying to export each DB one by one. thank you ...
I have a shared MS Sql 2008 database with my hosting provider and MS SQL Standard 2008 on my local box. They have the SQL Server locked down (rightly enough) but it menas I don't have sufficient privileges to use the backup database wizard or to generate scripts to create the database as a whole. To get around this I have been running ...
So I have a web system where every user gets a separate SQLite database which acts as a sort of their workspace. All of the database files are in a directory with database names that match up to the user ids. Many of these databases are created and rarely, if ever, edited. Others have many edits on a daily basis. To manage backups on t...
Hello Does someone here know if it is possible to backup only the part of a subversion reposiotory that has changed since the last backup (that is: the delta)? Practically, that could be something like doing a full backup every midnight, and a delta every hour. If then a crash occured say at 11:07, one would have to use last midnights ...
I'm researching some lightweight tools to backup a LAMP stack. The two most imporatant pieces are the php codebase and the mysql database. I can tar/bz2 the code and a mysqldump and restore it on a new server (if the old one crashes) and this is more or less fine. Anyway, are there more complete solutions to this? e.g. track and...
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 understand git, so this logic is most likely wrong, but I kept all my svn repos under a sin...
I've got a master-slave replication setup for a suite of applications. One of those applications is a forum, which writes directly to the master. The rest just read from the slave. The forum database is huge (~10GB) which causes some issues re: backups and data transfers (even a mysqlhotcopy takes 20 minutes). I want to run an upgrade...