Cannot backup my .sql file in phpmyadmin (Syntax Error)

Hello

Are you trying to import an sql file from a BackUpWordPress backup?

Are you using the WPML plugin?

Yes, I am using BackUpWordpress plugin and trying to import sql file in phpmyadmin

and trying to import via phpmyadmin

What other plugins do you have installed?

Please I need help with this import error. Site has been down for too long.

Other plugins I had:

ContactForm7
GoogleAnalytics
BetterWPSecurity
CMSTreePageView
W3TotalCache
TinyMCEAdvanced
ML-SliderPro
Connections
GoogleTranslator

Could you possible email me the offending SQL file.

I’d imagine this is related to https://github.com/humanmade/hm-backup/pull/34 but we thought we had that fixed.

Sure, I will email to tom [at] hmn [dot] md

I appreciate your insight and help with this issue.

I was able to fix the database using regex, the issue is that timestamps weren’t properly encoded, this was fixed in https://github.com/humanmade/hm-backup/pull/34 so this backup must have been from an old version of the plugin.

I verified that creating a backup of that database with the latest version of the plugin created a valid sql file.

Tom,

It worked perfectly!
Thank you for help and support on this item.

I hope this serves as reference to anyone else that has the same issue.