Recover SQL

[Freakmeister]

Hey, I'm trying to recover MySQL database dump. It's basically a text file. But after I restored it with Recuva and tried to open it, it looks like a binary file. And of course I can't import that. Is there any solution to this?

Edited April 3, 2020 by Freakmeister

[nukecad]

Can you not use the original SQL to make a new backup dump?

[Freakmeister]

I don't have this database anymore. That's why I'm trying to recover dump file.

[nukecad]

Sorry I don't know.

But if it has recovered and is actualy readable, albeit as binary, then there may be a chance that it will import as a binary to whatever created the database in the first place.

Is there a forum for whatever app created the database? If so then that may be the place to ask about importing a binary.

[Freakmeister]

It's my own database for old CRM I developed. I deleted dump about month ago. After recover I tried to import dump file back to MySQL server as binary - this doesn't work. It's strange because Recuva says "No overwritten clusters detected" and icon was green. But I guess it was partially overwritten anyway. Or Recuva saves this file in a different way after recover, I don't know. Same thing with zip archives btw. I tried to restore one zip-archive, Recuva showed green icon, but then I can't open this file with WinRar, it says that file is corupted.

[Freakmeister]

Okay, so I opened ~500 Mb dump file in text editor and I coudn't find any "1" there. File looks like this.

What does this mean? File was corrupted? Or Recuva just doesn't save it the right way? File size of ~500 Mb looks right, but it's basically a dummy inside. Same thing with zip file if I open it in text editor.