Someone who knows freebsd

[zeimpekis9 68]

In /var/db/mysql i have ibdata1, ib_logfile0, ib_logfile1.
For some reason item table is missing data. Can i restore these data from these 3 files i told you before? If yes can anyone help me how can i do it?
I will pay him.

discord: MrVibe_#7901

[JarajTo 40]

But which data? Everything?

When not, check db core logs.

[iltizio 212]

The subject of this topic is wrong. You need a MySQL DBA.

That files are redo_log: https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html

If you use a transational storage engine (like InnoDB or xtradb) you can restore some unwritten data after a DB crash.

if you have lost a lot of data after human error or application bug, the only way to recover it is from backup.

 

You should always do backup.

[zeimpekis9 68]

16 hours ago, iltizio said:

The subject of this topic is wrong. You need a MySQL DBA.

That files are redo_log: https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html

If you use a transational storage engine (like InnoDB or xtradb) you can restore some unwritten data after a DB crash.

if you have lost a lot of data after human error or application bug, the only way to recover it is from backup.

 

You should always do backup.

For some reason, this day db was overloaded, and then i lost the data only from item table. Thats why im asking if i can restore them because i didnt delete them by my mistake. It was deleted just because it was overloaded. 

Can you add me in skype so we can speak? 

[Fire 23]

If you don't got a backup you can't do a lot

[iltizio 212]

9 minutes ago, zeimpekis9 said:

For some reason, this day db was overloaded, and then i lost the data only from item table. Thats why im asking if i can restore them because i didnt delete them by my mistake. It was deleted just because it was overloaded. 

Can you add me in skype so we can speak? 

Added, but I think we can't do something. I can help you to prevent this.