I would like to create a copy of a database with approximately 40 InnoDB tables and around 1.5GB of data with mysqldump and MySQL 5.1. What are the best parameters (ie: --single-transaction) that will result in the quickest dump and load of the data? As well, when loading the data into the second DB, is it quicker to: 1) pipe the resu...
What is the best method to backup large (4 GB) MySQL databases. I currently use a cron job every night that mysqldumps everything and I keep 3 days of backups. Also what backup mechanism allows me to restore a backup faster. ...
When writing code, I've noticed that different developers hit the Save button at different frequencies. This is in addition to whatever AutoSave setting has been set. Personally I have the AutoSave set to 10 minutes, and I hit the Save button whenever I type a reasonable amount of code (perhaps 10 to 30 lines). How about you guys? ...
I'm doing a webapp and need a backup plan. Here's what I've got so far: nightly encrypted backup of the SQL database to Amazon S3 and my external drive (incremental if possible, not overly familiar with PostgreSQL yet, but that's another thread) nightly backup of my Mercurial repo (which includes Apache configs, deploy scripts, etc) t...
When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need to wait for it to finish. If I kick of the backup or restore with a script, is there a way to monitor the progress, or do I just sit back and wait for it to fini...
The title is self explanatory. Is there a way of directly doing such kind of importing? ...
I have currently 200+ GB database that is using the DB2 built in backup to do a daily backup (and hopefully not restore - lol) But since that backup now takes more than 2.5 hours to complete I am looking into a Third party Backup and Restore utility. The version is 8.2 FP 14 But I will be moving soon to 9.1 and I also have some 9.5 data...
I am seeking a backup tool to back-up virtual OS instances run through Microsoft Virtual Server 2005 R2. According to the MS docs, it should be possible to do it live through volume shadow copy service, but I am having trouble finding any tool for any. What are the best solution to back-up MS Virtual Server instances? ...
Oracle database 11g. What is the easiest way to set up a full nightly database backup to a network drive (ie drive on another computer)? ...
As a Mac user I use Time Machine to backup, I have been asked to provide a simple backup solution for a friend with a PC. They have an external HD and a single laptop, I'm looking for something cheap or free that's simple to use. ...
What are your disaster recovery plans for Windows Sharepoint Services 3.0 ? Currently we are backuping all databases (1 content, admin, search and config) using sql backup tools, and backuping the front end server via dataprotector. To test our backups, we use another server farm, restore the content database (following the procedure o...
Hi, I am application developer and don't know much about virtual machine(VM). however, our application is resided on a VM. frequent patch need be apply to fix/update this application. For diaster recovery, It was suggest to backup every thing on the server. so, once server is restored, no application need be re-installed and configured....
Right now, my SVN repository is on my laptop's HDD (although I use a code hosting service for more "critical" personal projects) and I just copy the directory over on a weekly basis (which will eventually be scripted or perhaps I'll make an app for the hell of it). Am I at risk for corrupting my SVN repository? So far, I haven't had any ...
I need to do some work with a backup WSS .dat file and I'm having real trouble making it do anything. I've got it installed through stsadm and that appears to have gone smoothly, but the site now redirects me to an error page - just the classic "File Not Found" one, but in the URL it suggests the errortext would be "Class not Registered...
I was wondering what is the best free MySQL backup solution on a windows server? I am interested in backing up the data only. Constraints free solution backup should be done to somewhere outside the server windows only mysql only if you provide a suggestion with batch files & co. please add source code. thx. ...
Is it possible to restore a backup of a SQL Server 2005 database onto an instance of SQL Server 2008? I need to rebuild a server as it's getting rather crufty, so I plan to take this opportunity to upgrade to SQL 2008 and wondered if I'll be able to restore my backups OK. ...
I've create a maintenance plan on my SQL Server 2005 server. The backup should be written to another server. I'm using a UNC path for this. The user running the SQL Agent jobs has full access to the other server. It's admin on both servers. The problem is that this statement fails ( has the correct server name ofcourse): EXECUTE mas...
I'm using SyncToy 1.4 and it would be fine for what I need except that: It can't handle the assigned drive letter changing between systems (e.g. syncing a USB drive), it leaves its own (hidden) files in the folders being synched (is this a limitation of the OS/FS?), it recreates empty folders for ones that have been deleted, it syn...
Hi, I'm involved in creating a web based business solution. The idea is that the customers will use it, get their business processes and information into one place and also receive added business value by inter-system communication. In short they will use it as a core tool in their daily work and will depend highly upon it. One problem...
I need some help for executing my planned backup strategy. My database is about 1 gig in size. I want to perform a full backup once per week, and incremental every hour. Is all of this built into SQL Server 2005 Express? Is it possible to roll over the backups so I only keep 1 months of backups? Meaning the full weekly backup has 1 ...