Questions tagged [restore]

Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

171 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

What are the considerations when restoring an Oracle db from control file instead of RMAN catalog?

I have a customer that needs to make a testing restore of its Oracle 11.02g database. The destination host is not the source host (so the structures of directories may not be the same). They use ...
0
votes
0answers
18 views

Migrating AWS RDS SQL Server to a smaller RDS instance

I am in the process of migrating an AWS RDS SQL Server to another instance of AWS RDS SQL Server with lesser storage. AWS folks suggested using the native backup/restore option instead of DMS. Steps ...
0
votes
0answers
44 views

error while restoring database from mysql: ERROR 1006 (HY000)

I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root: MySQL -u root -p < /mnt/...
0
votes
0answers
13 views

Migrate data from database on MarkLogic 7 to database on MarkLogic 9

I need to copy data from a MarkLogic 7 database to MarkLogic 9 database on another system. I tried backup and restore option provided by the MarkLogic Admin console. The original database in MarkLogic ...
0
votes
0answers
49 views

how to restore partial-backup created using xtrabackup

I had to take a backup of a single database in my MySQL server of size 2.4 TB. I used percona xtrabackup as mysqldump was taking forever. I used below command for it: xtrabackup --backup -u user -p ...
0
votes
0answers
70 views

Restore a 140GB - 292 Million entrie MySQL-Database faster?

i need help. I have an old innodb Server and my storage limit reached. I dont use files per table entries because in old times there were no ability at this time. My ibdata grown up fast and there is ...
0
votes
1answer
37 views

How to restore output from pg_dump into a new table name

I am dumping a large postgres table (~15m records) like this: pg_dump -h myserver -U my_user --table=mytable -Fc -Z 9 --file mytable.dump mydb The above creates a mytable.dump file. I now want to ...
0
votes
0answers
448 views

RMAN restore error to restore archivelogs

I have this backup piece with the archivelogs: BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 54 1.01M DISK ...
0
votes
0answers
358 views

how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards

i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
0
votes
0answers
69 views

How to speed up MySQLl loading from dump file?

I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
0answers
132 views

Restore database using old control file

Our environment has a full daily DB backup system, including the control file at 11 pm. We had a case to restore the database in different environments but with maximum data to recover. Archivelogs ...
0
votes
0answers
27 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
0answers
178 views

MariaDB 10.2 crash on innodb table corruption - trying to restore the database

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
0
votes
0answers
72 views

Microsoft SQL page level restore, no valid backup. Confirming process

We have a database in production that is coming up with issues after running DBCC CHECKDB. This particular DB was moved from a development environment to production. During this time, for some reason ...
0
votes
0answers
278 views

What steps can I take to recover MySQL InnoDB databases when forced recovery fails?

Coming here from StackOverflow because I saw a similar question being closed as off-topic on there. I have corrupted my local MySQL instance in my development environment. I was running a set of ...
0
votes
0answers
46 views

point in time recovery not working with blackhole engine tables involved

The basic problem summary: I am trying to do a point in time recovery on a specific table. To speed things up I made every other table use the blackhole engine. Unfortunately this runs into errors ...
0
votes
1answer
1k views

Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?

I have a problem with opening Large Object in postgresql version 9.2, select * from pg_largeobject where loid = '19423'; will return data like this: loid oid;page no integer;data bytea 19423;0;"<...
0
votes
0answers
47 views

Archiving SQL Server data on disk to be pottentially restored

Right now, we are backing up data per table into text/CSV files per month. This works fine for fairly small tables. For bigtables, the text files become so big that the restore process for a month ...
0
votes
0answers
50 views

Restore time on dev servers

We have 4 test environments running SQL Server 2014 Developer edition. Every night, we refresh one of those environments by restoring a SQL Backup file stored on a separate server, so that it's in a ...
0
votes
2answers
41 views

SQL DB After Restore Script execution

I have a SQL Database that is being restored every day from a Production SQL server. The restore is being done by a third party application. Once the DB is restored I need to set some specific user ...
0
votes
1answer
1k views

Recovering MySQL 5.7 tables in MariaDB 10

I did a very foolish thing... I did not realize installing mariaDB would uninstall MYSQL 5.7 using apt-get. (Using Ubuntu 16.04). So now I am trying to recover my data. So far, I have read many ...
0
votes
0answers
137 views

MySQL8 Restore from Physical Files - Innodb

I recently had one of my VM's go down (MS Server 2016) and the only version I am able to get up and running is two weeks old. However, I do have a backup of my C:/ drive from last night that has my C:/...
0
votes
1answer
1k views

Upload multiple csv file to multiple tables sqlServer

I have over than 200 csv files that each of them is diffrent table. I create now a new DB and want to upload them all so I will have all the table. I not accessable to old DB to backup in diffrent ...
0
votes
1answer
61 views

SQLServer Linux: Restore full database / Catalog

UPDATE: I continue with the same error, but, with the comments, I have done some progress: - Initially, the full text search feature was not in my installation. I installed with https://docs.microsoft....
0
votes
1answer
1k views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
0
votes
1answer
64 views

Mongodb restore “local” db

I need to restore a replica set. Unfortunately my lack of experience as administrator (I'm not) let me with the only solution of restore the replica using the data of the primary db (the only replica ...
0
votes
2answers
80 views

Multiple DB restore in sequence

I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc. I am using a shell script like so: mysql -u root -h hostname....
0
votes
1answer
541 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
0answers
87 views

MariaDB restore InnoDB db from file system files

How can I restore a InnoDB database from filesystem files (FRM/IBD)? I cannot run db service from that system, so I tought to move its file to another Windows machine but I don't know if is there any ...
0
votes
1answer
413 views

Cannot recover Database from ibdata file

My Server recently had a Kernel-Panic and I downloaded all the mysql data using the rescue mode. Now when I upload the ibdata1 file and table folders to a local XAMPP Server and click on a table to ...
0
votes
0answers
45 views

SQL Server - Partial Backup

I want to check if my Data Warehouse historical filegroup backups are valid with my most recent Primary Filegroup backup. I backup the Primary Filegroup every night but historical filegroup backups ...
0
votes
1answer
72 views

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three ...
0
votes
1answer
49 views

Can I restore a MySQL table from a file (non-sql) backup?

I am using XAMPP 5.6.23-0 on a Mac. I have experienced many problems with MySQL, where the server simply refuses to restart after something has happened (not sure which events make it crash). In the ...
0
votes
2answers
46 views

mysqldump file restore while sql is still being dumped

Im using MaridaDB 10, but my question applies to all mysql variants. I have large dataset (70GB uncomressed when dumped to file). The mysqldump process takes 2-3hours. The restore process takes even ...
0
votes
1answer
441 views

barman + postgresql not start after barman retore

I use the barman for backup and restore after some restore , we start the postgresql as the following systemctl start postgresql.service but postgresql not startup from the log: /var/lib/pgsql/...
0
votes
1answer
172 views

Restoring a FrontBase database

I have a FrontBase database that I am trying to restore. This is a database system I have no experience up until now so this may be a basic question. I am issuing the following command to restore c:\...
0
votes
1answer
148 views

recovery with binlogs?

I would like to know if there is a way that I can restore my databases, I don't have a replication and I would like to migrate my databases without downtime or losing data. So with binlogs could I do ...
0
votes
0answers
236 views

Restoring database on shared remote NAS folder

We are trying to restore a 2TB database on a shared folder on a NAS so we can run several tests on it. So far I understand, this is doable, restoring on a shared folder on a remote NAS. But it fails ...
0
votes
3answers
1k views

Huge mysqldump import

I have a 200+GB mysql dump file that I need to import into the local sql server running on my development machine. I attempted a naive dump restore using the mysql < db_backup.sql approach and ...
0
votes
0answers
153 views

Reasonable times for a mysqldump restore?

NOTE: question edited to take into account restore over LAN vs. local restore. Are there benchmarks available for the time spent doing a database restore from a mysqldump file? Based on my ...
0
votes
1answer
57 views

Create a MySQL Database using a MS SQL database dump (.CSV)

I have a dump of a MS SQL database in the form of CSV files for every table in the database. There are 679 .csv files each for every table. The highest size of the table extract is 9 GB and the lowest ...
0
votes
0answers
45 views

Restoring a backup of 1 database to another puts both databases into Restoring mode

We have a 2 databases- Staging Test At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
0
votes
1answer
88 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 ...
0
votes
1answer
79 views

Point in time restore fails - backup file from before the restore point not available (why does this matter)

I have tried to do a point-in-time restore of a database through the management studio gui, the point-in-time being yesterday morning (2016-04-12). This fails with the error "...cannot open ...
0
votes
0answers
755 views

MYISAM can't create table: Row size too large

We are having database in MySQL 5.1, we have taken the DB backup from MySQL 5.1 and trying to restore in MySQL 5.6. We are getting below error: ERROR 1118 (42000) at line 603: Row size too large. ...
0
votes
1answer
36 views

mysqldump - does it have non-repeatable DMLs?

We are migrating databases using mysqldump, and since this is the first time I'm doing it, I have a couple of questions. If in the middle of mysqldump the utility crashes(for some reason- latest was ...
0
votes
0answers
31 views

Will PostgreSQL server work if I install the service in mounted partition

I have created all tablespaces (only tables created in these tablespaces) in mounted partition, But db is available in pg_default tablespace (root partition where postgresql installed). I am facing ...
0
votes
0answers
281 views

SQL Server DB in suspect mode after installing SQL Server 2008 R2 SP3

One of our production DBs is stuck in Suspect mode since we installed SQL Server 2008 R2 SP3. Earlier today we found that most text fields (nvarchar) had the following data appended to it </title&...
0
votes
1answer
43 views

Check data is the same after restore SQL

I've backed up, transferred to another location and restored a database. Is there anyway to check that the data is the exact same? Would I be best using the CHECKSUM and then the VERIFYONLY method? ...
0
votes
0answers
2k views

SQL Operating system error 5(Access is denied.)

Having trouble restoring .bak file located on desktop. My query RESTORE DATABASE MyDatabase FROM DISK='C:\Users\Mason\Desktop\48WSDB2_backup_2014_10_01_010027_0576172 - Copy.bak' results in ...