Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: MySQL checking Deleted Rows


    I have one table which have more than 1076967 rows. the table have ID filed with auto-increment value.

    I need to check if some row is deleted from that table or not? We are suspecting some hacker he delete some rows but in this huge records i cannot find if really it is deleted?

    Please help to find out, how i can check if any record is deleted from this table?

    Best Regards,

  2. #2
    Join Date
    Jun 2007
    What makes you believe that data jas been deleted?
    Is it because there are gaps in the sequence of IDs?
    Do you know the ID, or other key values, of the deleted record?

    Gaps can occur in the sequence of IDs due to delete's, transactions rolling back or bulk inserts - go to this page and search for the word gap.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts