recovery's questions - English 1answer

305 recovery questions.

For some reason, when I try to open up my tables that are stored in .frm and .ibd files (whether on MySQL or phpmyadmin) it gives me a syntax error, or it says it does not exist. I've read the other ...

To give a bit of background, I was looking for the occurrence of specific text from within multiple SQLite DB files. I initially tried a simple grep of the text on the multiple files and grep found ...

So I've been building up over time a database, and unfortunately I was using MyISAM which didn't have any problems until the database became huge. After massive CPU spikes, I created a script to ...

I had a server fail (disk failure, old server; no raid) at the weekend and am unable to recover the MySQL databases from the backup. After exhausting all the usual recovery options, I've performed a ...

i have probleme with mysql data base in wamp ; i droped my base from phpmyadmin now i traynin to recover i creat a new one whith the same name and i import some data to croorect but its was not enough ...

I have a mysqldump of all databases, including mysql. I'm using mysql 5.6 on Windows 2008 R2. How can I restore my backup ? The problem is that I cannot start the server when the database mysql is ...

I have a problem with my database, today I suddenly can't login using root. So I look for solution on the web and made a terrible decision, I used the command mysqld --intialize. Now I can login to ...

Incarnations are explained in an answer to another question on this site. The answer mentions 'orphaned' incarnations: …There are other factors that result in ORPHANED incarnations and OBSOLETE ...

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:/...

I have 3 database 1 primary and two standby, The storage of one the standby was abruptly removed without shutting down the database. Few Days later the storage was returned, I restart the whole ...

I was doing some investigation on how other DBAs go about performing automated regular tests of their database backups to ensure recoverability in case of disaster and I'm quite disappointed at what ...

I have a web application setup where there are separate Apache-Wordpress containers for development and production. Database is hosted externally on a virtual host. When setting up development ...

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...

I have to re-build a mysql database (some tables were truncated), Is it possible? What logs do I need? My mysql is 5.7 running on ubuntu 18.4

I want to capture the changes made between two database versions in Microsoft SQL server. When I restore my database from one version to another using transaction logs, I want to know what changes are ...

I was importing an old SQL into existing schema. But the MySQL service was stopped suddenly. Now I'm not able to start the service. It seems that the ibdata1 file is somehow corrupted. Here are the ...

I accidentally truncated data from 8 tables. I am new to MySQL and was wondering if someone could help me with step by step instructions to restoring the data. Also, I have no experience with ...

One of my machine got crashed last day and i ended up reinstalling windows on that machine. It had a mysql server in it. Is there a way to recover mysql data from that machine now . There are couple ...

Today, after a power failure, one database (with Recovery: full) shows "In Recovery" in SSMS. So: myDatabase (In recovery) (database status: recovery, Shutdown) After finish, the "recovery ...

We are going to move some 100+ databases and some of them are 1 TB each. To save time on Friday, we are going to perform restore from sunday's Full backups using with norecovery. And we do this ...

I have oracle 11g that runs on Linux serve. I have a Flash Recovery Area, I backup my archive logs to another location. presently I have very little space left in my Flash Recovery Area (FRA) thereby ...

Hi I have 2 node cluster where recently went offline not sure why. Node1 started fine and all the traffic is on node 1 but node 2 still down due to below error. I tried set the inodb recovery to 3 and ...

I've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given ...

We are currently trying to import some old historic data tables. Unfortunately, the data is in exported tablespace files (.ibd and .cfg) - there are no dump files available and the server they came ...

I'm running MongoDB 2.6 on Ubuntu 14.04 and I accidentally deleted db file in /var/lib/mongodb. I cannot restart the MongoDB instance: mongo: error SEVERE: unable to open file number 5. If I ...

We have an Oracle database, one data file (users tablespace) of the instance got corrupt and another data file (containing application data) was deleted due to some issue. The database is in ...

This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups (...

I have deleted all directory by mistake except from the given link /var/lib/postgresql/9.5/main/base/18686 and so on. I have 4 such directories, now I want to get data back from those folder as they ...

At a client site with a development Oracle 11.2.0.3/linux DB power outage and crash - no archivelog mode - no backups - Don't know how this was even running select file#,substr(name,1,70) name, ...

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...

I was tasked with recovering data from an old, unmaintaned server, where its main purpose application was no longer working. Basically just want to get a postgres db dump before burning the server to ...

I have a MariaDB 5.5.56 install (The default CentOS 7 package). The VM was running on a host that had some problems reaching its storage. This resulted in the OS remounting some filesystems read-only....

I tried to ALTER a table to add a FOREIGN KEY as: ALTER TABLE artists ADD FOREIGN KEY(country_id) REFERENCES countries(country_id) ON DELETE CASCADE; and I received an error of ERROR 2013 (HY000): ...

I've made a stored procedure restoredatabase that returns code to restore a database. The output script looks like this: restore database [DB] from disk='F:\FULL1.bak' with norecovery restore ...

First of all, I even don't know how naive is the question, we start studying this not long ago. A friend of mine was working on Data Modeler, he saved the design and he only got the "logical" folder, ...

I have a database that is stuck in recovery mode for few days already. There are multiple threads about this, but the solutions there don't work for me. Here is what I tried already: RESTORE ...

I have a bigger database with around 1000 tables. Unfortunately after a OS X update everything vanished, but I was able to recover all the file that now consists of only .frm and libd files. Following ...

I'm studying a little DBA stuff and I've come across instance failure/recovery. Let's say User A does DML and User B also does DML. At this point, I believe it's safe to assume DB buffer cache ...

In postgreSQL version 8.4 it seems that you can place the db server into warm standby mode with the following setting in recovery.conf restore_command = 'pg_standby archiveDir %f %p %r' In ...

When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-...

Scenario: Let us consider oracle 3 node RAC. RMAN Managed Recovery is configured between production and standby DBs. Let us assume that the SCNs of 3 nodes are S1, S2, S3 at some point of time ...

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...

When I have already performed an abort to transaction Ti in log file, for that transaction Ti, what does it mean to Redo(Ti) after that? What are the changes brought to Disk containing the data and ...

I currently have a corrupt database on my live site, because a single Table that has gone missing. Table 'test1.catalog_product_index_price' doesn't exist I logged onto my server and downloaded a ...

I've an urgent problem. Due to some heavy delete queries, my database transaction log has grown and it has filled the disk (126GB). I've found out that backup plan wasn't working during last month. ...

I have a really big problem with my database: There was an electrical failure, a hard drive got damaged, whenever I tried to start the mysql server I got the error "I/O ERROR", I found that the ...

I have a pretty big PostgreSQL 9.1.3 running on Ubuntu 10.04. The data is spread over multiple tablespaces = physical drives. One of these drives is gone, so the directory of that tablespace doesn't ...

(This is not a production database. I'm practicing in a staging enviroment.) I'm trying to set up RMAN for backup/recovery. I did a full backup, which seems to be in a good state. I then did an ...

I have a Mongo replica set with a few secondaries. A box, which hosts a secondary instance, crashed and lost the database. I started the secondary Mongo instance again and now it's stuck in STARTUP2 ...

Related tags

Hot questions

Language

Popular Tags