Stack Overflow
Stack Overflow

Questions tagged [database-backups]

database-backups are intended to preserve data by serializing database tables to a text format or exporting them to a binary format

database-backups are useful for archiving, upgrading, replicating, and migrating data

References

1580 questions
0
votes
1 answer

When backup run on the schedule time 12am every night, It says the backup job completed successfully but I cannot see the backup file on the drive

Anybody have any solution for this. When backup run on the schedule time 12am every night, It says the backup job completed successfully but I cannot see the backup file on the drive. Job Message Details Date 10/6/2013 12:00:02 AM Log …
Dharmedra Keshari
  • 21
  • 1
  • 3
0
votes
1 answer

how to save any file in specific folder in c# programatically

I want to save my backup file in specific folder. currently I'm using a saveFileDialog box to give path and file name on a button click. But I want to create this backup by giving name as (DateTime.Today.Date.ToShortDateString()) and save this in…
Sonu_Orai
  • 377
  • 2
  • 7
  • 17
0
votes
1 answer

Restore Oracle database on a different Pc

I have been using Oracle XE and has a backup of the app folder containing all the database Objects I need to restore this database on to a different Machine Bu I cant find a way to do this. I have tried to reinstall Oracle on the new PC and replace…
Stanley Mungai
  • 4,044
  • 30
  • 100
  • 168
0
votes
1 answer

Backup and Truncate-Mysql

I have a requirement that there is one MySQL table with 50 million rows of data.I want to take backup of last month data and want to insert to a new table.After successful backup,that much data need to be truncated.Each second I am getting packet…
vmb
  • 2,878
  • 15
  • 60
  • 90
0
votes
3 answers

Is relying on Rackspace Cloud Server backup images an okay way to handle mysql backups?

Rather than running mysqldump (e.g.) every morning, would it be fine to just rely on the daily server image backups that Rackspace Cloud Servers do? Or, is there a future headache that I'm not seeing?
celwell
  • 1,634
  • 3
  • 19
  • 27
0
votes
1 answer

backup command issue from linux server using ssh

I am mewbie for ssh and mysql commanding. I have a issue with taking backup from one linux server to another linux server using passwordless authentication. I already generated the key for passwordless authentication and upload it to another…
Ghost Answer
  • 1,458
  • 1
  • 17
  • 41
0
votes
1 answer

Got an error on mysql database backup time

I have mysql database (mysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 5.1) on my host server. I want to take backup using SSH. So I login by root user and go to mysql and write the command as below mysql> mysqldump -u username -p…
Ghost Answer
  • 1,458
  • 1
  • 17
  • 41
0
votes
1 answer

Replicated Sharding in mongodb

Hey i got a mongodb setup with 3 shards each with 3 replica running on 3 physical servers.The sharding is based on a category id on range so that data is even within the shards The data i get each week onto the database is huge and i am only…
Jiby Jose
  • 3,745
  • 4
  • 24
  • 32
0
votes
2 answers

How am I supposed to back up the data that my app is storing in the datastore of GAE?

I have a form application deployed on Google App Engine. It also uses the High Replication Data-store. I wish to backup the data. I went through this link but the in the answer the link is not really helping me (answer link). Other answers are using…
Animesh Pandey
  • 5,900
  • 13
  • 64
  • 130
0
votes
1 answer

how is c# sqlite database daily backup

how is c# sqlite database daily backup ? (automatic everday) On a project I want to take backup of the database every day I am writing with c # sqlite database server how can
volkan koç
  • 13
  • 4
0
votes
1 answer

Backing up MySQL DB... Proper way to escape strings?

So I am backing up my DB with the following code: $rows = $this->_getDb()->fetchAll("SELECT * FROM $table"); foreach ($rows AS $row) { foreach ($row AS &$value) { if (!is_numeric($value)) { $value =…
Jason Axelrod
  • 7,155
  • 10
  • 50
  • 78
0
votes
1 answer

Archiving/Snapshot of database data in SQL Server

I am looking for a functionality where I can take a snapshot or archive the specific set of data in database and whenever requried I need to go back to the archived state, how can I achieve this ? for more clarity on the need, below is the detail…
Abhinay
  • 338
  • 1
  • 7
  • 22
0
votes
1 answer

Why do I get "ORA-00922: missing or invalid option" while exporting data from an Oracle schema?

I am running an export from Oracle 11g: $ expdp system/ELIDED JOB_NAME=exp_BTM2CATS SCHEMAS=BTM2CATS file=btm2cats-%u.dmp DIRECTORY=DP_DIR filesize=1900M CONSISTENT=Y DIRECT=Y Export: Release 11.2.0.1.0 - Production on Wed Jul 31 22:44:29…
mormegil
  • 1,811
  • 1
  • 20
  • 22
0
votes
1 answer

SQL Server 2008 Auto Backup

We want to have our test servers databases updated from our production server databases on a nightly basis to ensure we're developing on the most recent data. We, however, want to ensure that any fn, sp, etc that we're currently working on in the…
Chris Klepeis
  • 9,783
  • 16
  • 83
  • 149
0
votes
1 answer

Programmatically changing backup file path of a Back Up Database task on SSIS

I have an SSIS package which only includes one task: Backing up of a database. I can change the database to be backed up programmatically (C#) without any problems by changing the connection to be used and/or the connection string. The problem…
schlingel
  • 1,514
  • 2
  • 15
  • 24
1 2 3
…
99 100