SQL syntax error

[sweetpotato]

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,

 

[Paul B]

Several people have reported issues with using Sympex Dumper.

Try using mysqldump instead.

 

[sweetpotato]

Could you have quick instruction how to use mysqldump please. This is the first time I 've heard it's name.

 

[Paul B]

This is what I use via SSH (using PuTTY).

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.

tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql

 

[rdn]

Several people have reported issues with using Sympex Dumper.

Yeah exactly, including me
When I started using MariaDB 10.

 

[sweetpotato]

This is what I use via SSH (using PuTTY).

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.

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.

 

[Paul B]

Have you asked your host if they will take the backup for you?

 

[sweetpotato]

Thanks for your help,
I found the way by exporting database through phpAdmin and still import by Sympex dump. Database was restored successfully.