We are using MySql version 5.0 and most of the tables are INNODB. We run replication to a slave server. We are thinking of backup the MySql log files on a dally bases. QUESTIONS: • Is there any other way of doing an Incremental backup without using the log files? • What are the best practices when doing Incremental backups ? ...
I am trying to automatically backup my SVN Repository. This is in a batch file I wrote: svnadmin hotcopy C:/myRepository G:/myRepositoryBackup --clean-logs It works great the first time. However, each time after that, I get this error: svnadmin: 'G:/myRepositoryBackup' exists and is non-empty How do I have it overwrite my old dat...
I am running a SVN server on my Windows Server and want to schedule an automated backup procedure. I will always be the only one working on the repository. Should I bother with hotcopy or can I use a simple Windows backup application to backup the repositories? What about xcopy or robocopy? ...
I've deployed MS Sql Server Express edition on a server with a database that's updated daily. It is important that I have regular backups of the database, preferably daily. But I can't hope to do this manually everyday. How can I have auto-backups of my databases on that server? A system that will preferably upload these databases to a F...
I'm using SQL Server 2008. My database is almost 2GB in size. 90% of it is one table (as per sp_spaceused), that I need don't for most of my work. I was wondering if it was possible to take this table, and have it backed up in a separate file, allowing me to transfer the important data on a more frequent basis than this one. My guess...
Are there any publicly available libraries or APIs out there on Ubuntu that allow me to programmatically archive the contents of my iPod? If no library or API exists, what alternative options do I have for saving the contents of my iPod? ...
I am developing a small business application which uses Sqlserver 2005 database. Platform: .Net framework 3.5; Application type: windows application; Language: C# Question: I need to take and restore the backup from my application. I have the required script generated from SSME. How do I run that particular script (or scripts) from m...
I admit this is not strictly a programming question, although I do use my WHS as a source repository server for home projects, and I'm guessing many other coders here do as well. Does anyone have a recommendation for a good backup solution for the non-fileshare portion of Windows Home Server? All the WHS backups I've seen handle the fi...
Does anybody know if there is default location of stored system backup in this system ? Maybe it's not on the same system, I'm not sure. The system let me do only 3 backups but it would be useful to store these backup externally. Thx for all answers ...
Hi, I think I have something broken with the path that VS 2008 saves the backup files. Since few days, it creates a new "Visual Studio 2008" directory in the same folder that my .sln file exists. Then, after the time of the first auto-save expires, the backup files are being saved to this folder. I browsed the tools-options dialog but ...
Hi Guys, We are thinking of moving from Subversion to Team Foundation Server for our source control requirements. The reasoning behind this being that our project teams are getting bigger and management feel more comfortable using a M'soft product rather than an open sourced solution (I know - I've tried to argue the foolishness of thi...
SQL Server 2000 on Windows Server 2003. I am trying to run a backup, from within EM, directly over to another server, as follows: backup database AbraEmployeeSelfService to disk = '\\servername\f$\Backup\myDB_backup.bak' I get this error: Cannot open backup device '\\servername\f$\Backup\myDB_backup.bak'. Device error or device off-...
I manage a web application for a client with the following specs: ASP.net 3.5 running on a Virtual Windows 2003 Web Server SQL Server Standard hosting the database Database current size of 6Gb, with 1Gb/month growth rate One single table is responsible for 98% of the size, holds the most critical data for the client Log is not kept for...
I have a customer that has set up a full backup of the database to an network path every 4:th minute on a heavy used database. I strongly recommend the customer to not to do that and instead do a transactional backup. But what is the possibly bad things that can happened when doing a full backup in this way? Other than that the backup ...
We have customers who, for unassailable reasons, cannot use SQL Server's built-in backup features because it backs up the entire database. These customers need to breakup and backup the database into subsets of who owns the data so the appropriate parties can backup their own data according to their own rules. My question is two-fold: ...
I have backed up and restored a MS SQL Server 2005 database to a new server. What is the best way of recreating the login, the users, and the user permissions? On SQL Server 2000's Enterprise Manager I was able to script the logins, script the users and script the user permissions all seperately. I could then run one after the other a...
Problem: Customer X is (considering) porting one of his formerly "Windows only" shareware applications to Mac OS X. One of his concerns is how to enforce the 30-day trial period and make it immune to "system rollback" software like Time Machine. Question: What is the industry best practice for preventing the use of "system rollback" sof...
We've completely lost our repository and we have 8 developers with uncomitted changes. Restoring from backup is assumed to be not possible. If one person could have access to all the working copies (either file copy or remote share) is it possible to merge changes in our working copies to one working copy? The final working copy could...
I'd like to avoid mysqldump since that outputs in a form that is only convenient for mysql to read. CSV seems more universal (one file per table is fine). But if there are advantages to mysqldump, I'm all ears. Also, I'd like something I can run from the command line (linux). If that's a mysql script, pointers to how to make such a t...
I have a mySQL database behind a Joomla install. I changed the database password because I forgot it but now Joomla crashes looking for the database. I guess joomla has the password written somewhere - if anyone knows I might be able to manual edit it and enter the new database password. Otherwise I'm hoping a manual install of a back...