Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: Recover Data from table

    Hello there.

    Unfortunately yesterday my board was hacked by someone. Fortunately i did have backup.. but it was one week back. So what he did was to empty most of the tables but due to the structure of mysql i think it is possible to recover the data.
    We want to recover rows from a mysql (.myd) file marked as deleted. the first byte of each row has been set to 00. Setting it differently would allow a repair with the regular myisamchk utility. Do you know any way of doing that except doing it manual row by row (its about 200.000 rows )

    I 'll appreciate any answer
    Best Regards,
    Kostas.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    Don't know but it is likely you could do a find/replace using PERL or some other script language pretty quickly.

  3. #3
    Join Date
    Nov 2004
    Posts
    2
    The difficult part is to find where the row starts/ends so to find what 00 you have to change.. i am so confused..

Posting Permissions

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