database restore failed

  • due to a misconfiguration of the static homepage-tool of wp (“formerly” running version 2.6) and/or static frontpage-plugin my homepage was unavailable with the comment “you’re looking for s.th. that isn’t there”.

    since i suspected a database corruption i tried to restore from my previous (today before upgradeing to 2.6) backup.

    the procedure crashed/failed and my homepage has become unavailable so ist all the rest of my admin-backend.

    the my-php-admin tool of sitecontrol gives the following comment which i was asked to post here by the author of the restoring-from-backup-description…

    … the server’s comment relates in my humble opinion to a parallell-installation of a podcasting-blog named “loudblog” whose database-tables the restore-procedures tries to rewrite but is unable to find… or similar…

    this is the server’s comment:

    Fehler

    SQL-Befehl:

    #
    # Data contents of table lb_postings
    #
    INSERT INTO lb_postings
    VALUES ( 6, 1, ‘bitters’, ‘2008-05-29 16:19:00’, 1, ‘podcast-2008-05-29-68903.mp3’, 1, 116, 3145728, ‘pah! bitters! das geheime gewisse etwas im cocktail! lächerlich!’, ‘ <p>pah! bitters! das geheime gewisse etwas im cocktail! lächerlich!</p>\n\n\n ‘, 1, 0, 1, 0, 0, 0, ‘bitter bitters longdrink cocktail bar barman barmann bartender cocktail bar ‘, 3, 0, 0, 0, 0, , , , 0 ) ;

    MySQL meldet: Dokumentation
    #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 ‘ , , 0)’ at line 1

    end of comment

    since i’m promoting me and my profession via this blog/website this is a severe damage done to my daily business.

    who could help me out of that dilemma?

    are all my data gone now?

    your help is kindly appreciated!

    thanks,

    werner

Viewing 2 replies - 1 through 2 (of 2 total)

  • You can see from the error message that you have invalid syntax in the query. A comma cannot follow a comma. Depending on the field type replace the comma with “, null” or “, ”” or “, 0”. This could be problematic if there are a number of entries, perhaps try doing a string replace in a text editor to replace “0, 0, 0, 0, , , , 0” with “”. I would suspect the default values would be zeroes anyway.

    Also, the easiest way to backup WordPress is via regular Exports from the Manage menu. To re-import the posts after a reinstall just go to Manage and click import. No messing with phpMyAdmin.

    Thread Starter 751412

    thanx so far – problem is, i cannot access my admin backend – because the server doesn’t allow it anymore. reason: wp-database restore from backup failed.

    until wp 2.5 there was no reimport function as far as i know and you had to follow cryptical restore procedures you could read about in the wp support base.

    this is exactly what i did believing that this might be failsafe…

    my fault…

    now i can’t even access that php document where i should replace those commas by zeros. i’d like to clarify that i am not accustomed to coding… my knowledge about databases and php is not good enough…

    so your answer leaves me with the question how i could regain access to my wp-admin tool. once i’m in i guess i would find a way…

    any ideas? e.g. change the contents of a php-file? what file? where do i find it?

    your help is much appreciated!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database restore failed’ is closed to new replies.