Error in syntax when restore is attempted

  • Resolved eRoxanne

    (@eroxanne)


    11 years, 5 months ago

    My ISP had a server crash and was unable to provide me any backups. To avoid losing a month of hard work, I’m trying to use my WordPress backup created 5 days ago but when I use PhpMyAdmin (total newbie) and upload my BackupScheduler.zipback file, I get this error message:

    SQL query:

PKPKbackup_20130605/PKbackup_20130605/uploads/PKbackup_20130605/uploads/2012/PKbackup_20130605/uploads/2013/PK backup_20130605/uploads/2013/02/PK backup_20130605/uploads/2012/07/PK backup_20130605/uploads/2013/03/PK backup_20130605/uploads/2013/04/PK#backup_20130605/uploads/sl-uploads/PK*backup_20130605/uploads/sl-uploads/images/PK*backup_20130605/uploads/sl-uploads/addons/PK*backup_20130605/uploads/sl-uploads/themes/PK-backup_20130605/uploads/sl-uploads/languages/PK?NB??	'!backup_20130605/wp-config.php?W[W?J}?\???/?\2:?? w2??dB???鎈??~?;A??<|?21??jWuUq|????????vQ??hh0?L???8? N??!???>f,#NG??q0? &[...]

MySQL said: 

#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 'PKPK' at line 1

    No clue what this means but desperate – does anyone know what means and how to fix it?

    https://www.ads-software.com/extend/plugins/backup-scheduler/

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author Sed Lex

    (@sedlex)

    Could you send me the SQL files ?
    You will find my email in the header of the plugin file

    Thread Starter eRoxanne

    (@eroxanne)

    I’m very sorry, I am not able to find your email address… is it somewhere on your website? I see a contact form, no email address.

    Thread Starter eRoxanne

    (@eroxanne)

    Here is a link:

    https://dl.dropboxusercontent.com/u/27237537/BackupScheduler_20130605052911_gfw63qtrfx%20%281%29.zip

    Thank you!

    Plugin Author Sed Lex

    (@sedlex)

    First I recommend you to delete this post as the zip contain confidential information such as your password.

    Second, I import the sql file without any issue. How have you import the file ? Did you use the function import of phpmyadmin ?

    Thread Starter eRoxanne

    (@eroxanne)

    yes, I used the import function. Here is a screenshot of my settings – do you see any issues? Need a workaround asap!

    https://dl.dropboxusercontent.com/u/27237537/settings.docx

    Thread Starter eRoxanne

    (@eroxanne)

    I removed the file from my dropbox and also changed my cpanel password – thx for reminder

    Plugin Author Sed Lex

    (@sedlex)

    Actually I use No compatibility mode, and I have not zip the file but I do not know if it change something …

    Plugin Author Sed Lex

    (@sedlex)

    You actually have PKPK ? I cannot find it in your file …

    Plugin Author Sed Lex

    (@sedlex)

    It is funny because in your sent file I cannot find backup_20130605 … very very strange … how can you have a bug if this words does not appears ?

    Thread Starter eRoxanne

    (@eroxanne)

    Would you mind trying it for me? Hate to ask but am truly desperate. I can email you the cpanel login – appreciate any assistance. Where can I find your email address? Mine is [email protected]

    Thanks so much.

    Plugin Author Sed Lex

    (@sedlex)

    email sent … have you received it ?

    Plugin Author Sed Lex

    (@sedlex)

    For other people, the import process of SQL in phpmyadmin does not take as input the received zip file but the sql files inside the zip file.
    If you upload this zip file, phpmyadmin won’t understand anything …

    Thread Starter eRoxanne

    (@eroxanne)

    Late yesterday I was reading this https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup and suddenly realized I needed to open the existing WordPress database and then import the unzipped backup file, overriding the old. As soon as I did that, it worked!

    Thanks very much for all your efforts – the plugin worked beautifully!

    Plugin Author Sed Lex

    (@sedlex)

    I am glad that everything work … the problem with this plugin is that people realize that there is some issue or that they forgot to save something when the problem occurs and when a restoration is needed ??

    Glad that my plugin is useful

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Error in syntax when restore is attempted’ is closed to new replies.