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
16
votes
2 answers

Is it a way to backup data in Firebase Storage?

The auto backup for the Firebase Blaze plan does backup the Firebase Real-Time DB. But I can't find how to backup the Firebase Storage database for the same project where I have daily backups of the RealTime DB. Anyone knows the how to backup…
Adam Je
  • 171
  • 1
  • 4
15
votes
7 answers

Restore PostgreSQL db from backup without foreign key constraint issue

I have a postgresql db with about 85+ tables. I make backups regularly using pg_dump (via php-pgadmin) in copy mode and the size of the backup file is almost 10-12 MB. Now the problem I am facing is that whenever I try to restore the database,…
Black Rider
  • 377
  • 3
  • 4
  • 20
15
votes
1 answer

Django's "dumpdata" or Postgres' "pg_dump"?

I'm unsure as to whether this question should be posted in the Database Administrators' section or here, so please advise if I got it wrong. I have a Django-based website which doesn't change much. I use python manage.py dumpdata --all --indent=2 >…
Keenan Lawrence
  • 1,446
  • 10
  • 16
15
votes
2 answers

Disabling AWS RDS backups when creating/updating instances?

I am creating new RDS MySQL instances from snapshots and updating their configurations both via the API and through the UI. Regardless of how I create or update instances, these actions automatically trigger new snapshots to be created through some…
jmsb
  • 4,846
  • 5
  • 29
  • 38
15
votes
4 answers

Amazon RDS automated backup

I can see from the AWS console that my RDS instance is being backed up once a day. From the FAQ I understand that it is being backup on S3. But when I use the console to view my S3 buckets, I don't see the RDS backup. So: How do I get my hands on…
Mohith Thimmaiah
  • 857
  • 1
  • 9
  • 21
15
votes
4 answers

Big Database backup best practice

I maintain big MySQL database. I need to backup it every night, but the DB is active all the time. There are queries from users. Now I just disable the website and then do a backup, but this is very bad as the service is disabled and users don't…
Roman Gelembjuk
  • 1,797
  • 2
  • 25
  • 50
14
votes
5 answers

MySQL database backup: performance issues

Folks, I'm trying to set up a regular backup of a rather large production database (half a gig) that has both InnoDB and MyISAM tables. I've been using mysqldump so far, but I find that it's taking increasingly longer periods of time, and the…
Alex Weinstein
  • 9,823
  • 9
  • 42
  • 59
14
votes
2 answers

How to verify the integrity of the files that result from a mongodump operation?

From the research I have done, mongodump doesn't have a built-in check to verify the integrity of a mongodump operation; at least, nothing apparent to the user. I may be wrong. If I am, please inform me. Otherwise, I'm sure I'm not the only one who…
tlovely
  • 645
  • 1
  • 5
  • 15
13
votes
1 answer

MongoDb Hot backup - copy data/db VS replicaset with fsyncLock

I read about the different MongoDB setups for doing backup without downtime. Which strategy is best or can they even be compared? Enable journaling and simply copy the /data/db directory - it is unclear to me if this is enough – on the MongoDB home…
user1240303
  • 131
  • 1
  • 3
13
votes
1 answer

mysqldump not creating create database syntax

I am using mysql database. I am using mysqldump to create a dump of my database. I want the database to be dumped such that there is a drop database if exists command followed by create database command. I am using the following command (on my…
sasidhar
  • 7,523
  • 15
  • 49
  • 75
13
votes
2 answers

Database Mirroring / Postgres Streaming Replication

I am not a DBA; I'm the primary developer of an enterprise database based application. I'm currently specing out some new machines to upgrade our existing enterprise database. Currently we're running Postgres 8.4 with a database at our DR site that…
TrevorB
  • 257
  • 1
  • 3
  • 10
13
votes
4 answers

How can I backup an Azure Cosmos DB

I have an Azure Cosmos DB and I need to delete all the resources from this subscription. Is there any way to take a backup offline from the portal?
Georgia Kalyva
  • 737
  • 2
  • 9
  • 23
13
votes
4 answers

Restore SQL Server database to Linux Docker

I need to restore a large SQL Server database on a Linux Docker instance (https://hub.docker.com/r/microsoft/mssql-server-linux/) I'm moving my .bak file to the docker and executing this command in mssql shell: RESTORE DATABASE gIMM_Brag FROM DISK…
Vincent
  • 591
  • 1
  • 5
  • 19
13
votes
2 answers

Mongorestore to update records if already exists without --drop

I have a huge dump of collection of data which i have to transfer to another machine every weekend. So i'm planning for an incremental backup and restore. As experimented, mongorestore never merges data if _id already exists. Based on the above…
Shastry
  • 436
  • 1
  • 5
  • 13
13
votes
2 answers

mysqldump without "CREATE ALGORITHM" and "DEFINER"

In my database backups and export I get something like the following: /*!50001 DROP TABLE `vTime`*/; /*!50001 DROP VIEW IF EXISTS `vTime`*/; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`db_user`@`%` SQL SECURITY DEFINER */ /*!50001 VIEW…
Sarke
  • 2,805
  • 2
  • 18
  • 28
1 2
3
…
99 100