hi, is it ok to set recovery mode simple in a staging db for an ETL process... The customer is not even doing a regular backup! So what's the point in keeping the transaction logs... I propose to organize a daily backup after the bulk import and that's it... Anything against this plan? Also the transaction logs were at 80gb after 3 we...
I have been struggling with Subversion for some time, thinking it was beginners problems that would go over. Though today I have been thinking through it, and realize that the problem is the way it is embedded with the client files, and that you work on the server db through these embedded files. So I wonder if: Is it perhaps just a...
Hello, I wrote a basic content-management system for my website, including an administration panel. I understand basic file IO as well as copying via PHP, but my attempts at a backup script callable from the script have failed. I tried doing this: //... authentication, other functions for(scandir($homedir) as $buffer){ if(is_dir($b...
Hi I have multiple databases need to back up daily. Currently, I am using cronjob to set a batch file to back it up. Here are my situation, I have about 10 databases need to backup, 3 of them are growing pretty fast, let me show you the current DB size: DB1 = 35 mb DB2 = 10 mb DB3 = 9 mb the rest: DBx = 5 mb My batch file code is: ...
I want to have rsnapshot backup a local on-disk SVN repository on a Linux machine. I know I can't just back it up off the file system, so before each snapshot I am making a copy with 'svnadmin hotcopy'. However, every time I do a hotcopy, the resulting files all have a current timestamp, rather than the same timestamp as the original f...
I've usually use mysqldump to export a database. However, when the database is really large, it seems much faster and less intensive to just gzip the database files directly without involving the MySQL deamon and copying that to the other database. eg: tar -czvf {db_name}.sql.tgz /var/lib/mysql/{db_name} Is this a good method of do...
We have a new filestream database that will be initially loaded with 65GB data, for which we'd like to configure log shipping to a remote (different continent) location. For the initial setup of log shipping, is there any threshold for the time between the backup of the primary and it's restore onto the secondary? The new database will ...
Hi everybody, I'm looking for ways to back up the database of my app on an Android phone. I know that SQLite databases are just files, so I'd expect to be able to just copy the file to SD-card if one is available. However, I'm unsure as to how I'd prepare my database/activity for backup/restore. When starting, my main activity reads t...
My Wordpress blog appears to have been hacked and now blogs do not save and any changes I make such as approving a comment do not have effect. I am trying to backup my website so as to uninstall wordpress and perform a clean re-instillation. I want to create a backup so that when i restore the website will appear with everything the same...
I just wrote this backup script: #!/usr/bin/bash # the number of days to do the backup for. days=5; # the files to backup. location[0]='/opt/aDirectory/' location[1]='/extra/anotherDirectory/' # the location to copy the file to copyLocation='/users/JoeBlow/Backup/backup-'$(date | tr ' ' '-') # Log stuff mkdir $copyLocation echo "mad...
How do i get all the info, products pics, settings, etc... from one magento install to another? The backup feature it has don't seem to be that great. ...
I have a portal development work in process... I had some troubles time to time like losing, overwriting wrong files, etc... So I decided to go for Mercurial for this development. My first experience with Source Control. I work on server [bluehost] for this project, is there any way to keep update backups at local? Do I have to setup Me...
I have a table in Oracle for users. I am going to install new schema and want to backup all users with passwords and other fields. I tried exp and int utilities, but imp doesn't recover anything. I created temporary user in USERS table. Then I did backup with command: exp user_owner/password file=file.dmp table=USERS rows=yes indexes=n...
Hopefully someone here can help me. I've been using a normal hosting account for my backups up until now. today they have told me I'm violating their terms and conditions. I thought it wouldn't be allowed but it's worked for the last 6 months so I just forgot about it. I'm now looking for a real online backup storage service but can't ...
We received a sharepoint backup file as part of a project. Is there any way to access the ".dat" file without Sharepoint? I've heard that some of the files created with SharePoint are .cab files, but apparently not this one. I hadn't heard of Sharepoint until yesterday, but there were 77 pages of unclosed questions about it on here s...
I have clients out there running an SQL Server Express 2005 and each of these needs a backup each month and that backup needs to be moved to our server in case they lose their backup. Our software automatically backs up the database each month but we have to manually go in and copy it across. Is there any way to automate the copying of f...
Hi all I am currently moving my SVN server from my home server to my remote server so I can access it more easily from other locations. My remote server is not backed up so I want to regularly back it up to my home server. Remote server is Windows 2003 server. Home server is Windows Home Server. What is the best way to do this? can I ...
Hi All I have My SQL running on my remote webserver. What is the best way to back this up every night to my windows home server? Thanks ...
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...
Hi guys and gals! I am looking for a smart way to take care of scheduling backups on a remote Mysql Unix/Linux server from my own personal Windows XP computer. Is there any (free if possible, preferable of course) software that i can schedule that logs in to a mysql database and downloads a complete backup? Would also need an alterna...