You could export the database as text. Then copy the text and when importing into the other database you can just paste the text into the SQL tabs field there and it will populate. Not sure about your error, possible corrupt file.
Just to be sure the file you are trying to import with is a .sql file right?
Yes, it is .sql file.
That was actually in “acronis backup”.
I have site and database backup in there.
Unfortunately, that is only database backup I have now. 🙁
If you have access to the phpMyAdmin then go the database
– Click export
– Make sure SQL is checked and Save File as is unckecked as well. This should give you text instead of the a file to download. Copy it.
– Go to the new database and click the SQL Tab. There you can paste the Text from the export. Then click Go. That is the same as the file but in text format and sometimes a lot quicker
Well, it would work, I tried.
But the error remains from before, because I use the database with error to get text to copy to the new database.
I tried to copy the sql (which was zipped) text from WordPad, but that’s giving me the same error.
Mysql said it is mistake somewhere in quotes, wrong cut, or something similar.
But it is interesting to me, why it came to this.
I still think that the windows is guilty. Windows changed the file due to compression.
Then try not zipping it up~
….. and, it destroyed special characters, even its in utf-8, special characters on site are showed as: ć and similar.
Yea, absolutely windows done this.
Cant do that, that is problem, I have only that zipped database backup.
If i had other, I wuold not care about this one.
have you tried exporting as a compressed zip already?
Zipped folder = sql database and zipped site.
Cant do that either.
Nothing, xampp, and work again from beggining.
🙂
Thanks for your help.
If I do this procces: “Go to the new database and click the SQL Tab. There you can paste the Text from the export. Then click Go.”
But how come error is fixed like this, is something missing from this new database now so no error or what?
Very, very confusing.
This is same error like I am having: Error restoring backup
