0

I wanted to know if it is possible to recover a .SQL file that was corrupted, the HD was formatted and I forgot to backup it. I used a program to recover and the file looks like this:

enter image description here

eis
  • 51,991
  • 13
  • 150
  • 199
Kauã Torres
  • 1
  • 1
    what kind of content are you expecting the .sql file to have? just ascii text, or did it contain a dump about binary files, or text using some non-common language? That has an impact on how you should approach this. If it's supposed to contain ascii text, this does not look like that at all, so it is possible the software you used just didn't work out in recovering. – eis Feb 19 '22 at 16:46
  • A .sql file should contain SQL commands (and maybe some comments), so it should have readable text. – Luuk Feb 19 '22 at 16:48
  • Maybe you see zip file content of sql file? Try unzipping it. – Justinas Feb 19 '22 at 16:51
  • eis. - It's a table backup I did. Luuk. - How do I resolve it? Justinas. - It's not a zip file. – Kauã Torres Feb 19 '22 at 17:26
  • Did you try to open it in another text editor? If you still getting the same in another text editor, it is surely an encoding problem. You have a different encoding in your database. Please try to set character set encoding in your database to UTF-8 – Roby Raju Oommen Feb 19 '22 at 17:39
  • Please see: https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 – Roby Raju Oommen Feb 19 '22 at 17:45

0 Answers0