When I deleted the file, I did not add a condition and deleted it by mistake. what can I do to restore it?

I added less than one condition and deleted it by mistake when I deleted it. is there any way to restore it? when I deleted it, I added less than one condition and deleted it by mistake, is there any way to restore it ???, If you have any database backup, you can recover it! In addition, there are no logs. if there are no logs, you should be careful about Amitabha. When I went to MySQL/Post and deleted it, I did not add a condition and deleted it by mistake. Is there any way to restore it?
When I delete a file, I add less than one condition and delete it by mistake. Is there any way to restore it ???

------ Solution --------------------
If you have any database backup, you can recover it! There are no logs. if neither of them is found, you should be careful when applying the logs to Amida Buddha.
------ Solution --------------------
This is difficult. Go to the MySQL/Postgresql Forum.
------ Solution --------------------
I also want to know
------ Solution --------------------
If you have logs, do not prepare a paper towel.
------ Solution --------------------
In linux, logs can be retrieved. go to mysql and sympathize with you.
------ Solution --------------------
Let me tell you a way to try it. you are not afraid of data loss.
Add a field to indicate whether to delete the table.

When deleting data in the future, you do not need to delete data but use update.


------ Solution --------------------
Discussion

Let me tell you a way to try it. you are not afraid of data loss.
Add a field to indicate whether to delete the table.

When deleting data in the future, you do not need to delete data but use update.

------ Solution --------------------
Discussion

Reference:

Let me tell you a way to try it. you are not afraid of data loss.
Add a field to indicate whether to delete the table.

When deleting data in the future, you do not need to delete data but use update.


... When I want to update...

------ Solution --------------------
If mysql5 is the default storage engine, innodb should have good transaction logs for innodb.
You can use myqlbinlog to restore and view the usage of this command.
If there is no transaction log, check whether you have backed up the log.
If there is no, it is estimated that there will be no drama.
------ Solution --------------------
If mysql5 is the default storage engine, innodb should have good transaction logs for innodb.
You can use myqlbinlog to restore and view the usage of this command.
If there is no transaction log, check whether you have backed up the log.
If there is no, it is estimated that there will be no drama.
------ Solution --------------------
If mysql5 is the default storage engine, innodb should have good transaction logs for innodb.
You can use myqlbinlog to restore and view the usage of this command.
If there is no transaction log, check whether you have backed up the log.
If there is no, it is estimated that there will be no drama.
------ Solution --------------------
Go to the SQL area to find hero.
------ Solution --------------------
Can I recover logs? how can I recover the logs? I am not familiar with this.
------ Solution --------------------
You are too bold.
Try not to operate the database directly in the real environment.
To do this, follow these steps:

1. write where and then delete to prevent you from hitting the carriage return carefully.

2. add limit 1. you can use limit 100 to delete multiple rows. minimize the loss and avoid high mysql load caused by a large amount of data deletion.

3. read it several times.
------ Solution --------------------
What I said upstairs is that I also experienced accidental deletion. Fortunately, there was a backup of the day, and now I am not directly operating the database.
------ Solution --------------------
Discussion

You are too bold.
Try not to operate the database directly in the real environment.
To do this, follow these steps:

1. write where and then delete to prevent you from hitting the carriage return carefully.

2. add limit 1. you can use limit 100 to delete multiple rows. minimize the loss and avoid high mysql load caused by a large amount of data deletion.

3. read it several times.

------ Solution --------------------
Don't be afraid of it. could you back up your data from a primary machine...
------ Solution --------------------
Yes. find the host machine provider to provide you with backup ~ What are you worried about.
------ Solution --------------------
When you create a database, do not delete it physically.