Questions tagged [data-loss]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

What happens if you interrupt a POSTGRESQL database that's receiving data?

I have a Docker application and as a quick and dirty backup strategy, I'm thinking to tar the whole project incrementally and send it off remotely. I'd rather keep the services running while doing the ...
2
votes
1answer
941 views

MS SQL 2008 Databse in Suspect mode and CHECKDB returns error: Object ID 3 has chain linkage mismatch

We did a disk expansion for VM DB server. However, after this operation the DB became suspect mode and cannot be open. Then we tried somethings like that; https://www.sqlrecoverysoftware.net/blog/...
0
votes
1answer
135 views

Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?

I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider. For some reason this other ...
0
votes
1answer
25 views

Can vmware (virtualisation) configuration impact the data integrity of the data file [closed]

I'm wondering how much can a VMWare configuration impacts the integrity of the data file. I mean, if the VMWare configuration is not optimal and the database writes a lot of complex operations (...
1
vote
1answer
525 views

Can power failure rollback mysql innodb database of many days?

I have an application running on a x86 system with MySQL InnoDB database. This application store many rows per day and yesterday, due to a power failure, I experienced a rollback of a one entire day ...
0
votes
1answer
1k views

Worry to delete Read replica RDS

I created a read replica from RDS , and I do want to delete it. I am so worry about affecting the origin RDS which is in PROD . Is it recommended to take snapshots before deletion of read replica ...
2
votes
0answers
234 views

Old records disappearing after upgrade from 9.4.1 to 9.4.4

I recently upgraded from 9.4.1 to 9.4.4. Since then millions of rows have disappeared from several tables containing historical data. The severity of data loss seems to be directly proportional to ...
0
votes
0answers
43 views

DB Rolls Back And Loses Data

So we've come across an astounding issue here. At random moments, our DB is dropping the database and recreating the table with data from an earlier point in time. Unfortunately general query logs ...
0
votes
0answers
263 views

How to notice data lost in innodb engine

I have a web-application installed in some desktop pc, and I experienced some troubles with mysql innodb. In case of hardware fault (disk failure) or just power fault I lost many data in my database ...
2
votes
3answers
4k views

MySQL “lost” all data(InnoBD)

Today I was making some work with site and I get error what MySQL can't rename file (to make changes in BD). Next I tried to restart MySQL, and it failed to stop MySQL. Then I did go to /var/lib/mysql ...
2
votes
1answer
3k views

How do I access a old saved tablespace after reinstalling postgres?

So a lot of things might have gone wrong here. I first installed postgres 9.3 on mac 9.1 via homebrew to manage some data. I am using postgres.app. Turns out my harddrive was too small so I decided to ...