Title: [Plugin: WordPress Backup to Dropbox] SQL Syntax Error
Last modified: August 20, 2016

---

# [Plugin: WordPress Backup to Dropbox] SQL Syntax Error

 *  Resolved [charkue](https://wordpress.org/support/users/charkue/)
 * (@charkue)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-wordpress-backup-to-dropbox-sql-syntax-error/)
 * Recently I transitioned to an installation of WordPress Multisite. I had been
   using WPB2D in order to daily backup all of my data, including my databases. 
   Earlier today something happened erasing all posts and comments across my site.
   I have yet to narrow down what caused this destruction.
 * When I went to restore my databases via the SQL backup I had I received this 
   error:
    “#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 ‘-db’
   at line 5”
 * The process only got as far in as to create my database. (Line 5).
 * I would like to know what is causing this ASAP so I can remedy the situation.
   Thanks.
 * [http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/](http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [charkue](https://wordpress.org/support/users/charkue/)
 * (@charkue)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-wordpress-backup-to-dropbox-sql-syntax-error/#post-3128211)
 * I may have just solved this issue. Turns out SQL doesn’t like database names 
   having hyphens in them. Note to self: always use underscores for MySQL databases.

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: WordPress Backup to Dropbox] SQL Syntax Error’ is closed to 
new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-backup-to-dropbox_ffffff.
   svg)
 * [WordPress Backup to Dropbox](https://wordpress.org/plugins/wordpress-backup-to-dropbox/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-backup-to-dropbox/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-backup-to-dropbox/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-backup-to-dropbox/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-backup-to-dropbox/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-backup-to-dropbox/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [charkue](https://wordpress.org/support/users/charkue/)
 * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-wordpress-backup-to-dropbox-sql-syntax-error/#post-3128211)
 * Status: resolved