Restore

I get error while restoring by SSH

Enter password:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
Ô[ù¬ù¦cfP
ùõwn^Ýæ«2¿}s»<`zöIcîGfOéÎ6_ÅYüw¨gc(� �ñöõÏ?½¸3{²]0z¤' at line 1

[Kirk Y]

How was the dump you're restoring generated?

[Shazz]

If you back up from SSH and restore SSH you should have no problems.

[Symbian Galaxy]

I took that dump by mysqldumper

[Snake]

That's the worst mySQL tool I've ever seen so far. I highly recommend you to use BigDump. Much better, easier and faster.

http://www.ozerov.de/bigdump.php

[encryption]

Originally Posted by Symbian Galaxy

I get error while restoring by SSH

Enter password:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
?[????cfP
??wn^???2?}s?<`z?Ic?GfO??6_?Y?w?gc(????????3{?]0z?' at line 1

I could be wrong but it appears that the error was generated restoring the attachments table ? Try copying and pasting just that table via phpmyadmin.

Originally Posted by Snake

That's the worst mySQL tool I've ever seen so far.

what makes you say that, I've used it endlessly on client transfers and have had more success rates on the whole. Even done restorations across different mysql versions and never noticed any screwups till date.