I have a php script to backup automatically cPanel and upload the .tar.gz concurrently to an FTP server. The script works fine. The script requests the file then starts the ftp transfer and when the upload is complete it send also a confirmation email. The only problem is that even if the backup is, for example, of 1GB the uploaded fi...
Background: I have a site built in ASP.NET with Sql Server 2005 as it's database. The site is the only site on a Windows Server 2003 box sitting in my clients server room. The client is a local school district, so for data security reasons there is no remote desktop access and no remote Sql Server connection, so if I have to service the...
iTunes creates a file, Manifest.plist, in the backup directory which amongst other things contains a list of files and a data hash values for each file. The data hash does not seem to be a straight forward SHA1 of the file data. How is this value calculated? ...
Hi there I want to backup my database with compression. This is my code : BACKUP DATABASE dbbbb TO DISK = N'C:\\dbbb.bak' WITH COMPRESSION this running correctly in Sql Server 2008. But my server has Sql Server 2005 and COMPRESSION is not a recognized BACKUP option in 2005. How can i compress my backup in 2005 Thank you for your he...
While i'm sure i can write a CRON to do this and some how open the ports on a network hd in my house, to be honest i'd rather spend a bit of money on some good software with a nice visual interface! are there any such all-in-one server backup systems? nightly backups of the MYSQL db weekly backups of entire site (images etc) my serv...
Scenario i want to take backup from 7 client database to 1 server database. i dont know structure of the db { either server or client db }. both databases are having old data. now i have to make the tool take the backup for that. and should possible to backup old data also[if any updates done on old data.] please help to find the soluti...
If I make a database backup job, where I set Expire day = 2. Run this backup job once every day. How can I delete backup sets that are more than 2 days old? I'm Using SQL 2005 Express, so everything runs as script. This is the script running: BACKUP DATABASE [DatabaseName] TO DISK = N'C:\Temp\DatabaseName.bak' WITH RETAINDAYS = 2, NOF...
I write some code with PHP to backup database. Here my code: exec("mysqldump --opt -h localhost -u root test > mydb.sql"); But I get 0-byte in my file (mydb.sql). I also run with passthru(), system(), but it still gets 0-byte. I try to use command. It works. I use the lastest XAMPP for my localhost. So, how can I do to make it wor...
What is the best/secure way to backup a mysql database on windows server (2008)? I have "MySQL Administrator" but that requires that you save passwords for backup project. I'm not keen on doing as anyone gaining access to the server would then have easy access to the database. Can you do anything similar to SQL Server like using Windows ...
Hi all, I have the following situation: I am using JPA to perform database activities. however, I want that after I made any changes to my entities and before I commit those changes, the current tables which are mapped to the current entities are automatically backed up so that I can keep my history data? Anyone has some ideas, please...
I need to backup automatically daily my database in mysql and all image files on the server. Is there a way to backup these things and send it on my email address ? ...
So I noticed that one of my log backups is about 1000x larger than normal. I'd like to see what is in there. Is there something I can use to read it? Thanks! ...
Hello, I'm evaluating Team Foundation Server 2010. I would like to know if there is some command line to backup my TFS data. I currently have a folder sent to the cloud. This backup contains all the data I need to back up (like MySql databases, word documents, ...) What I want is a way to automatically backup my TFS collections (and a...
Yes it's Windows sorry. I'm using mysqldump with the option -T which creates a sql and a txt file per table. mysqldump -u user -ppass db -T path I use that option to be able to restore easily one table. Now I'd like to restore all the tables. mysql -u user -ppass db < path/*.sql Obvously doesn't work Also, I don't know where do ...
Hi, I need to backup my SQL Server 2008 database to another PC on network. I've even mapped network drive and assigned it another driver letter. But when I try to select .bak file while exporting, only C: shows up. I've even restarted my SSMS. Can somebody point out what else I may need to do? Thanks! ...
I have sql backups copied from server A to server B on a nightly basis. We want to move the sql server from server A to server B without much downtime, but the files are very large. I assumed that performing a differential backup and restore would solve the problem with the databases. Copy full backup from server A to copy to server ...
How can I do daily backups for my VisualSVN Repos? Its on a Windows Server 2003 machine, I was thinking about just doing an xcopy of the folder C:\Repo but I'm not familiar enough with svn to know if that will cause issues. Save me SO! ...
I'm currently using mySQLdump to backup my dev machine and servers. There is one project I just started, however, that has a HUUUUUGE database that I don't really need backed up, and i'll be a big problem to add it to the rest of the backup cycle. I'm currently doing this: "c:\Program Files\mysql\MySQL Server 5.1\bin\mysqldump" -u roo...
So, you build a great shiny cloudy 2.0 website on top of AppEngine, with thousands upon thousands of images saved into the datastore and gigs of data at the blobstore. How do you backup them? Ok, so this is how to do it: 1/ Add this to the app.yaml (and update the app, off course): - url: /remote_api script: $PYTHON_LIB/google/appen...
The docs say appcfg.py --dump --app_id=<app-id> \ --url=http://<appname>.appspot.com/remote_api \ --filename=<data-filename> The thing itself barfs: Usage: appcfg.py [options] <action> appcfg.py: error: no such option: --dump $ cat /usr/local/share/google_appengine/VERSION release: "1.3.4" Thoughts? ...