Title: SQL Error – Urgent
Last modified: August 20, 2016

---

# SQL Error – Urgent

 *  [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/)
 * I exported database from myphpadmin.
    I zipped database on pc. I unzipped database
   on pc. I imported database in myphpadmin.
 * I get this error:
 * “SQL:
    ,:Zone.Identifier:$DATA[ZoneTransfer] ZoneId=3
 * MySQL:
    #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 “
 * I dont have idea whats the meaning of this.
    Anyone can help?

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

 *  [Justin Greer](https://wordpress.org/support/users/justingreerbbi/)
 * (@justingreerbbi)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142196)
 * 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?
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142197)
 * 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. 🙁
 *  [Justin Greer](https://wordpress.org/support/users/justingreerbbi/)
 * (@justingreerbbi)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142203)
 * 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
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142213)
 * 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.
 *  [Justin Greer](https://wordpress.org/support/users/justingreerbbi/)
 * (@justingreerbbi)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142215)
 * Then try not zipping it up~
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142216)
 * ….. and, it destroyed special characters, even its in utf-8, special characters
   on site are showed as: ć and similar.
 * Yea, absolutely windows done this.
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142218)
 * Cant do that, that is problem, I have only that zipped database backup.
    If i
   had other, I wuold not care about this one.
 *  [Justin Greer](https://wordpress.org/support/users/justingreerbbi/)
 * (@justingreerbbi)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142221)
 * have you tried exporting as a compressed zip already?
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142223)
 * Zipped folder = sql database and zipped site.
    Cant do that either. Nothing, 
   xampp, and work again from beggining. 🙂 Thanks for your help.
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142282)
 * 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.
 *  Thread Starter [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * (@dolimoli)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142290)
 * This is same error like I am having: [Error restoring backup](http://wordpress.org/support/topic/error-restoring-backup-help?replies=2)

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

The topic ‘SQL Error – Urgent’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 11 replies
 * 2 participants
 * Last reply from: [dolimoli](https://wordpress.org/support/users/dolimoli/)
 * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/sql-error-urgent/#post-3142290)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics