backup Questions

2

I have a kubernetes cluster, with a pod running the postgres database, so in Docker. Obviously, I have the data mounted on the host. I would like to setup Barman to have a backup solution for the D...
Fennelly asked 20/7, 2020 at 8:37

4

I am trying to use grsync (A GUI for rsync) for Windows to run backups. In the directory that I am backing up there are many larger files that are updated periodically. I would like to be able to s...
Tyra asked 2/3, 2015 at 21:2

11

Solved

I've got a database, [My DB], that has the following info: SQL Server 2008 MDF size: 30 GB LDF size: 67 GB I wanted to shrink the log file as much as possible and so I started my quest to figure ...
Cloe asked 25/8, 2011 at 15:54

3

I have a very large Moodle .mbz backup file of a single course - Slightly over 1GB. I need to upload this backup to the server, but of course the file manager Moodle provides won't allow me to do t...
Esmeralda asked 14/9, 2016 at 15:13

2

New to Firestore, really enjoy using it but the one issue I have is that I can't see an obvious way to backup the entire database for a given project, the idea being that if anything goes wrong I c...

26

Solved

Below is the query that I am using to backup (create a .bak) my database. However, whenever I run it, I always get this error message: Msg 3201, Level 16, State 1, Line 1 Cannot open backup d...
Knossos asked 18/10, 2010 at 14:40

2

Solved

World! I have a backup script that would run rsync for every user and will archive their /User/user folder onto our shared drive. Running into an interesting problem with rsync: when executing th...
Incorporation asked 5/6, 2015 at 16:20

33

Solved

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_du...
Wastebasket asked 11/10, 2012 at 9:23

10

Solved

I have the following command in the part of a backup shell script: tar -cjf site1.bz2 /var/www/site1/ When I list the contents of the archive, I get: tar -tf site1.bz2 var/www/site1/style.css v...
Cauline asked 8/9, 2013 at 7:43

30

Solved

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.b...
Tomchay asked 6/2, 2009 at 16:21

6

Solved

I'm a little bit confused with the functionnality of named volumes in a docker compose file specifically when it comes to backup/restore my app. I'm actually testing this dockercompose file : ...
Heda asked 11/7, 2016 at 3:16

6

Solved

I want to setup a cron job to rsync a remote system to a backup partition, something like: bash -c 'rsync -avz --delete --exclude=proc --exclude=sys root@remote1:/ /mnt/remote1/' I would like to...
Darindaring asked 26/8, 2008 at 3:37

3

Solved

I'm doing a dump like this pg_dump prod-db -U postgres > prod-db.sql, but would be cool if I could do a dump like pg_dump prod-db -U postgres > prod-db-{date}.sql and be able to generate a fi...
Nelda asked 6/2, 2013 at 11:48

17

How to take table-level backup (dump) in MS SQL Server 2005/2008?
Nyala asked 25/3, 2009 at 7:31

9

I have a web server (odin) and a backup server (jofur). On jofur, I can run the following code to rsync my web directories (via key authentication) from odin to jofur: rsync -avz -e ssh [email&#1...
Hakan asked 28/12, 2012 at 17:34

17

Solved

I'm trying to backup/restore a PostgreSQL database as is explained on the Docker website, but the data is not restored. The volumes used by the database image are: VOLUME ["/etc/postgresql", "/va...
Wynnie asked 13/7, 2014 at 1:10

9

Solved

I'm a solo developer, working in a local Git repository. For backups, I want to send an exact copy of that repository off to another server. Is it sufficient to do this? git push --mirror I'm a...
Rub asked 26/7, 2010 at 7:56

5

Solved

I can take mongodb data backup but I am not sure about mongodb schama backup. Is there any way to take dump of MONGODB schema only not the data ?
Harlie asked 7/2, 2017 at 7:52

2

Solved

In the mongodb docker page there's the following tutorial on how to dump a mongodb collection: sudo docker exec container_name sh -c 'exec mongodump -d collection_name --archive' > /home/mongo_...
Parker asked 15/2, 2020 at 1:2

3

I'm using this command syntax : mysqldump -u<username> -p<password> --no-create-db --databases mydatabase > /var/backups_DB/MyDatabase-$(date +"%d-%m-%Y-%H:%M:%S").sql But I could...
Planking asked 15/6, 2015 at 0:16

8

Solved

Whenever I edit files on emacs, it seems a temporary file is created with the same name with ~ appended to it. Does anyone know an quick/easy way to delete all of these files in the working directo...
Bar asked 21/4, 2010 at 4:48

16

I take backup using pg_dump db_production > postgres_db.dump and then I copy it to localhost using scp. Now when I import on my local db it gives an error pg_restore: [archiver] input fil...
Piderit asked 16/11, 2016 at 12:29

9

Solved

How can I make a perfect backup of mysql database using mysqldump? When I am making a backup, my tables from specified database are only getting backed up. The procedures and functions are not. Her...
Cecillececily asked 3/7, 2009 at 7:30

20

Solved

I created a database on my local machine and then did a backup called tables.bak of table DataLabTables. I moved that backup to a remote machine without that table and tried to do a restore but g...
Thevenot asked 11/8, 2011 at 19:35

13

Solved

I'd like to avoid mysqldump since that outputs in a form that is only convenient for mysql to read. CSV seems more universal (one file per table is fine). But if there are advantages to mysqldump, ...
Devan asked 21/1, 2009 at 23:13

© 2022 - 2024 — McMap. All rights reserved.