I’ve built my site locally and am now ready to upload it to a live server to replace the existing HTML site. When importing the .sql.gz file containing the database, I am repeatedly encountering the following error!…
—-
“Dumping data for table wp_options
#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 34″
—-
I have tried deactivating all plugins except Visual Composer. Same error. Found a blurb on Hostgator’s site about this particular error. They say that when this error is received, it means…
“The file does not contain backup data for a database, or the file has been changed or corrupted.”
I haven’t changed any of the backend files and am unfamiliar with MySQL in general, so am very confused about what to do to fix this. Please help!!
Hi
Please make sure that you properly generated the sql file, please check this link for more details in this regard: https://wpengine.com/support/exporting-database/
This is not a theme related error and unfortunately I can’t point exactly to the problem. You can try to make some tests on another local install on your computer. Try to setup a new wp-install and import the sql there. If the process fails again then your sql is not properly generated.
Thanks!
Thank you! That video provided my answer…just a simple tweak to the export settings and it all worked fine. Much appreciated!
Hi
Glad I could hep.
Thanks for letting me know and for your message!
