URGENT: Request for recovery of mistakenly deleted data

[new_user_to_infinity]

Urgent. Please Help! Mistakenly deleted data when copy database structure from a existing database to a new one.

Hello! There is a problem with my database if0_37952891_fps:

I originally intended to export the structure of the “if0_37952891_fps” and then import it into a new database “if0_37952891_fes”. However, after performing a series of operations, I couldn’t identify which specific operation caused the issue—mostly because the SQL logs showed “0 rows affected” in most cases. Unfortunately, this resulted in some tables in the original if0_37952891_fps database being emptied.

The structure of all tables is still there, but the data of some tables has been mistakenly cleared (turned to 0 rows), while the data of some tables is normal.

Could you please help me:

1. Check if the server has an “automatic backup” of this database (such as the last 1-3 days’ backup). If so, help me restore it to the “version before data loss” (or only restore the data of those empty tables);

2. If there is no automatic backup, please help me extract the mysql data file corresponding to this database (.ibd file, the path is usually /var/lib/mysql.if0_37952891_fps /), especially the.ibd files of those empty tables, I need to use them to restore the data.

3. When restoring, please retain the data of the existing normal tables to avoid overwriting.

THANK YOU VERY VERY VERY MUCH!

[Greenreader9]

@new_user_to_infinity

Check if the server has an “automatic backup” of this database

No, free hosting does not have backups

@new_user_to_infinity

please help me extract the mysql data file corresponding to this database (.ibd file, the path is usually /var/lib/mysql.if0_37952891_fps /

You can make database exports by logging into PHPMyAdmin from the databases tab in the client area, then selecting “Export” at the top of the screen.

In the future, I highly suggest taking regular backups across your entire account, and an additional backup before making any major changes. I also recommend making your database names more specific, those names are so similar I can see them getting easily confused.

[new_user_to_infinity]

I do have one backup, the latest backup is 10 days ago. I just don’t expect this thing happen. I was only export from the old one and import it to the new one.

Do you mean free hosting do not have backups physically, or do you mean no such service for free hosting? Is there anyway to turn to a paid plan and recover the data?

[Meishin]

Free hosting do not have backups physically.

[new_user_to_infinity]

Thank you for the explanation. I will consider a paid plan.