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.

Don't know but it is likely you could do a find/replace using PERL or some other script language pretty quickly.

The difficult part is to find where the row starts/ends so to find what 00 you have to change.. i am so confused..