Title: error 1064
Last modified: March 17, 2017

---

# error 1064

 *  Resolved [Buzz Cave](https://wordpress.org/support/users/buzz-cave/)
 * (@buzz-cave)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/error-1064/)
 * When trying to import my database I get this error. #1064 – You have an error
   in your SQL syntax; check the manual that corresponds to your MariaDB server 
   version for the right syntax to use near ‘@’, 1) LIMIT 1′ at line 1
    I’m not 
   sure what I need to do to resolve this problem. I no longer have access to the
   host I created my back up from. So I’m hoping it isn’t anything that occurred
   during the backup process. Thank you for your time

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

 *  Thread Starter [Buzz Cave](https://wordpress.org/support/users/buzz-cave/)
 * (@buzz-cave)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/error-1064/#post-8940238)
 * Is there no one that can help? I’m betting it’s gonna be a complete re build 
   of the site. Next time I will make sure I use a plugin that has support, and 
   works properly. Reading the endless forum ….this plugin has a great deal of problems.
   I don’t fault the developer. My fault for using it.
 *  Plugin Contributor [Katrina “Kat” Moody](https://wordpress.org/support/users/katmoody/)
 * (@katmoody)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/error-1064/#post-8944499)
 * Hi there –
 * I’m sorry I missed your post. I’ve had trouble receiving all new topics since
   the changes to the forums a little while back, though I do try to check a few
   times a week regardless.
 * A problem in the syntax is usually a difference between how a database backup
   is saved on one server and how it is read on another server. Usually it’s as 
   simple as a different option but it sometimes comes down to very old phpmyadmin
   installations being used on some hosts.
 * It looks like your previous backup had different header information included 
   with the file, information the new server doesn’t need/want. So it triggers this
   error. The error spells out what is wrong, though – so it would be a fairly easy
   thing to open the SQL file and look on line 1 for the `@` that is there that 
   it’s throwing a fit about. It sounds like there’s a double `@`maybe.
 * One easy solution would be to have your new host install the old database file
   for you via the command line, if they can. This seems to circumvent the issue
   much of the time in my own experiments with this problem.
 * Unfortunately some of the much older phpmyadmin installations or MySQL installations
   tend to export backups with some issues.
 * Again, I’m sorry I wasn’t able to respond quickly and for the trouble you’re 
   having. Best of luck to you moving forward.
 * Kat

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

The topic ‘error 1064’ is closed to new replies.

 * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225)
 * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/)
 * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Katrina “Kat” Moody](https://wordpress.org/support/users/katmoody/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/error-1064/#post-8944499)
 * Status: resolved