Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [database-backup]

The tag has no usage guidance.

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

Backup Dbeaver with postgres

I'm tring to apply backup using DBeaver with postgres: 1: Create backup: enter image description here 2: enter image description here 3: I try apply restore on another database and get this: enter ...
alex 's user avatar
  • 101
1 vote
2 answers
135 views

How should databases be configured for different environments to not lose data

How to configure databases for development, staging and production environments so that there will be no any data loss. Many Applications such as Wordpress, Django, etc... use some database to store ...
zakadmin's user avatar
0 votes
0 answers
244 views

What is the efficient way to copy large database from one server to another?

I have a SQL server's full database backup job that runs daily at night. Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different ...
Parkeralex's user avatar
0 votes
0 answers
43 views

Stop samba share from unmounting at signoff WinServ22

I am trying to find a way to map a drive so that it will not unmount when I sign out of the system. I currently have a backup job running from the SQL management console and it is aimed at a samba ...
dusty_gazingaz's user avatar
0 votes
1 answer
382 views

Mongodb data files corrupted when copied in

I’m sure there is a straightforward solution, I’m running a Mongodb service thusly: [Unit] Description=Mongo server for Open Quartermaster. Version ${version}, using MongoDB tagged to "4". ...
Snappawapa's user avatar
0 votes
1 answer
237 views

Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure

When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful. Before the restore procedure, we have destroyed the cache which we want to ...
cookie_marsh's user avatar
0 votes
0 answers
54 views

Reinstalling server and SQL Server database

Due to some Windows issue, can't clean-up the WinSxS folder and the Disk Space process (cleanmgr.exe) makes the CPU going to 100% meaning that I am at 97% of disk usage, I am planning to reinstall the ...
Corobori's user avatar
  • 123
4 votes
1 answer
20k views

Not able to backup of postgres DB from DBeaver

Hope you are doing great. We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine. Whenever we try to take backup of Database it is giving error as "Native ...
Satish Lamak's user avatar
0 votes
2 answers
51 views

Add to mysql db instead of restore

*EDIT/UPDATE I have an RPI4 with mysql. I need to collect all the data from the "zm" database, and ADD it to another database of the same name on another server, so NO data on the 2nd server ...
Ben's user avatar
  • 23
0 votes
1 answer
401 views

mysql, relocating individual databases vs entire data directory

I need to relocate mysql customer databases to another disk, for the purposes of: 1. Separation of user data from system files 2. Ease of backing up system and user data separately 3. Ease of ...
Gary Aitken's user avatar
1 vote
2 answers
967 views

Mariabackup error restoring incremental (`This incremental backup seems not to be proper for the target`)

I use mariabackup for creating incremental backups on a previously created full backup directory. The full backup is created using the following command: mariabackup --backup --target-dir=/var/mariadb/...
manifestor's user avatar
  • 6,469
0 votes
0 answers
807 views

I m trying to use mysqldump but getting error mysqldump: Got error: 2003: Can't connect to MySQL server on host(110) when trying to connect

Here is my sam template for taking database backup trigger: - none pool: vmImage: ubuntu-latest steps: - script: echo Hello, world! displayName: 'Run a one-line script' - script:...
vithya m's user avatar
0 votes
2 answers
1k views

What is the best & safe & fastes way to backup a large mysql database?

I have a mysql server running on a Debian server. I have a mysql database wich is 150GB... What is the best way to take a backup of it? I'll say: screen then mysqldump -u user -p database > ...
sav1sav's user avatar
  • 11
2 votes
1 answer
1k views

How to debug the cause of my suddenly extremely slow running database backups maintenance plan?

(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.) Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server ...
J.D.'s user avatar
  • 121
1 vote
0 answers
64 views

Database backup best practices

For my current project, I'm using Aurora RDS and I'm looking for some advice on best practices in terms of backing up the database. My thought is to use AWS Backup to backup the database to 3 ...
Eric's user avatar
  • 113
0 votes
1 answer
373 views

Oracle 18c XE can't backup PDB database after corruption of the main XE database

I have an Oracle 18c XE server where there is a corruption in the system01.dbf file of the main XE database. All user data is in a PDB database which luckily seems ok (the PDB is working in production ...
Enrico Detoma's user avatar
0 votes
1 answer
1k 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 ...
samoolix's user avatar
0 votes
1 answer
141 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 ...
Xin's user avatar
  • 187
2 votes
0 answers
502 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. ...
mbethke's user avatar
  • 43
0 votes
1 answer
2k 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 ...
lex's user avatar
  • 1
1 vote
1 answer
864 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 ...
jrd1989's user avatar
  • 688
0 votes
0 answers
544 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 ...
Miguel Santos's user avatar
0 votes
1 answer
264 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 ...
Billie's user avatar
  • 3
0 votes
1 answer
933 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 ...
bhuva nesh's user avatar
0 votes
1 answer
820 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 ...
velis's user avatar
  • 233
1 vote
1 answer
285 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 ...
Alex's user avatar
  • 21
0 votes
1 answer
73 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 ...
Galmachar's user avatar
2 votes
2 answers
3k 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 ...
BostonAreaHuman's user avatar
-1 votes
1 answer
98 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" ...
GarfieldCat's user avatar
1 vote
1 answer
2k 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'....
Red Bottle's user avatar
1 vote
1 answer
4k views

rsync: change_dir "/home/Sources//[email protected]/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 ...
Ahmed Reda's user avatar
1 vote
1 answer
1k 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, ...
Damian's user avatar
  • 21
0 votes
0 answers
54 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 ...
Junior's user avatar
  • 171
1 vote
0 answers
40 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: ...
andyabel's user avatar
  • 111
8 votes
1 answer
11k 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:...
Arcobaleno's user avatar
1 vote
1 answer
74 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 ...
SilverbackNet's user avatar
0 votes
2 answers
53 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 ...
Pugal's user avatar
  • 103
0 votes
1 answer
675 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 ...
Sotiris Kaniras's user avatar
0 votes
0 answers
120 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, ...
rtindru's user avatar
  • 101
1 vote
2 answers
207 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 ...
nullReference's user avatar
0 votes
1 answer
568 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 ...
Techboy's user avatar
  • 1,582
0 votes
1 answer
886 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 ...
Justin's user avatar
  • 137
5 votes
0 answers
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 ...
Matt's user avatar
  • 51
5 votes
2 answers
12k 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 ...
Parthian Shot's user avatar
0 votes
1 answer
223 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 ...
eddiewould's user avatar
1 vote
3 answers
2k 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?
Zolbayar's user avatar
0 votes
0 answers
123 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/...
user avatar
0 votes
1 answer
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 ...
rgvcorley's user avatar
  • 133
4 votes
1 answer
876 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 ...
HonoredMule's user avatar
3 votes
1 answer
2k 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 ...
Ronen Ness's user avatar

1
2 3 4 5 6