Questions tagged [database-restore]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
1 answer
11k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the innodb-force-...
88 votes
10 answers
197k views

pg_dump and pg_restore: input file does not appear to be a valid archive

I have used pg_dump on one machine and copied result file to another, where I tried to restore it. I believe schema is the same. However, I get: pg_restore: [archiver] input file does not appear to ...
1 vote
1 answer
100 views

Restore an Azure SQL database while retaining backups

I'm trying to figure out how to restore a database using the Azure Portal without losing either point-in-time or long-term retention history. My production database has both a point-in-time and a ...
0 votes
1 answer
2k views

pg_restore with ssl parameters - how to specify parameters right way?

I have PostgreSQL 11 server with ssl-only connections (it's "Managed PostgreSQL" service by my cloud provider) In documentation psql connection to this server should be like this: psql "host=xxx.mdb....
0 votes
0 answers
51 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 ...
0 votes
2 answers
1k views

Restore deleted exchange 2007 public folder from backup .edb file

We are running a stand-alone instance of Exchange 2007 without replication of any kind. We do have nightly backups. A user deleted a public folder, and I need to restore that from one of our full ...
0 votes
0 answers
98 views

Replicate AWS RDS Postgres instances

Faced a situation we need to consolidate few small postgres instances to a bigger one Cant figure out how to replicate "old" db new data to "new" db when the replacement happens ...
0 votes
0 answers
41 views

Deleted everything from google cloud - Can it be recovered? [duplicate]

I recently deleted everything from my google cloud storage and need to know if there is a way to recover the data.
0 votes
1 answer
4k views

Restore MySQL database is very slow [duplicate]

I've just bought a new home desktop. I have three MySQL databases that I want to move across. I dumped them all using mysqldump before removing the drive from the old machine. Restoring the largest of ...
3 votes
1 answer
526 views

Can I restore the SVN repository from the copy of the repository folder on the server?

The guy responsible for maintaining the SVN server was not having knowledge about the SVN server. Whenever he was told to take the backup of repository, He was just copying the folder of the ...
1 vote
1 answer
800 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 ...
0 votes
3 answers
388 views

Transfer a bigger MySQL/MariaDB DB fast, save and restartable

I have to transfer a Drupal site with a 43GB MariaDB DB via ssh/scp to another server. I have a limited downtime window early in the morning. In the past I transferred smaller DB's (<3GB) directly ...
1 vote
1 answer
1k views

How can I restore an Exchange 2010 mailbox to its original state after the mailbox has been deleted?

In our environment we are running Exchange 2010 with NetBackup 7 and Symantec eVault. We have global 25 year retention and no purging policies (insane, but that's what the boss wants). We use eVault ...
0 votes
0 answers
354 views

copying back *.ibd files in mariadb

I have full MariaDB backup with this lost files with mariabackup --backup They just removed by stored procedures from current instance. How can I restored this file (history_log#P#p201712030000.ibd) ...
0 votes
2 answers
1k views

R1soft error "MySQL restore already occurring for running instance, cannot continue"

I am using R1soft backup tool on my server(cpanel) and trying to restore the database backup but it gives me the error "restore failed". Attaching logs error here: Protected Machine: MySQL restore ...
3 votes
4 answers
4k views

mongorestore from stdin

On a remote server I have a file which is the mongodump output compressed, let me say a file called mongodb.tar.gz. Inside mongodb.tar.gz there is a directory structure like this: dump/dbname/ dump/...
2 votes
2 answers
292 views

windows server backup. how to restore msssql database

it's theoretical question. If i have a window server 2012 r2 which have mssql server installed. I add role windows server backup. So can restore the database which was backuped by windows server ...
1 vote
2 answers
2k views

RDS Mysql point in time restore fails - incompatible state

I have an RDS MySQL instance with MySQL version 5.7.19 for which a point in time restore failed with a status of "incompatible-state". Through experimentation I have determined that point in time ...
3 votes
0 answers
2k views

Got a packet bigger than 'max_allowed_packet' bytes

MySQL Community-Server 5.6.39 RHEL7 Scenraio: Trying to process binary logs to restore the incremental backup and receive max_allowed_packet error. Turned off binary logs,restarted the database. ...
0 votes
1 answer
2k views

Oracle 12c schema restore using impdp from a different server

I have created 2 EC2 instances in AWS. One acts as DB Server and one acts as client. Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server. I have ...
1 vote
3 answers
2k views

What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?

As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create ...
1 vote
2 answers
2k views

Can't restore Google Cloud SQL instance

I'm trying to restore my Google Cloud SQL instance to a backup from a previous date: gcloud sql backups restore 1504554300110 --restore-instance=[MY-DB-INSTANCE] Ultimately, it keeps giving an error:...
0 votes
1 answer
1k views

SQL 2012 Restore Issue - Exclusive Access cannot be obtained

Situation - We have a Live_db database, and a Test_db database. I'm trying to Take a copy of Live to use as Test. A Backup of Live was taken. The existing Test database was deleted (closing ...
1 vote
1 answer
3k views

No file access permissions after restoring database

I restored an SQL-Server 2012 database to a folder on my D-Drive. I can access the database and everything seems to work, but when I check the file access permissions of the mdf and ldf files, there ...
-1 votes
2 answers
1k views

restored Wordpress site from DB, wp-login.php redirects to old domain

We have a Wordpress .sql backup which we restored on a linux box. Now we want to log in to the admin console and export the site as XML. Unfortunately, the wp-login.php redirects to the old ...
3 votes
3 answers
17k views

How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

I am new to PostgreSQL. I have to recover a database which was running in widows XP machine. I have the zip folder of postgres. I have extracted postgres installation in a different PC and started a ...
4 votes
1 answer
928 views

Can I restore SQL databases from full Windows server backup if needed

I have scheduled backup and every day copies of: bare metal recovery system state system reserved local disk C:\ Backup is stored on iscsi disk. On local disk C are databases mdf with logs. In ...
4 votes
1 answer
5k views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
6 votes
2 answers
39k views

Recover mysql database - mysql/mysqldump gives "table <database>.<tablename> doesn't exist (1146)"

Backstory Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql. Reinstalled ...
0 votes
3 answers
20k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
2 votes
2 answers
2k views

restore content database in sharepoint server 2007

I have a site collection set up at web app running at port 80. I have made the backup of the site collection content db using stsadm.exe tool. Now, I want to restore that backup as a new content db of ...
0 votes
1 answer
86 views

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I ...
4 votes
1 answer
836 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
1 vote
2 answers
3k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...
1 vote
1 answer
111 views

Why does SSMS Restore Database to another database not copy the current state of the "From" database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
0 votes
1 answer
297 views

Can you restore multiple Oracle databases with the same tablespace name?

I am in the process of setting up an Oracle instance for customer database restores. The vast majority of our customers use the same tablespace name for their databases, which leads to us needing a ...
2 votes
1 answer
2k views

MySQL ZRM restore failed with mysql error unknown command \0

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'. ...
2 votes
2 answers
13k views

Recover MySQL tables from frm files

I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
2 votes
5 answers
52k views

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?
0 votes
0 answers
155 views

no access to preivous databases in mysql56 after password reset, but showing in data folder

i had problem with mysql (windows machine, mysql5.6) login because of power failure, after trying various solution, i did password reset for root. This helped me to login mysql using root account. But ...
1 vote
2 answers
227 views

MySQL transfer from backups

I had a server die and I have been trying to restore the data onto a new server. I had a mysql database. I have all the files stored in /var/lib/mysql. Each database had a database privileges ...
0 votes
1 answer
265 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
2 votes
1 answer
962 views

Recovering/Rebuilding MySQL .FRM, .MY* files from IBDATA1

I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a ...
0 votes
1 answer
238 views

PostgreSQL 9.1 won't restore because "a user is connected"

I'm transferring a database as part of transferring a website. I've not used PostgreSQL before, so assume that I don't know much about it (I primarily use MySQL). We cannot directly connect the ...
0 votes
1 answer
255 views

selectively import "record sets" from one mysql instance to another

I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment. Sometime bad things happen, e.g. we delete a row (and all ...
2 votes
1 answer
4k views

Restore SQL Server 2008 db without affecting users

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
2 votes
1 answer
73 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
1 vote
3 answers
1k views

Restore MySQL Databases from File backups, not MySQL Export

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that. I've tried just copying the database files into ...
2 votes
2 answers
461 views

Hosting server's harddisk crashed [closed]

My hosting provider has told me that the server harddisk that I am currently using is crashed and they failed to recover most of the data and they only managed to recover some files or folder from the ...
2 votes
2 answers
9k views

Unable to restore a Mysql database using an sql dump file

I am setting up a new project on my development system and am stuck with creating the database. I have a large .sql file to create the database with. At first I created an empty database called ...