backup

How can I backup a remote dedicated Server 2008 to my own computer at home?

My server 2008 has mysql databases, SQL Server databases, and multiple websites. How do I back this information up? I have setup the dedicated server to have two 300GB hard drives and they are both mirrored. I want to make sure that I have a backup somewhere else as well. If it's not my home server, I don't mind backing up somewhere el...

Volume Shadow Copy in C++

Hi, I'm developing an application which will need to copy files that are locked. I intend on using the Volume Shadow Copy service in Windows XP+ but I'm running into a problem with the implementation. I am currently getting E_ACCESSDENIED when attempting calling CreateVssBackupComponents() which I believe is down to not having backup ...

VisualSVN Server: taking backups using svnadmin tool

I have installed VisualSVN Server on Windows Server 2008. I was trying to create a hotcopy backup using svnadmin tool. It seems that I don't have this tool installed: C:\>svnadmin hotcopy C:\Repositories\Develop C:\temp\svnbackup 'svnadmin' is not recognized as an internal or external command, operable program or batch file. Does Visu...

How to upload large SQL Files?

Hi I have a large sql file < 600 MB. This files is backup for forum and I want to upload it to empty db. How I can upload it?? I can't use PHPMyAdmin? and I used BigDump and it doesn't insert all tables. How to do it?? Is there any other way? Thanks EDIT : I don't have access to command line, I just have my CPanel ...

Subversion: how to take incremental backups?

I installed VisualSVN Server on Windows Server 2008. Now I would like to create a repository backup plan. My intention is to create full hotcopy bakcup (using svnadmin hotcopy and then incremental backups. How to do a incremental backup using svnadmin.exe? Or should I take only svnadmin dump backups? ...

Export to CSV and Compress with GZIP in postgres

Hello, I need to export a big table to csv file and compress it. I can export it using COPY command from postgres like - COPY foo_table to '/tmp/foo_table.csv' delimiters',' CSV HEADER; And then can compress it using gzip like - gzip -c foo_table.csv > foo.gz The problem with this approach is, I need to create this int...

Subversion: dump backup, do I need incremental backups?

I'm a subversion noob. I was plannig to take backups from the repo using this command: svnadmin dump C:\Repositories\Dev > D:\backups\repo_dev.bak My intention is to put this into Scheduled Task (Windows Server 2008) and run this on daily or weekly basis. Can I use this command only (old backup is replaced by the new one) or do I need...

oracle database move current server to another machine problem

Hi ALL these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then want to install same database to another new windows 2003 server ,this windows 2003 server is all different server, computer name...

Actually im developing a vb .net desktop app that needs to restore a database using a .bak How to do that?

Im getting this: "Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally." First the message told me i must connect to master db to execute the restore but i change it and i got the message above. The parametrized sql statement im using is : cmd.CommandText = "RESTORE DATABAS...

ubuntu bookmarks

Hi, I want to backup my ubuntu bookmarks (not browser bookmarks, but the ones in the places pane in nautilus). However, I can't find any application that does it already or any info on where bookmarks are stored and how. Can anybody tell me a way in which this can be done? Any suggestions about a script is also welcome. ...

Taking a MySQL snapshot and recreating the database?

If a snapshot of the database is taken, can it be copied over to another drive and re-created? ...

How to backup source repository and zip destination folders ?

All sources are on windows OS, and destination backup is on Unix system (we are using Samba). My source repository is similar to : -Repository --Folder1 ---Files --Folder2 ---Files etc... I would like to get a destination similar to : -Repository --Folder1.zip --Folder2.zip etc... After first backup, I only backup files that h...

Looking for a backup solution to back up partially a database and select folders from an online host

Hi guys, I wasnt sure where to post this but nevertheless I'm looking for a solution to take backups of partial databases i.e a select set of tables from a database like a SQL file and download it to a local disk on a periodic basis plus a solution with which I can download an archive of select folders from a web host - that too periodic...

Python, sqlite -Any backup methods that include the index as well as the indexes table?

I see by this question - http://stackoverflow.com/questions/4019081/copy-a-sqlite-table-from-a-disk-database-to-a-memory-database-in-python - that sqlite tables can be transferred from one database to another. I was wondering though, do Any of those methods also copy the index,can they be modified to copy the index, and are there any oth...

back-up database in Linux partition from windows partition!!

Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since we know that there is no track back process in linux, all I get now is a blank terminal screen at the start up. Even if I login, I still am ...