Questions tagged [database-backup]
The database-backup tag has no summary.
255 questions
Score of 3
2 answers
193 views
Best approach to recover data from a RAW external drive on Windows Server?
We recently encountered a situation where an external backup drive suddenly appeared as RAW on a Windows Server system after an unexpected shutdown. Disk Management shows the partition, but Windows ...
Score of 1
1 answer
229 views
mariabackup --prepare keeps backup state at "log-applied", not "full-prepared"
I'm performing a full backup on a MariaDB 10.6.8 instance on linux and encountering an issue where the --prepare step finishes successfully but fails to transition the backup state to full-prepared. ...
Score of 2
1 answer
242 views
MySQL Large database export and re-build in dev environment
I have a production database cluster (innodb if it matters) that has to be regularly backed up and imported into a development environment.
Currently I am using a basic mysqldump to generate a *.sql ...
Score of 0
1 answer
286 views
Operating system error 87 using S3 connector in SQL Server 2022 to perform database backup
I am attempting to use the new S3 connector in SQL Server 2022 to backup a database to an S3 bucket. I have been following the instructions here:
https://learn.microsoft.com/en-us/sql/relational-...
Score of 1
2 answers
355 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 ...
Score of 0
0 answers
434 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 ...
Score of 0
1 answer
542 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".
...
Score of 0
1 answer
345 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 ...
Score of 0
0 answers
162 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 ...
Score of 5
1 answer
25896 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 ...
Score of 0
2 answers
156 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 ...
Score of 0
1 answer
633 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 ...
Score of 1
2 answers
1526 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/...
Score of 0
0 answers
976 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:...
Score of 0
2 answers
1607 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 > ...