I have a backup server that automatically backs up my live site, both files and database. On the live site, the text looks fine, but when you view the mirrored version of it, it displays '?' within some of the text. This text is stored within the news database table. Here is a screen shot of it being on the live server and of it on the...
It currently is 700MB but it's conceivable that it'll grow beyond the 1GB. Normally I just copy this file to another location (for the curious, it's the database of a Zope instance, a ZODB file). This file changes little from day to day, but I understand Bacula can't do inside-the-file subdivision for incremental backups. Anyway, it doe...
I've got a couple folders of personal scripts and such I'd rather not lose if the hard drive on my dev machine goes out (all the source is in SVN, and all the other important stuff is backed up elsewhere as well). What's the easiest way to back up certain folders to another local HD at something like 2AM every morning? ...
At work I use something called team foundations services. It's a source saving tool that stores change sets of code I "check in". Is there a similar product that's good for a single programmer. Something I could use at home. Easy to set up and use is a must. Free is a plus but I'd of course pay for one. edit I suppose I should hav...
How do i backup a SQL database using PHP. Is there a vendor agnostic way to do this that conforms to ANSI SQL? If not maybe you can list how to do it for each of the database vendors? ...
I need to backup the original data from a table so I can fill it with test data, then restore it again after deving / testing etc.. Anyone know any quick ways to achieve this? I'm on SQL Server 2005. Thanks. ...
Anyone using MozyPro to backup SQL Server databases? I'm concerned about the way it does the backup. It just copies data files the way they are. Not using the backup database command. Is it safe? ...
Are there major advantages to InnoDB hot backup vs ZRM snapshots in terms of disruption to the running site, the size of compressed backup files, and speed of backup/restore on a medium-sized to largish all-InnoDB database? My understanding is that InnoDB's approach is more reliable, faster, does not cause a significant outage when runn...
What's the easiest way to get the data for a single table, delete a single table or break up the whole dump file into files each containing individual tables? I usually end up doing a lot of vi regex munging, but I bet there are easier ways to do these things with awk/perl, etc. The first page of Google results brings back a bunch of non...
I'm a developer so I'm a little lost in the DBA world. Our systems guys have given me a backup of an Oracle 9i database. I have installed oracle 9i on my pc and am now trying to 'import' the backup files so I have a normal database to work with. The backup folder has on SNCF[SID].ora file and around 150 [SID]-[Date]-[counter]-[soemnum...
As a followup to this question I'm wondering what your SQL Server backup/maintenance plan is, and how I can make mine better. Currently I'm running two plain-jane maintenance plans from the plan wizard. The first runs nightly and does just about everything ... Full database and transaction log backup integrity check, rebuild index, r...
I'm working on developing a regular dump of our database. I'm using this script to create the backup and then feeding it through a regular cron job. In the end we end up with a text file as well as an email archive of everything. The problem we've encountered is the size of two of our tables. They each have 60k fields and grow daily. ...
I've got a backup made using the regular SQL Server 2005 backup command. Is there a way to restore just a single table, not the whole DB? ...
The short question: Is it safe skip ib_logfile* files while creating custom-made backup of MySQL installation with InnoDB engine used? Custom-made backup is just copy all (or subset of) /var/lib/mysql + /etc/my.cnf to safe place. As I know ib_logfile* files are recreated by MySQL on start + the files are really huge, so that may not be...
We are looking for a free solution to compress our SQL Server backups for SQL Server 2005. I am aware of SQL Safe freeware edition, but I was wondering what others thought of storing backup files in compressed folders to achieve the desired result. This would allow us to use the native SQL backup tasks and native windows compression, t...
I want to implement an automated backup system for my site's SQL Server 2005 DB that will backup nightly to Amazon's S3 service. But since S3 charges both for space and bandwidth used, I would like to minimize the size of the files that I transfer in. What is the best way to achieve this? I should clarify that I'm not really talking so ...
OS: Windows. For my personal stuff I just use hotcopy once a week but for a more mission critical repo(s), that includes many developers, is that enough? Or should I spend the time to put together a more rigorous backup strategy that includes full dumps and incremental dumps? edit: I guess I should have been a little more clear. Ho...
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've got a maintenance plan that executes weekly in the off hours. It's always reporting success, but the old backups don't get deleted. I don't want the drive filling up. DB Server info: SQL Server Standard Edition 9.00.3042.00 There is a "Maintenance Cleanup Task" set to "Search folder and delete files based on an extension" and...
what tool do you use if you want to synchronise a workspace between two PC's? For example you have a work PC and a laptop and would like to switch easily between working on one and the other at the end of the day. The Work PC has network (subversion) access, and the laptop does not so I am looking for some way to synchronise files betwe...