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

How to Backup of my tables in Mysql Database using C#

I'm having around 150tables in my Schema. In that few tables are master table it will be around 20 tables. Without taking the backup of other tables i want to take the backup of Master tables only and i have to achieve this through C# code. I'm…
user3793188
  • 1
0
votes
1 answer

Create and restore specific objects

I'm using microsoft sql-server 2012 for my application. I use "create and restore" backup commands but when I restore backup, all objects will be restored such as stored procedures. How can I create backup and restore it only for specific objects of…
Babak.Abad
  • 2,839
  • 10
  • 40
  • 74
0
votes
1 answer

PHP postgres backup

I am trying to make a Postgres PHP backup script. I have downloaded one for the command line which looks like this: #!/bin/bash find /home/russell/pg_bkp -type f -mtime +7 -exec rm {} \; time=`date +%Y-%m-%d`; # date in reverse so that lastest date…
russell kinch
  • 59
  • 2
  • 5
0
votes
1 answer

trying to restore a production postgresql db into dev box

I'm running the following command to create a dump of all database on my production server: prodserver:/# pg_dumpall -U postgres -h 1.1.1.1 > prod.sql on my development box, I also take a backup by doing: devserver:/# pg_dumpall -U postgres -h…
dot
  • 14,928
  • 41
  • 110
  • 218
0
votes
0 answers

Simplest LAMP incremental backup solution?

I have a VPS which has daily offsite backups of the entire system, so that is in order! However this server is running a community wiki-site powered by the LAMP stack on an Ubuntu server and we wish to have a local, more frequent backup solution…
Amivit
  • 189
  • 2
  • 4
  • 15
0
votes
1 answer

Reduce database restore time

I have a database backup file of 4.78 GB. When I restore it on any machine, it takes a lot of time (15 - 20 mins to be precise) to get restored. The mdf file of the database is of 5.64 GB and ldf is of 100mb. There are lots of tables and lots of…
Hitesh
  • 3,449
  • 8
  • 39
  • 57
0
votes
1 answer

Dump of one namespace of a GAE app and replicate in another namespace at another GAE app

I have a saas web application running on gae with multiple namespaces. We also have a staging environment on a different application_id. Sometimes it would be very useful (for debugging) to be able to replicate production data in the staging…
taciogt
  • 11
  • 1
0
votes
1 answer

How to auto backup MySql database periodically in winforms?

In winforms application I want to backup my database once for every week. How can i do this. Can it be done through Coding or should I go for batch file? And the backup must be done automatically with out any user interface..
user3652753
  • 1
  • 2
0
votes
1 answer

Backup database through function in PostgreSQL

Here i have sql server query to take backup of database using stored procedure as shown below: Example: CREATE procedure DISKBACKUP @location_dump varchar(255), @databasename varchar(255) AS backup…
Sarfaraz Makandar
  • 5,933
  • 16
  • 59
  • 84
0
votes
1 answer

How to take sql server database backup till a perticular date?

In our project there are two databases 1)Transactional 2)Warehouse. Based on some retention timeout the data will be pushed from Transactional to Warehouse DB.So now i want to take the backup of the Transactional DB backup till a particular…
Ravi
  • 225
  • 1
  • 15
0
votes
2 answers

Scheduling SQL Server database backup and sftp it to a remote machine

My goal is to automate a scheduled daily backup of a SQL Server database and send it to a remote machine with sftp. How hard can that be? The first step to schedule a local backup of the database was "fairly easy" using the built-in utilities for…
Andreas Zita
  • 7,232
  • 6
  • 54
  • 115
0
votes
1 answer

Mysql database backup

we have a mysql table which consist of 300 million rows. The data get inserted in the database frequently and there must be no down time. What is the ideal way to back up these data. Is mysql Enterprise back up is a good option?
user3580984
  • 1
0
votes
1 answer

Specify Cloud Storage bucket of different project for datastore backups?

I'm trying to setup Datastore backup on our AppEngine project, but I was wondering if it's possible to specify a bucket that's outside of the AppEngine project? In the docs, it's not mentioned that it has to be in the same project. But it doesn't…
john2x
  • 22,546
  • 16
  • 57
  • 95
0
votes
0 answers

Backup mysql database in multiple files in transaction

I'd like to backup my database automatically but store each table in separate file. I've found a simple script here: http://www.jamescoyle.net/how-to/1167-export-mysql-database-into-separate-files-per-table. However problem with this is that the…
enumag
  • 830
  • 11
  • 21
0
votes
1 answer

How to create FTP account in nopCommerce Admin Panel?

I am new in nopCommerce. I need to download my website from server using nopCommerce admin panel. As i go through the different forums and come to know, that i have to create some FTP account and then i ll be able to download the full backup of my…
Moaz Saif Sipra
  • 41
  • 1
  • 3
1 2 3
…
99 100