I am in the deletion of the time, less add a condition, mistakenly deleted, there is no way to recover

Source: Internet
Author: User
I delete the time, less add a condition, mistakenly deleted, there is no way to recover
I delete the time, less add a condition, mistakenly deleted, there is no way to recover it???

------Solution--------------------
You have no database backup, some words will be restored! In addition there is no log, if neither of them, Amitabha, the donor should be careful after
------Solution--------------------
This is so hard. Go to the Mysql/postgresql section and ask.
------Solution--------------------
I want to know that, too.
------Solution--------------------
There's a log, you can have a paper towel and cry.
------Solution--------------------
Linux really can be retrieved through the log, go to MySQL version, sympathize with you
------Solution--------------------
Tell you a way to try, not afraid of data loss
Add a field when building a table to indicate whether or not to delete

Delete data later without deleting instead of using update


------Solution--------------------
discuss

Tell you a way to try, not afraid of data loss
Add a field when building a table to indicate whether or not to delete

Delete data later without deleting instead of using update

------Solution--------------------
discuss

Reference:

Tell you a way to try, not afraid of data loss
Add a field when building a table to indicate whether or not to delete

Delete data later without deleting instead of using update


... Then I want to update the time accidentally ...

------Solution--------------------
If it is MYSQL5 the default storage engine should be INNODB for InnoDB have good things to log
You can use the Myqlbinlog recovery method to view the use of the command
If there's no log of things, it's up to you.
If it's not there, I guess it's over.
------Solution--------------------
If it is MYSQL5 the default storage engine should be INNODB for InnoDB have good things to log
You can use the Myqlbinlog recovery method to view the use of the command
If there's no log of things, it's up to you.
If it's not there, I guess it's over.
------Solution--------------------
If it is MYSQL5 the default storage engine should be INNODB for InnoDB have good things to log
You can use the Myqlbinlog recovery method to view the use of the command
If there's no log of things, it's up to you.
If it's not there, I guess it's over.
------Solution--------------------
Go to the SQL area to find heroes.
------Solution--------------------
A log can be restored, how to recover, I want to consult, not familiar with this
------Solution--------------------
You have too much guts.
Real environment try not to manipulate the database directly.
If you want to use steps:

1 Write the where last write delete to prevent you from accidentally touching the carriage return.

2 plus limit 1; Deleting multiple lines can be done with limit 100; Minimizing the loss and avoiding large amounts of data deletion causes the MySQL load to be too high.

3 to see it a few times more.
------Solution--------------------
Upstairs said is, I also appear the mistake deletion situation, fortunately have the day of backup, now do not directly manipulate the database
------Solution--------------------
discuss

You have too much guts.
Real environment try not to manipulate the database directly.
If you want to use steps:

1 Write the where last write delete to prevent you from accidentally touching the carriage return.

2 plus limit 1; Deleting multiple lines can be done with limit 100; Minimizing the loss and avoiding large amounts of data deletion causes the MySQL load to be too high.

3 to see it a few times more.

------Solution--------------------
Not afraid, looking for the host to provide backup to you ...
------Solution--------------------
Yes, looking for a host to provide you with backup AH ~ What a good worry about it.
------Solution--------------------
After the database is built, delete it to a state, do not physically delete.
  • Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.