Title: database restore failed&#8230; help
Last modified: August 19, 2016

---

# database restore failed… help

 *  [sholt](https://wordpress.org/support/users/sholt/)
 * (@sholt)
 * [15 years, 1 month ago](https://wordpress.org/support/topic/database-restore-failed-help/)
 * I have a WordPress backup file with a .gz that was creatd with the wp-db-backup
   plugin. I am trying to restore it with PhpMyAdmin. I have followed the instructions
   that I find here ([http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup))
   and I am getting this error…. help:
 * Error
    There is a chance that you may have found a bug in the SQL parser. Please
   examine your query closely, and check that the quotes are correct and not mis-
   matched. Other possible failure causes may be that you are uploading a file with
   binary outside of a quoted text area. You can also try your query on the MySQL
   command line interface. The MySQL server error output below, if there is any,
   may also help you in diagnosing the problem. If you still have problems or if
   the parser fails where the command line interface succeeds, please reduce your
   SQL query input to the single query that causes problems, and submit a bug report
   with the data chunk in the CUT section below: —-BEGIN CUT—- eNpzDQryD7JScDZUcDZS8HH1s1IwVDBSMLI0NOIKDgFKyHNxBYcBRVU8U6wUigtzChKLilOL9HIy
   k/QKMgoUDA1NDY0VjAwMLHSByMhCwdDMytDcytQ4SiEnNddSQYXLtzI40MdKwUTPUM/QhCs0OEjB 
   P1hHwdHd1S9ERyHMFWhFeGaeQrCjm2OQp4KpnoGeqbEJV4Cvo5WCkZ6hoZ6lnhlXgEcASKWOfzDI 
   HGOgsIJbUWqqU7ALl4+jn7uVQmqebmlJmq4FF9gqLvluDgYwYH7z93XRbY9rGh3/3i/3WL3rdFm+ 
   0JHW8J1vtSKn5Zb+vDYtZt2r8/dXOKoVluaXWHsuYmHSiXHZuO+u8F8+Y/tzfRbCG/+fqewUVldL 
   zC2wTpJbGp8Q93DNViNhBs8JEC2ap6adKgjdqaIwcfpU7fB1v3+11fI4PY89sbhj77x5f96KFr+5 
   8e6WYHrs7vJ5Pf8/nJXfl6i/47yz9agLR1046sJRF466cNSFoy4cdeGoC0ddOOrCUReOunDUhaMu 
   HHXhyHQhAAs3w3I= —-END CUT—- —-BEGIN RAW—- ERROR: C1 C2 LEN: 1 2 2912 STR:
 * SVN: $Id: sqlparser.lib.php 11513 2008-08-28 16:17:53Z lem9 $
    MySQL: 4.1.14 
   USR OS, AGENT, VER: Win SAFARI 5.0.534 PMA: 2.11.9.6 PHP VER,OS: 4.3.11 FreeBSD
   LANG: en-utf-8 SQL: ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b
   �_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW
   ��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s���
   �g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`
   ^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*
   Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]
   �w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ
   2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y
   �mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�
   w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I
   �”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu
   �֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w��
   ����a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)
   ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\
   ���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w�����
   �a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�
   pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\�
   ��ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������
   a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU
   �$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���
   ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/
   ��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�
   $ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”
   I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C;
   ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���
   +W���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\
   D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ��
   ��r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W
   ���}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D
   ����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ���
   �r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W�
   ��}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D�
   ���3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����
   r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W��
   �}B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D��
   ��3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r
   �H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}
   B�]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����
   3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; ����r�H
   �(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B
   �]ȣ������s����g]�w������a/��C; ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?
   Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���+W���}B�]ȣ������s����g]�w������a/��C; —-END RAW—-
 * SQL query:
 * ����r�H�(���H���voąW��*Y�mu�֖\���ߨA”I�,\D����3?Ύ8���y�’&b�_`^ᬵ2I�”)ʖ�pU�$ ���
   +W���}B�]ȣ������s����g]�w������a/��C;
 * MySQL said:
 * #1064 – 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 ‘‹’ at line 1

The topic ‘database restore failed… help’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [sholt](https://wordpress.org/support/users/sholt/)
 * Last activity: [15 years, 1 month ago](https://wordpress.org/support/topic/database-restore-failed-help/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
