Could you people tell me how to zip specified files into same Zip file. Let me tell how my folders are filled : A task scheduler have backups of my databases and save them into a file daily. It creates 4 database backup daily which means there will be 4 more files daily. So I need to zip newly created backups into same zip file (of cou...
I currently use Amazon S3 as a backup location for my local machines - Primarily using JungleDisk to backup nightly all my local files to my S3 account. I have been looking at creating a more intelligent backup solution for remote files - Websites on Windows and Linux boxes, along with SQL Server and MySQL databases. I have been ponder...
We are building an ASP.NET application (with C#.net as language) and will be hosting on Windows Server 2003 Operating System with SQL Server 2008 as database. We are planning to take the incremental database backups to a disk and use them to restore whenever there is a necessity. So would you please guide me on this, if you have an ide...
Here is the scenario: Oracle 10g database running Windows Vista Business. This is a production/live db. Nightly backups (Whole database, online backup, ARCHIVELOG mode) moved to different machine on the network. Hard disk dies. Setup OS and Oracle 10g on the new hard drive. Oracle does not have any db instances yet. Is there an eas...
I am trying to write a PHP program to automatically created backups of MySQL tables as sql files on the server: $backup = "$path/$tablename.sql"; $table = "mydbname.mytablename"; exec( sprintf( '/usr/bin/mysqldump --host=%s --user=%s --password=%s %s --quick --lock-tables --add-drop-table > %s', $host, $user, $passw...
I have a SQL database that I am currently converting from an Access database. One of the features of the Access database is to 'Copy DB' and is used when working in a 'dev' site - it copies all of the production data by physically copying the production file into the dev site. In this way, all production data and structure and queries ...
I wanted to know the frequency at which different shops are backing up their repositories. I have heard some even go to the extent of every 5 minutes to prevent from having to worry about after a restore, going through everyone's local Projects to find and merge in any uncommitted changes that are missing after a restore. How big is y...
--BEGIN RANT-- ALL I want to do is copy the "Documents and Settings" folder to back it up in Windows Server 2003, so we can grab old files from it, as needed, easily, after I wipe the server to upgrade the OS to Windows Server 2008. BUT, I get errors about NTUSER being in use, etc., when I try to copy it. It's VERY irritating that an ad...
I never know what to do when my Wordpress installation tells me there's an update available. I am using version 2.8 so whenever there is an update, all I have to do is click update, some magic happens behind the scenes, and it gets updated. But should I create backup files? And how? I have custom themes and plugins that I don't want to g...
I have a SQL 2008 DB. I am running a form that backs that DB up, then tries to update it. If the update fails the idea is to restore that backup. Here is the code I am using to restore the backup. public void RestoreDatabase(String databaseName, String backUpFile, String serverName, String userName, String password) { Restore sqlRe...
So, you're on to a new project and have already invested quite some time in it. Suddenly your hard disk breaks and you have lost all your hard work. Or not? Did you make sure that the code can be recovered in some way? Do you backup frequently, manually or automatically? How do you do this? Personally, I am trying to remind myself to m...
I am actually pretty new to this batch file thing. I know it's important to know at least the basic commands. Could somebody help me figure out how to do the following? Zipping a specified folder. Move the folder to another place. When zipping it, the zip file name will be the current date and if there is another zipped file with the ...
Hi, Oracle 10g on Suse 9.1 I'm looking after an Oracle DB. I have good SQL skills but I'm no DBA, (a diffence in job roles I have difficulty explaining to my non-IT savvy bosses!) I know enough to get Oracle up and running and put in place it's 'automatic' options for backup and optimisation then I leave it well alone. Everything else ...
Hi Chaps, Bit of a newbie, so please excuse the lack of terminology. . . . I have a PHP script to backup a MySQL database "dbjobs". I've tried nearly everything I can but can't get it to work. It works if I run the $command directly from the Command Prompt on the server, but everytime I try to run the PHP version, I get an HTTP 500 err...
I'm trying to efficiently determine if a log backup will contain any data. The best I have come up with is the following: DECLARE @last_lsn numeric(25,0) SELECT @last_lsn = last_log_backup_lsn FROM sys.database_recovery_status WHERE database_id = DB_ID() SELECT TOP 1 [Current LSN] FROM ::fn_dblog(@last_lsn, NULL) The problem is w...
I've been asked by a number of unfortunate iPhone users to help them restore data from their iTunes backups. This is easy when they are unencrypted, but not when they are encrypted, whether or not the password is known. As such, I'm trying to figure out the encryption scheme used on mddata and mdinfo files when encrypted. I have no prob...
In DB2 8.2 for LUW can you restore one tablespace to a 2nd server from a full database backup without having to restore the entire database? The database backup was taken when the system was up so log files are involved. I can provide further clarification if needed. Thanks, Dave ...
We have ZRM backups that are created using LVM snapshots. When we need to recover a database or two, we use mysql-zrm restore like this: mysql-zrm --action restore --backup-set backupSet1 \ --source-directory /var/lib/mysql-zrm/backupSet1/20060829140710 \ --databases "db1 db2" Is it possible to restore into a file instead of an act...
I am working on my first WinForms application with a Firebird database shared over a network. Now I wonder how should I ensure database backup and restoring? Up till now, my applications used embedded databases (SQLite), so I was sure that only my application accessed the database. The application itself was responsible for the backups ...
any advise on backing up millions of data? or use tips in mySQL or software to the backing up job?? ...