Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 4 Jahren, 11 Monaten
Letzter Beitrag:
vor 4 Jahren, 10 Monaten
Beteiligte Autoren:
Amal Murali, Jose Antonio Garrido, Fabrice Harari, DarrenF, Yogi Yang, Piet van Zanten, Peter Holemans

How to Convert/read Corrupted HyperSql Files??

Startbeitrag von Amal Murali am 24.09.2013 04:32

Dear Friends;

I am using a Windev application and by rny mistake i accidentally deleted the Database files( that is the BDD directory of the HyperfileSql). On knowing rny mistake i recovered the files with the help of a File Recovery Shop and i got all the files and the number of files and the total size of the directory restored is the same but i am unable to read from that files. My HyperfrleSql shows error that it is not Windev1/Webdev/Windev Mobile 18.0 format.

Please somebody help me. the data is very important for me??? Is there any tools or people who can solve the issue to read that database Lies??



Hi Amal,

Step 1: Remove the index files (*.ndx)
Step 2: Via the HF Control Center -> Select Database -> Maintenance -> Execute Option 4

Just my 2 cents,

Peter H.

von Peter Holemans - am 24.09.2013 08:52
thanks peter;

The problem is hyperfileSql is not reading any of the database files from the bdd directory then how can i index the files.
Is there any other way to convert this file to any other format?


von Amal Murali - am 24.09.2013 12:23
Hi Amal

my first answer is to tell you to just restore your last backup.... but from the content of your message, it looks like you do not have one, which is your first mistake.

The second is... It depends. If the files were encrypted/password protected, then there is probably no way to get your data back.

If not, then it MAY be possible to write some code to extract the data directly from your files and rewrite them in a DB... BUT:
- it will take time
- it will be difficult
- All the data may not be restored

Best regards

von Fabrice Harari - am 24.09.2013 13:38
Hi Amal open the files with winhex or similar editor. Just to see What they contain. If the files were not encrypted you should see plain text content. Maybe thy recovered the files assuming they were in contigous sectors of the disk? Thats the case of some recovery tools.

von Jose Antonio Garrido - am 24.09.2013 13:39
Thank you Jose Antonio Garrido;

i used the Winhex software to open the files but it is showing in some other format like hexadecimal numbers.

I used the same software to open working database files but it is showing the same way in hex decimal digits not plain text.

Please help


von Amal Murali - am 24.09.2013 14:44
Thank you Fabrice Harari;

I need to get the data back so i recovered the files, the recovered files look the same that of old file but when i try to open the HyperfileSql it is showing not Windev1/Webdev/Windev Mobile 18.0 format.
Hence i conclude the data is corrupted..is there a way to read the files???


von Amal Murali - am 24.09.2013 14:48
Hello everyone;

Please find one small file with only 3lines of data that i had recovered but i am unable to read the file. Can anyone help me to read this file.

Please download the sample file(3kb) that i had recovered

Hardwork will be rewarded if required!!!


von Amal Murali - am 24.09.2013 15:33
Hi Amal,

I'm afraid your recovery has failed, the file is completely filled with binary zeros.


von Piet van Zanten - am 24.09.2013 16:29
I concur

you may have recovered the name of the file and maybe it's size, but it's content is just a long string of 0s....

And that is quite strange, as deleting files DOES NOT fill them with zeros. Only when you use a low level file scruber do you get that kind of content... So it doesn't look like "i accidentally deleted the Database files( that is the BDD directory of the HyperfileSql)" is holding water anymore...

How exactly dd you "accidentaly" delete those files, and are those files even yours?
An even more interesting question: if those files are so important for your, how come you do not have any backup of them?

I am asking for some transparancy here because this is NOT a hacking forum... So please explain enough to establish the legitimity of your request.

Best regards

von Fabrice Harari - am 24.09.2013 18:16
As Piet and Fabrice said, that file was not recovered. It's filled with zero.

How exactly happened?

I ask this because usually it's pretty easy to recover deleted files if you know what to do, since they are not complety deleted until the space they ocupped in the hdd is needed for new files.

von Jose Antonio Garrido - am 24.09.2013 19:15
Hello All;

As said those files were very important for me..I had set backup for the data but it was too in the same system...I accidentally deleted(Formatted the entire disk)forgeting that backup is set in the same hard disk.
Since the files were very important for me i gave the hard disk to a shop for recovering but got the files in this way(Sample file uploaded earlier).
I don't know what to do???

Is there any chance to get the data back??

Regards & Thank you;

von Amal Murali - am 25.09.2013 11:34
If the only thing you did was to format the hard disk, then you can recover 100% of your files. Even if you used the slow format option.

Also I asume that the recovery shop did recover the files on a different media (external hdd, usb memory, etc) and the original HDD is still untouched since the format.

With winhex it can be done in two mins.

edit (it will search for deleted partitions, then you can mount the deleted partitions, and then you can browse the mounted partition and copy anyfiles you want. It support even RAID discs)

José Antonio.

von Jose Antonio Garrido - am 25.09.2013 12:14
Did you install anything on the HDD after formatting it by mistake?

If your answer is Yes then the chances of recovering data completely is negative.

The files that have been recovered by the recovery shop are thrashed. it seems they have used Drive Rescue for recovering. And it is a known problem with Drive Rescue. Tell them to try to recover using 'Steller Phoenix' or 'GetDataBack'. In my last job we used to use these for recovering data.


Yogi Yang

von Yogi Yang - am 25.09.2013 12:52
Thank you Yogi Yang;

I am afraid i re-installed windows server after formatting the entire hard disk...will it be a problem??


von Amal Murali - am 25.09.2013 14:58
Was there a period of time where you could check if the company had actually recovered the files or did you just take their word for it? I would approach them to see if they have still retained the original data at their end - maybe there was a problem when they transferred it to the media they eventually gave to you or maybe they still have an original image of your data?

Also, hoping it's not too late, but have you tried the "Redo Backup and Recovery" utility?

von DarrenF - am 25.09.2013 23:20
Amal Murali
I am afraid i re-installed windows server after formatting the entire hard disk...will it be a problem??

Yes this will be a problem. There are chances of recovering only those files whose sectors are not overwritten by the new installation.

von Yogi Yang - am 30.09.2013 11:45
Thank You Darren Farmer;

I cannot find the "Redo Backup and Recovery" utility?Can u please Help


von Amal Murali - am 30.09.2013 11:48
Thanks Yogi Yang;

I Know the possibility of Auto backup, but it wont be useful unless the files are read only.

So is there a way so that the backed files are saved as read only or a way to prevent the deletion of database files??

Plz help


von Amal Murali - am 30.09.2013 11:49

Not sure how hard you tried, but if you cut-n-paste "Redo Backup and Recovery" into Google, the 1st result is:

http://redobackup.org/ :cheers:

It allows you to boot from DVD or USB drive etc... and then offers quite a few disk based utilities.

A very useful tool to have in your arsenal! :spos:

von DarrenF - am 30.09.2013 18:05
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.