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
28
votes
1 answer

mysqldump extracting data without table structure

I'm trying to dump all of my mysql data for one database into a single file. That said, I don't want to include the table structures in this file (there is another file which will have the structure of the tables in it). Is it possible to strictly…
judda
  • 3,977
  • 1
  • 25
  • 27
27
votes
6 answers

CouchDB dump to file and load from file

I cannot replicate between two couchdb servers, so I would like to dump to file from one server and load from file into the other server. I used this statement to dump and it worked fine: curl -X GET…
eriq
  • 1,524
  • 3
  • 13
  • 22
26
votes
7 answers

Backup failed for Server, The media is formatted to support 2 media families Error

Can any body tel me how to overcome this error when taking a backup in SQL Server 2008 Express? Backup failed for Server '\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended) For help, click:…
CAD
  • 4,112
  • 6
  • 29
  • 47
25
votes
5 answers

Backup Permissions

I created a new user on the server that will access certain databases. But when I go to backup or restore the database I get the error: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup Cannot access the specified path or…
Alan Araya
  • 701
  • 1
  • 12
  • 27
24
votes
3 answers

SQL Server tells me database is in use but it isn't

SQL Server keeps telling me a database is in use when I try to drop it or restore it, but when I run this metadata query: select * from sys.sysprocesses where dbid in (select database_id from sys.databases where name = 'NameOfDb') It returns…
tuseau
  • 1,334
  • 4
  • 17
  • 37
24
votes
4 answers

MongoDB restore warning

I'm following this tutorial to backup and restore a single MongoDB database. The backup command - sudo mongodump --db newdb --out /var/backups/mongobackups/`date +"%m-%d-%y"` The restore command - sudo mongorestore --db newdb --drop…
Jyotman Singh
  • 10,792
  • 8
  • 39
  • 55
24
votes
2 answers

MSSQL DataBase Backup without a specific table

I need to take a schedule backup without a specific table in sql. Because if I take a backup with that table it will take long time. I need to exclude one table from backup. Is it possible? Without that table all tables and data should be there in…
Jude Nanayakkara
  • 251
  • 1
  • 2
  • 6
22
votes
1 answer

What is recommended way to do a PostgreSQL database backup: pg_dump or pg_basebackup?

There are two different tools in PostgreSQL server: pg_dump pg_basebackup What is the difference between these tools? Which one to use to create database backup?
Eugen Konkov
  • 22,193
  • 17
  • 108
  • 158
22
votes
4 answers

Is it viable to handle MySQL backups with git?

Today I had this really neat idea for backing up my database: put the dump file in a git repository, then commit on each dump so that I have both the most recent copy, but can easily roll back to any previous backup. I can also easily pull a copy of…
Matchu
  • 83,922
  • 18
  • 153
  • 160
21
votes
5 answers

MongoDB backup plan

I want to switch from MySQL to MongoDB but great data losses (more than 1 hour) are not acceptable for me. I need to have 3 backup plans: Hourly backup plan. Data is flushed to disk every X minutes and if something wrong with the server I shall be…
luchaninov
  • 6,792
  • 6
  • 60
  • 75
21
votes
1 answer

converting SQL . BAK to SQL backpac format

I have MSSQL .BAK file, and for logistical reason (the DB being huge for my infra) I want to convert the same to BacPac file, so that I could upload the same to Azure. All this while I thought .BAK and BacPac are same, so there was error, is there a…
user1504387
  • 261
  • 1
  • 3
  • 4
20
votes
5 answers

Amazon RDS instance backup window duration?

What does the backup window duration setting mean when configuring an Amazon RDS instance?
Josh M.
  • 26,437
  • 24
  • 119
  • 200
18
votes
1 answer

Amazon DynamoDB via CloudFormation - point in time recovery

Is it possible to specify Point In Time Recovery for an Amazon DynamoDB table created via CloudFormation? I've been looking through the docs and user guide and haven't found anything useful yet.
ethrbunny
  • 10,379
  • 9
  • 69
  • 131
18
votes
5 answers

Using mongodump with a standard Mongo URI

The mongo client can connect with a standard URI: mongo mongodb://:@:/ However, mongodump seems to require an awkward syntax breaking this up into different arguments: mongodump -u dbuser -p dbpassword -h…
Andrew Mao
  • 35,740
  • 23
  • 143
  • 224
16
votes
4 answers

General error : '"mysqldump"' is not recognized as an internal or external command

I use Laravel Spatie Backup, the installation is complete, first running this $ composer require spatie/laravel-backup $ composer require spatie/laravel-backup Using version ^5.6 for spatie/laravel-backup ./composer.json has been updated Loading…
Nasser Ali Karimi
  • 4,462
  • 6
  • 34
  • 77
1
2
3
…
99 100