Corrupted Database error #1064 :(

Nuncaparo · May 5, 2021

I am totally in trouble, I have to restart a wordpress site for which I have a backup of the database and the site's (ftp) folder. My problem is that the database seems corrupted. No matter how hard I try to import it, I still get the same error message:

Erreur

Requête SQL :
MySQL a répondu :

#1064 - Erreur de syntaxe près de '?=o???
???V*?{?W??V??????׬???|͋?y??}?#r?Daą{}??
?????Z?
?IG`{?x?...' à la ligne 1

I don't have the original SQL version and the php version used (the backup dates from 2016-2017)
The owner forgot to pay the web host, all that remains is my manual backup whose database is corrupted ^^
Does anyone have good skills in database or MySql for restore my database or repare it ?
Also tried to open in local with WAMPserver = same result.

I have no idea to what to do

thank you to those who can guide me on this bored thread!

Bests Regards
Nuncaparo.

india220 · May 5, 2021

Can you post the screenshot?

frizzel · May 6, 2021

It's a syntax error in the first line of your code which may or may not be related to the MySQL version, but to know what exactly it points to it's indeed probably better to post a screenshot as the text in what you copied doesn't make much sense (the text between ' ' ).

Nuncaparo · May 6, 2021

Thank's for your time guys, there is an screen shot of my three step :

Search the sql file, then import
Execute the import to replace an existing new empty database
Error 1064

Also we can see, the preview of the database means nothing on windows10 preview when i select it, but i think it's normal.

frizzel · May 6, 2021

It seems your SQL file is indeed corrupted. It's not normal to see such gibberish in the preview pane of Windows 10, you should just see the contents. Just to be sure you can open the file in a simple text editor like Notepad and you'll see the same.

I'm afraid there's nothing you can do about this, unless you have another copy of the file.

Nuncaparo · May 7, 2021

frizzel said:
It seems your SQL file is indeed corrupted. It's not normal to see such gibberish in the preview pane of Windows 10, you should just see the contents. Just to be sure you can open the file in a simple text editor like Notepad and you'll see the same.

I'm afraid there's nothing you can do about this, unless you have another copy of the file.

hmmm then im f*ck xD
I was hoping there is a tool who can repare corrupt database...
I tried to found an old backup but there is only this one left on my NAS.

Anyway, im gonna to rebuild the entire website from 0 then

Thank's for you help dude

frizzel · May 7, 2021

If you check the sql file in Notepad (or even better Notepad++), is it only gibberish text that you see, or are parts readable? Things like: CREATE TABLE `wp_posts` or similar.
If there are readable contents, maybe part of the database can be restored.

Ankesh16 · May 7, 2021

@Nuncaparo paro Can you share your database here.

ekey64 · May 7, 2021

I would look into the UTF8 encoding. Sometimes French characters will cause the error if the original db was from a different encoding.

frizzel · May 7, 2021

Ankesh16 said:
Can you share your database here.

Why would anyone share a complete database on a public forum?

ekey64 · May 7, 2021

Accented characters in mySQL table

I have some texts in French (containing accented characters such as "é"), stored in a MySQL table whose collation is utf8_unicode_ci (both the table and the columns), that I want to output on an HT...

stackoverflow.com

frizzel · May 7, 2021

ekey64 said:
I would look into the UTF8 encoding. Sometimes French characters will cause the error if the original db was from a different encoding.

You're confusing output with a database backup sql file. There are no French characters in the first lines of an sql file. They are probably in the posts and postmeta tables, but that's way down in the sql sequence. And even then, indeed in some cases those characters can cause trouble, but in output only. That's not the problem at stake here.

Nuncaparo · May 7, 2021

frizzel said:
If you check the sql file in Notepad (or even better Notepad++), is it only gibberish text that you see, or are parts readable? Things like: CREATE TABLE `wp_posts` or similar.
If there are readable contents, maybe part of the database can be restored.

I try to open it with notepad, notepad++, calc on UTF8, excell and everyone of them show me the same things :

e1„Q-ßHÐ

Í²‘;ÁA‰³>¸çY¬A©8Ðošzwóç$Ë"Äw

½!JGŒ(Û±k’%ù$c6t}ç®²K%Ï.À/Üƒ‚ØzáE®Å3Ü¶\‡ñ9Ì-1é;6ŠÙÚ$#>]WÈ‡eL#èF˜²ë/^óê‘³¾ß´ì„|X

&ÍKê‡Xø+v¯½\à´šƒ.&ýÃ£h3{óFªDU¸ÊÞ}SWK)îª£·„‹…z°P^£ô„ò

2ÚWó³Â*JýåsVµù®6*¥©”ŽÉ‹{

½&õG‘ŒTÿ+Ì+Î9k¡„©y>Oš®ý7·Û‚á!D¡gœÒ*nâ

Unreadable xD

nevenx · May 7, 2021

Maybe one of these tools can help...

viskytech.com - viskytech Resources and Information.

viskytech.com is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, viskytech.com has it all. We hope you find what you are searching for!

www.viskytech.com

Ankesh16 · May 7, 2021

@frizzel Yes you are right. But I forget that.

frizzel · May 7, 2021

I'm afraid it's lost, although I find it strange that the file is completely unreadable with gibberish text only.

Just one last attempt: I suppose the SQL file is from the WinRAR backup file. Which version of WinRAR are you using?

And what exactly is the file "Latino-Move.wordpress.2016-01-06"?

GrizzlyBear · May 7, 2021

Nuncaparo said:
I try to open it with notepad, notepad++, calc on UTF8, excell and everyone of them show me the same things :

e1„Q-ßHÐ
Í²‘;ÁA‰³>¸çY¬A©8Ðošzwóç$Ë"Äw
½!JGŒ(Û±k’%ù$c6t}ç®²K%Ï.À/Üƒ‚ØzáE®Å3Ü¶\‡ñ9Ì-1é;6ŠÙÚ$#>]WÈ‡eL#èF˜²ë/^óê‘³¾ß´ì„|X
&ÍKê‡Xø+v¯½\à´šƒ.&ýÃ£h3{óFªDU¸ÊÞ}SWK)îª£·„‹…z°P^£ô„ò
2ÚWó³Â*JýåsVµù®6*¥©”ŽÉ‹{
½&õG‘ŒTÿ+Ì+Î9k¡„©y>Oš®ý7·Û‚á!D¡gœÒ*nâ

Unreadable xD

Really stupid question but just remembered, have you tried renaming to .zip ? some programs output in sql file in zip and not sql directly

vijay1 · May 7, 2021

@GrizzlyBear i was about to post that and got a notification to load an unread comment

Nuncaparo · May 8, 2021

frizzel said:
I'm afraid it's lost, although I find it strange that the file is completely unreadable with gibberish text only.

Just one last attempt: I suppose the SQL file is from the WinRAR backup file. Which version of WinRAR are you using?

And what exactly is the file "Latino-Move.wordpress.2016-01-06"?

The SQL File was not from winrar backup file, I tried already to zip it and import but the result was the same. Im using an old old old version of winrar ^^ 3.80

I don't know what is "Latino-Move.wordpress.2016-01-06", probably the back up puglin did it but I already tried to check if I could import my back up directly and I read in the tutorial I have to import manually the db... im gonna read again the documentation of this plugin, there is maybe a last chance

Nuncaparo · May 8, 2021

GrizzlyBear said:
Really stupid question but just remembered, have you tried renaming to .zip ? some programs output in sql file in zip and not sql directly

Yup sir, I did it already and the problem was the same after import : error 1064

Corrupted Database error #1064 :(

Welcome to Original Babiato! All Resource are Free and No downloading Limit.. Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here!Support Our Work By Donating Click here!

Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here!

Support Our Work By Donating Click here!

New member

I am totally in trouble, I have to restart a wordpress site for which I have a backup of the database and the site's (ftp) folder. My problem is that the database seems corrupted. No matter how hard I try to import it, I still get the same error message:​

​

Erreur​

Active member

Well-known member

New member

Well-known member

New member

Well-known member

Member

Member

Well-known member

Member

Well-known member

New member

Well-known member

Member

Well-known member

Active member

Well-known member

Attachments

New member

New member

Similar threads

Forum statistics

Share this page

Welcome to Original Babiato! All Resource are Free and No downloading Limit..
Join Our Official Telegram Channel For updates
Bypass All the resource restrictions/Password/Key? Read here!
Read Before submitting Resource Read here!
Support Our Work By Donating Click here!

Join Our Official Telegram Channel For updates
Bypass All the resource restrictions/Password/Key? Read here!
Read Before submitting Resource Read here!

I am totally in trouble, I have to restart a wordpress site for which I have a backup of the database and the site's (ftp) folder. My problem is that the database seems corrupted. No matter how hard I try to import it, I still get the same error message:

Erreur