Questions tagged [backup]

Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

Filter by
Sorted by
Tagged with
1
vote
1answer
43 views

Does the target database need to have the same structure of the source database before to use IMPDP?

When I do a import from another database have I need the same estruture of the source database in the target database? For example, if my source database use ASM and my target database no, what have I ...
4
votes
1answer
1k views

MariaDB Incremental Backup always creates full backup (mariabackup/xtrabackup)

I am trying to set up an incremental backup solution for my MariaDB database (stored in MyISAM storage, which is listed as supported) using the included mariabackup tool (a version of xtrabackup). ...
0
votes
1answer
47 views

MSDB - Backup information is not updating

I'am having a problem in my database My backup job is working correctly, but the tables of msdb is not updating the information. Here is my case, if you see, My last transaction log backup was in ...
0
votes
1answer
37 views

Postgres Server staying in read only mode after a barman recover command is executed

All, I am trying to perform a PITR restore using barman using recover command. The problem is that the server remains in the read-only state once the barman recover is done. Is there a way by which ...
0
votes
1answer
21 views

Proper way of restoring base backups

We have daily backups of a postgres db and it is in the form of a tarred (gz) base backup. I need to restore this into another db of the same version. However, I am confused with the article that I am ...
0
votes
1answer
715 views

Restoring dump(backup): ERROR 1022 (23000) at line 44: Can't write; duplicate key in table

I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change. After several tests, the problem is related to the value ...
0
votes
1answer
222 views

ERROR: please confirm the keyfile is match and keyring plugin is loaded

I want to create a copy of my Production DB to a new instance. There is a innobackupex running on the prod every night looks like this: innobackupex --user=username --password=password --keyring-...
1
vote
1answer
34 views

MYSQL Huge Data migration (5TB) from old server to new server

We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware. My one and only idea in my mind is using ...
0
votes
2answers
86 views

how to find backup history of SSAS database

Shockingly on Internet, I am unable to find backup history of SSAS database. Is there no way to do it? Also should we take multiple backups of SSAS database? I am not much aware of SSAS database. ...
1
vote
2answers
2k views

How to run a cold backup with Linux/tar without shutting down MySQL slave?

I run the following before tar-ing up the data directory: STOP SLAVE; FLUSH TABLES WITH READ LOCK; FLUSH LOGS; However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
10
votes
2answers
19k views

MySqlDump's DISABLE KEYS have no effect on import

I have a follow up to my previous question regarding import speed with Inno-Tables (surprise!). Scenario I try to import some big* database dump on my local dev machine in reasonable time. We have a ...
0
votes
0answers
32 views

how to migrate a mongodb over a couple of versions safely & efficient? [closed]

what is the best method to migrate a database (or at least 1 of 6 collections) from mongodb 2.4 to 4.4 with "reasonable effort"? i know there is mongodump/mongorestore, which is considered ...
3
votes
1answer
44 views

Incremental backups: MySQL Enterprise Backup vs Percona XtraBackup?

We're evaluating two tools incremental backup: MySQL Enterprise Backup and Percona XtraBackup. The only comparison I found is by Percona which has obvious cause for bias From this comparison, Percona ...
0
votes
0answers
16 views

Oracle Filter Full Transportable Backup for Schema

I need to use DBMS_DATAPUMP to make a full and transportable backup from my oracle DB for all objects related to a specific schema. I was looking for something like INCLUDE=SCHEMA:"LIKE 'SCHEMA_1%...
0
votes
2answers
849 views

MySQL duplicate entry error opon import to new server

I do have a DB on MySQL Galera 5.6.34 with a table that contains an index on ID,date. The table is fully functional and I have used repair and check to verify the table. However, upon backup/restore ...
2
votes
2answers
467 views

Does mysqlhotcopy block SELECT statements from different clients?

I would like to create a backup of different MyISAM tables on a server using mysqlhotcopy. These tables are about 6GB in size. I would like to know, does mysqlhotcopy block users from SELECTing (...
0
votes
0answers
47 views

SQL Server Differential Backup Size

The setup is SQL Server 2008 R2: Full Backup - Weekly ~1.1TB Differential - Every 4 hours ~66GB Transactional - Every hour What I want to know is why is the very first differential backup about 60GB,...
0
votes
0answers
14 views

How to do incremental backup with limited privilege in mysql?

Env:MySql Community v5.7 @AWS RDS User Privs: Select_Priv, Create_View, Show_View, Show_Db, Execute, Create_tmp_table binary_log: ON Currently I can do full backup using mysqldump --single-...
2
votes
2answers
967 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
0
votes
2answers
427 views

How to hot-backup mysql slave database with read operations

I have a slave database of about 120GB in size on which application is performing select statements. I also have a backup system (Acronis backup) available to me from a hosting company. Unfortunately ...
0
votes
1answer
102 views

ERROR 1064 (42000) You have an error in your SQL syntax during import

New to MySql. I have an export file from server version 5.6.34. I am importing this on a server with the same version. I get an error like: ERROR 1064 (42000) at line 4343: You have an error in your ...
0
votes
1answer
17 views

Logical Backup strategy in large Oracle Databases

in Oracle databases, I would like to know if it is advisable to make logical backups with exp or expdp in large databases with large volumes of data, greater than terabyte, I have seen several systems ...
2
votes
1answer
2k views

Location of postgres db file for backup

I would like to make a backup of a postgres database file that I created on Ubuntu 16.04. I cannot find the file. Some other sources indicate it should be under: /var/lib/postgresql/[version]/data ...
0
votes
0answers
27 views

EMC Legato NSR_DATA_VOLUME_POOL in Rman script

How to put the NSR_DATA_VOLUME_POOL parameter in rman in case this parameter has spaces, I mean that I need to put NSR_DATA_VOLUME_POOL = Pool Oracle but it throws an error however with PoolOra it ...
0
votes
2answers
50 views

SQL Server native log backup running every 5 minutes

What will happen if SQL Server native log backup is running ever 5 minutes and due to high active transaction the backup was not able to complete in 5 minutes ? Will the next log backup be initiated ...
0
votes
1answer
1k views

mysql xtrabackup missing binary logs

It seems xtrabackup is not backing up binary logs, although it creates xtrabackup_binlog* with apparently correct information inside. Should the binary logs be copied manually beforehand or is this a ...
1
vote
1answer
31 views

SQL Server Application paths to include in server backup?

I have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup, which he ...
0
votes
0answers
26 views

Ola Backup scripts, How do you specify a different filename for the mirrored set?

I'm using the backup script below as a test. I want to use a different file name for the mirror. The format should be @FileName = '{ServerName}-DEFAULT-{DatabaseName}-{BackupType}-MIRROR_{FileNumber}....
6
votes
4answers
7k views

Mysql backup strategies?

We have a innodb mysql database so we are lost with lots of different mysql backup strategies. Some talk about mysqldump some talk about third part tools. Some of the tables we also plan to run ...
0
votes
0answers
9 views

Segragating First LSN and Last LSN from Output MySQL

I am trying to Build a Incremental Backup Script using Percona Innobackupex , what my problem is i need a shell script to segregate the both First LSN and Last LSN from the Log Output of Full Backup, ...
0
votes
1answer
165 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
2
votes
1answer
700 views

Full database backup using xtrabackup stream

I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server. I just have some questions and I need guides, and I think ...
2
votes
1answer
2k views

How to configure AutoMySQLBackup?

How I can configure AutoMySQLBackup to backup some selected tables ones per week while the other tables will be backed up every day? Thanks. P.S. My google search ninja skills is not working. :)
17
votes
1answer
16k views

SQL-Server: Why do we use FILE = 1 in scripts for restoring a database

Recently when I came across the script for restoring a database, I got a doubt on why we have to use "FILE = 1"? Can't we restore a database without that statement!? Basically, what it is used for?
0
votes
0answers
12 views

Transaction backup plan and size

I am using SQL Server 2016. I have setup SQL Agent for Full backup (Weekly) and Transaction Log backup (Daily). Backup transaction log into a single file using: BACKUP LOG [XXX] TO DISK = N'E:\SQLDB\...
0
votes
1answer
40 views

T-SQL Query to retrieve the last full backup (Including split and copy only), Size and Location

I am using the following query answered by Marcello Miorelli. This query serves the purpose for normal backups but fails to determine the actual backup size of all the split backups and copy only ...
3
votes
2answers
633 views

Percona MySQL 5.7 | XtraBackup 2.4 - xb_load_tablespaces() failed witherror code 11

I am attempting to upgrade MySQL from 5.6 to 5.7 and everything seems to be working, but when I try to run xtrabackup I am now getting this error: InnoDB: Allocated tablespace ID 12 for percona/...
2
votes
1answer
106 views

Ignore a database in an Availability group when using @AvailabilityGroups = instead of @Databases with ola-hallengren backup solution

I’m using the @AvailabilityGroups= parameter to backup availability groups, is it possible to NOT backup (exclude) a database in the Availability group? If using the @Databases parameter I could use -...
2
votes
1answer
667 views

restore mongodb sharded cluster to another server

MongoDB version is 2.4.12 Production Server has 3 shards and each shard have another 2 replica sets. Config server & router also runs on these servers. Backup procedure : 1. Shutdown one of ...
2
votes
1answer
3k views

mysqldump collation issues

I have tried my hand at building a shell script to backup our wordpress database using tar balls and chron jobs on a Debian environment. The problem I am facing now is that our wp database after ...
0
votes
1answer
24 views

Storage accounts not showing up when creating Azure Storage Credential

I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
0
votes
1answer
32 views

Ola Hallengren's backups scripts, cleanup only mode

Is it possible to run Ola Hallengren's backup scripts in cleanup only mode? I have a couple of servers where the cleanup time was set too long, and I now have to clean up hundreds of databases worth ...
0
votes
1answer
12 views

PostgreSQL Backup Information

How do you get the Backup History for a PostgreSQL database from within the database? for example: in SQL Server you look into msdb.dbo.backupset in Oracle you check v$rman_output is there a similar ...
2
votes
1answer
939 views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
2
votes
1answer
1k views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
0
votes
1answer
112 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
1
vote
0answers
62 views

SQL server backup fail “A system assertion check has failed”

I just installed SQL Server 2017 EVAL in a Windows Server 2012 R2 VM. Most default options. Default installation folder. SYSTEM databases in default folder. User databases in the D:\ drive. Created ...

1
2 3 4 5
48