Questions tagged [database-backup]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

Cron job to create and send backups over FTP

My VPS is running on Centos 7 with nginx and MySQL 8.0 I have created 2 cron jobs to backup my files and database everyday at a specific time. everything works fine but I'm trying to send those backup ...
1
vote
0answers
18 views

Impact on Recovery Time Using A Single Perpetual Base Backup and WAL Archives [migrated]

What would be the impact on recovery time when restoring a Postgres database from a backup where one base backup was taken at the start of the backup strategy and then only applying WAL archives from ...
0
votes
1answer
29 views

Can I use “Windows Server Backup function” or “wbadmin” to backup MariaDB?

I am making a backup strategy for MariaDB on Windows Server. To make my life easier, I was wondering if I can use the "Windows Server Backup function" or "wbadmin" as a backup tool ...
2
votes
0answers
88 views

How can I use garbd+mariabackup to back up a MariaDB/Galera cluster?

I'm migrating a Galera cluster from MySQL to MariaDB 10.3.27, and as part of the process I'd like to change the backup method from the somewhat fiddly (and blocking) garbd+rsync to garbd+mariabackup. ...
0
votes
1answer
118 views

How to restore Mysql database from .frm and .ibd files on localhost

I have a VPS server that was hosting a WordPress that has crashed and I think must be deleted. No backups were made. I managed to setup a rescue mode and salvage WP site data via FTP. Because Mysql ...
0
votes
1answer
47 views

Azure SQL bacpac Restore Over Existing Database

I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when ...
0
votes
0answers
38 views

Configure RDS to backup weekly instead of daily

I've got a MySQL RDS instance that is currently being backed up daily using RDS' Automated Backups feature. However, the data doesn't change fast enough to merit daily backups; if there are two or ...
0
votes
0answers
59 views

Migrating a Mongodb 3.2 to 4.x version

I'm quite new to mongodb and I need some good advices :) I have a mongodb 3.2 service running for a slowly growing 6Gb database on an Ubuntu 16.04 VPS for a Nodejs Parse Server application. In the ...
0
votes
0answers
127 views

How to backup/restore a large MongoDB database?

How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical. We've tried by making a straight copy ...
0
votes
1answer
84 views

Backing up OpenLDAP in Windows environment

I need to find a concept how to backup OpenLDAP data (the data directory) in a windows environment. I googled around a bit and found: https://github.com/elmar/ldap-git-backup. But this framework is ...
0
votes
1answer
175 views

How to take backup of 500GB SQL database data?

We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy? How much size script file should ...
0
votes
1answer
36 views

Is it possible to restore postgres database with a non-DBO user?

I'm struggling with finding an appropriate backup / restore method for my postgres databases. My requirements are these: DB owner is a non-superuser account. it only has "can login" and "inherit ...
1
vote
1answer
53 views

Backup mysql without causing spike in disk I/O

How would I backup mysql databases without causing spike in disk I/O, so other services using the same disk are not affected by the backup. Backing up to other disk might help, but i was thinking ...
0
votes
1answer
21 views

cassandra backup - errors during compression

My cassandra backup often returns with errors because users move/change it during the compression (we just tar it). Users are logged to the server 24/7 so we can't just change backup hours. I need ...
1
vote
2answers
1k views

Correct way to have a mysql/mariadb incremental backup

I've read for a few hours on this topic but don't have a complete grasp. I'm going to be using borg backup to a network share. Looking to have pretty frequent backups of the binlog....every 5 ...
-1
votes
1answer
29 views

Does anyone backup SQL Databases >= 4Tb instead of replication?

So the question is in subject. Backing up SQL database is very time consuming procedure. How anyone make backups for such huge SQL databases? I'm not about specific instruments but "architecture" ...
1
vote
1answer
341 views

How to restore from .dump.gz file using dump tool?

I have taken a dump of my server using the following command /sbin/dump -0uan -f - / | gzip -2 | ssh -p ***** -c blowfish dev***@***.**.**.** dd of=/DATA/junkBEN/server-full-backup-date '+%d-%B-%Y'....
1
vote
1answer
2k views

rsync: change_dir “/home/Sources//account@sub.inmotionhosting.com/home/account” failed: No such file or directory (2)

When run this command to make backup database file from remote server, I face the below reasult but I do not know what is the issue. The command I run on my local ubuntu server to git file from ...
0
votes
1answer
588 views

Mysqldump to compressed file

Situation: 1. mysql is backuped to disk with mysqldump (~250 GB) 2. dump is compressed with bpzip2 3. dump is moved to another DC 4. disk usage again in good state Problem: Filesystem usage peaks, ...
0
votes
0answers
36 views

How do I manage the backup process for a VPS?

I have a platform that I would like to offer for my client. It is a SaaS platform in which I need to host it. It sounds like VPS is one way to go but I never owned/managed a VPS so not sure how to ...
1
vote
0answers
22 views

T-SQL Finding who attempted to backup the “master” database?

I'm running SQL Server 2016. For the last two nights at 7pm the SQL Server Alert System sent me this alert: 'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: ...
4
votes
1answer
4k views

RDS snapshot: how long does I/O suspension occur?

As we're relying on RDS Postgresql manual backup for our backup strategy, we encountered the issue with the possible downtime of the RDS instance (single AZ) during snapshot creation. According to AWS:...
1
vote
1answer
49 views

Is it safe to restart a database as soon as VSS backup begins?

I know that VSS is designed to create a snapshot of the state of the entire system as soon as you call begin backup, and hold on to it until the backup is ended (or the disk runs out of space). Does ...
0
votes
2answers
40 views

schedule backup job runs up to 9 hrs without errors

I'm very new to administration job... I have SQL server 2012, on that my senior scheduled a job for schedule backup. But, recently I noticed, after 8-May-2018(up to 26-May-2018) the backup files are ...
0
votes
1answer
578 views

MongoDB - Efficient backup

I have an application running on a Parse Server and another server where MongoDB runs. Both VMs are under Azure (Ubuntu VMs). A few weeks back, I wrote a db backup bash script which is run by crontab ...
0
votes
0answers
82 views

How to make daily database backups readily queryable

We have a production database that generates daily database backups that are uploaded to S3 in form of compressed .sql.bz2 files. We basically have a S3 bucket that has a large number of such backups, ...
1
vote
2answers
129 views

Backup strategy for dedicated LEMP stack server

We currently have an application running on a dedicated server which utilizes a LEMP (Linux, Nginx, MariaDB, PHP) stack. Right now we are only doing backups at a set interval (every x hours). I have ...
0
votes
1answer
407 views

What is a good way to backup SQL Server DB's from multiple AWS EC2 instances to a single AWS EBS Volume or S3 Bucket?

I have about 30 AWS instances, each running SQL Server. I want to back them up onto an AWS EBS Volume or S3 bucket - using a free solution. I was thinking of creating a large volume and mapping each ...
0
votes
1answer
462 views

MySQL Table Checksum - Before or after MySQL dump?

The company I'm currently working for has a script that runs at night that takes a MySQL dump of the production environment and imports it into the staging environment. This is a very basic setup - No ...
5
votes
0answers
5k views

Best Way to Backup ClickHouse Data

We recently started using Yandex ClickHouse for our data backend, and I'm working on figuring out how best to backup our data. There seem to be two ways of doing this. ALTER TABLE ... FREEZE ...
5
votes
2answers
6k views

Is it possible to take a snapshot of a database in Azure?

So, to clarify, I'm aware I could dump the database using tools written for the database that don't know anything about azure. I know I could do an import / export. And I know I could just extend ...
0
votes
1answer
187 views

Backing up RavenDB - is it safe to backup data directory without VSS?

The documentation for RavenDB basically indicates there are several ways of backing up your RavenDB database: Using the supplied Raven.Backup.exe tool Initiating an export from the "studio" web ...
1
vote
3answers
1k views

Where to store db backups in centos 7? [closed]

Where should I store my db backups in Centos 7? Are there any best practice for this? Should I put them in /var/lib/<app>/backups as suggested in this answer?
0
votes
0answers
51 views

Migrating MariaDB cannot find files anymore

I had to reset my dedicated server, so i backuped the whole /var/lib/mysql directory (stored in OVH Backup Storage). Today on my clean dedicated, i reinstalled mariadb and so putted the whole /var/...
0
votes
1answer
2k views

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of ...
4
votes
1answer
588 views

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps: Flush all committed transactions to the filesystem Start buffering all transactions (keep the ...
3
votes
1answer
1k views

downloading a big database (postgres) to a local copy

I have a pretty big postgres DB on Amazon RDS (about 9GB when zipped), and sometimes we need to copy it and do some tests on it on our local machines. Doing a DB dump (pg_dump) and downloading it is ...
1
vote
1answer
741 views

best raid level for backup server

I'm building a Centos 7 server to hold Postgres backups (using Barman). The Dell PowerEdge server has a Perc-8 controller (H710P), and there are 12each 3TB 7200rpm SAS drives available for a raid set ...
1
vote
2answers
11k views

SQL 2012 Transaction Log backup does not truncate the logs

I'm a beginner in DB administration so bear with me. I have a small DB 500MB with a very large transaction log (19GB). I'd like to keep this in "Full Recovery" mode, so please do not suggest "Simple" ...
0
votes
2answers
403 views

Adding mysqldump parameters in automysql

Please excuse any formatting or grammatical errors. I am currently using automysqlbackup to take local backups of my mySQL database. I recently started to having problems that is connected to that ...
5
votes
2answers
3k views

Cassandra snapshot restoring : random missing data

I'm having a hard time restoring snapshot on Apache Cassandra (version 3.0.9). As far as I can say, I'm following the procedure described on datastax blog, along with several other ones (for instance :...
1
vote
1answer
729 views

Backing up PostgreSQL - being prompted for password

OS: Ubuntu Xenial 16.04 LTS PostgreSQL Version: 9.5.4 I am trying to set up automatic database backups on my server, and every time I run pg_dump, it tells me that no password was supplied. Here's ...
3
votes
1answer
355 views

Sharing keys and certificates between SQL Server 2014 server for encrypted backup and restoration

I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server. I would like to be able to take an encrypted backup of a database on ANY server and restore that ...
0
votes
3answers
125 views

Amanda/Zmanda backup-recovery Local server

I am trying to recover some files from a tape on Linux, that were placed on there through an amdump. The problem is in order to use amrecover you have to set up the server. Which I do not really know ...
0
votes
1answer
326 views

AutoMySQLBackup: Create a single file for each database

I'm backupping my databases with automysqlbackup. This works fine - but unfortunately I do not get a single file for each database but a cumulative file called daily_all-databases_2016-04-...
0
votes
0answers
175 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
4
votes
2answers
2k views

How to do offsite AWS RDS PostgreSQL backups?

As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our ...
0
votes
1answer
316 views

bacula catalog backup error

I have a Bacula (mysql) server on an Ubuntu-server machine. It backs up and restore without issues except for the catalog. Every time it runs the catalog backup it shows an error. My guess is that ...
4
votes
2answers
519 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = '...
0
votes
4answers
282 views

How do I perform an Exchange 2010 database backup using Windows Server Backup with Hyper-V VMs collocated on the same drive?

Yeah... I'm not the one who set it up. I've been tasked with setting up backups for their Exchange data. I've read through the documentation and learned about all the caveats that come with using the ...

1
2 3 4 5