• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

SQL syntax error

#1
Hello,

I am moving my site to another host but when backup and restore by Sympex Dumper I have this error:
Import table `xf_mail_queue`MySQL Error: 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
Please anyone instruct me to solve this. Now my site down.
Thanks,
 

Brogan

XenForo moderator
Staff member
#4
This is what I use via SSH (using PuTTY).

Code:
mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

Then to zip it.

Code:
tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql
 
#6
This is what I use via SSH (using PuTTY).

Code:
mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

Then to zip it.

Code:
tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql
Thanks Brogan but I am on shared hosting so there is no SSH.
 
#8
Thanks for your help,
I found the way by exporting database through phpAdmin and still import by Sympex dump. Database was restored successfully.