Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
0 answers

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 locations over the Internet via FTP. I use FileZilla but…
Parkeralex
  • 1
  • 1
0
votes
0 answers

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 share on a rhel box. Things work fine at the moment…
dusty_gazingaz
  • 1
0
votes
1 answer

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…
Snappawapa
  • 101
  • 4
0
votes
0 answers

Optimal automated neo4j backup startegy

I'm trying to figure out the most optimal way to do automated daily backups of my > 2TBs neo4j database. I need to get a db copy and upload it to S3. I have a neo4j cluster with 1 primary db and 2 secondaries. I have the neo4j data…
Hussein Hijazi
  • 121
  • 2
0
votes
1 answer

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 restore (according to the official…
cookie_marsh
  • 1
  • 2
0
votes
0 answers

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 server where my SQL engine is running. I know I…
Corobori
  • 123
  • 6
0
votes
2 answers

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 is removed/overwritten. This will occur once per day, when…
Ben
  • 23
  • 4
0
votes
1 answer

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 upgrading the system The following articles were…
Gary Aitken
  • 123
  • 6
0
votes
0 answers

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: | sudo apt-get -f install -o…
vithya m
  • 1
  • 1
0
votes
2 answers

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 > database.sql? Any suggestions?
sav1sav
  • 11
  • 4
0
votes
1 answer

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 now). The problem is that I can't make a backup…
Enrico Detoma
  • 153
  • 2
  • 6
0
votes
1 answer

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 files to my backup host. I created a bash file…
samoolix
  • 31
  • 3
0
votes
1 answer

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 for MariaDB.
Xin
  • 187
  • 5
0
votes
1 answer

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 server cannot be started or reinstalled in this…
lex
  • 1
  • 2
0
votes
1 answer

Recovery models, log shipping and log backup frequency in SQL05

Trying to get a sense of the optimal setup in our environment. I have a large SQL05 DB (500+GB) that is log shipped to a read-only system over a WAN. I'm currently running in FULL recovery model, with log dumps every 5 minutes during peak hours and…
paulland
1 2 3
…
16
17