Title: database restoration problems
Last modified: August 18, 2016

---

# database restoration problems

 *  [xtheunderdog](https://wordpress.org/support/users/xtheunderdog/)
 * (@xtheunderdog)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/database-restoration-problems/)
 * so, i’ve followed all the directions perfectly for moving wp databases from one
   server to another. twice. the third time it’s not working. the other two worked
   perfectly, but this one refuses to. i’ve tried editing and reuploading the sql
   file about five times.
 * i keep getting this:
    “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—- eNqdkM2O2yAUhfc8xV3M0iZA4jTDzk3cTCTnp8addjchMdNY8g8FMp482yzmkfoKhahRqy6LBELn
   Hs7HvVlRbAsOcwpzBnm24UCBwXg2RqL0+htC80fB4W5VcbA/Gi2NVQY39QHrk45egGH2ARghkxGl 
   I5IAIXxCeZJAo9p7yF413KH1RXzOOUwwwYzF1smukqZCX0QBWxFBusw2ZQSPmed9rTtYZTDFBO3W 
   KffxU0xj3TC0e9gFS7QVIWmMKYG87s6vKE83Sw6qi2vbx7NZch9TdOX9fHuPY/DfXF/SqvXBXoXF 
   udXIyy/K2Lrv/gJ48eSc5qPRMAyhu/YiwzPcKReKYT/01nFo+qNsTv4apKXqlJEuZJV1qzik2gCb 
   RGEoCUgHhHIyhXQdzEIZD77BbyMJlWt7f+TQ3w26kE4epPXRe9c8Pw29qbRR1rL91RGO+D8XujFK 
   eWgUWGfOR3c2Cp57A+6q7Qf9dJROfe9Nrexv5KLY7qBMP+YZrD5B9m0lSvGv8xeEG6VW —-END CUT—-—-
   BEGIN RAW—-
 * ERROR: C1 C2 LEN: 1 2 383
    STR: »
 * CVS: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
    MySQL: 4.0.22-
   standard USR OS, AGENT, VER: Win IE 6.0 PMA: 2.6.1-pl2 PHP VER,OS: 4.3.10 Linux
   LANG: en-iso-8859-1 SQL: – phpMyAdmin SQL Dump — version 2.6.1-pl2 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   Host: localhost — Generation Time: Apr 24, 2005 at 01:06 AM — Server version:
   4.0.22 — PHP Version: 4.3.10 — — Database: `tlf_wordpress2` —
 * — ——————————————————–
 * —
    — Table structure for table `wp_categories` —
 * DROP TABLE IF EXISTS `wp_categories`
    —-END RAW—- SQL-query:
 * – phpMyAdmin SQL Dump — version 2.6.1-pl2 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   Host: localhost — Generation Time: Apr 24, 2005 at 01:06 AM — Server version:
   4.0.22 — PHP Version: 4.3.10 — — Database: `tlf_wordpress2` — — ——————————————————–——
   Table structure for table `wp_categories` — DROP TABLE IF EXISTS `wp_categories`
   
   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 ‘– phpMyAdmin
   SQL Dump
    — version 2.6.1-pl2 — [http://www.ph](http://www.ph) “
 * help?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/database-restoration-problems/#post-192649)
 * I’ll probably be able to fix it, but trying to describe what I do is really hard
   because what I do depends on various things.
    If you want to email me the .sql
   file or upload it to your webspace and provide me with a download link I’ll sort
   it out and let you know what the solution is ?
 * Your data is safe and I’ll delete it once you have it all happily back with you.
 * tamba2 at gmail dot com
 *  Thread Starter [xtheunderdog](https://wordpress.org/support/users/xtheunderdog/)
 * (@xtheunderdog)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/database-restoration-problems/#post-192655)
 * emailed it– thank you sooo much.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/database-restoration-problems/#post-192658)
 * Back at you 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘database restoration problems’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [recovery](https://wordpress.org/support/topic-tag/recovery/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Mark (podz)](https://wordpress.org/support/users/podz/)
 * Last activity: [21 years, 1 month ago](https://wordpress.org/support/topic/database-restoration-problems/#post-192658)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics