Questions tagged [data-loss]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
23 views

How to implement historical data with this EERD?

I am looking for a way to implement historical data with the following EERD (what I have tried, below the image): What have I tried? Temporal tables Didn't work because I use MySQL and it has no ...
user23600793's user avatar
0 votes
1 answer
26 views

MySQL Data not flushing to disk

Lets start with what I did... I copied a table via PHPmyadmin operations/ copy table/(temp1) structure and data. nothing should make any changes to this copy.phpmyadmin shows 1185199 entries I copy ...
tek-dragon's user avatar
0 votes
0 answers
266 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 ...
progonkpa's user avatar
  • 101
2 votes
1 answer
1k 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/...
Fatih's user avatar
  • 21
0 votes
1 answer
267 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 ...
user avatar
0 votes
1 answer
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 (...
Ganbin's user avatar
  • 101
1 vote
1 answer
692 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 ...
Tobia's user avatar
  • 199
0 votes
1 answer
2k 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 ...
Abdennour TOUMI's user avatar
2 votes
0 answers
254 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 ...
sheepdog's user avatar
  • 345
2 votes
3 answers
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 ...
user avatar
3 votes
1 answer
4k 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 ...
Allen Lee's user avatar