Title: database restore failed
Last modified: August 19, 2016

---

# database restore failed

 *  751412
 * [17 years, 8 months ago](https://wordpress.org/support/topic/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)

 *  [Ziyphr](https://wordpress.org/support/users/ziyphr/)
 * (@ziyphr)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/database-restore-failed/#post-811725)
 * 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
 * [17 years, 8 months ago](https://wordpress.org/support/topic/database-restore-failed/#post-811749)
 * 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.

## Tags

 * [database crash](https://wordpress.org/support/topic-tag/database-crash/)
 * [mysql errors](https://wordpress.org/support/topic-tag/mysql-errors/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: 751412
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/database-restore-failed/#post-811749)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics