Title: Database Restore Error
Last modified: August 19, 2016

---

# Database Restore Error

 *  [judgemental](https://wordpress.org/support/users/judgemental/)
 * (@judgemental)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/database-restore-error/)
 * I am getting this error when trying to restore from a database backup file & 
   am not sure at all how to proceed. I have backed up from a similar file to this&
   it was fine. I will lose about 3 years worth of posts that I will have to redo
   if I can’t figure this out, so any help is GREATLY appreciated. Thanks!!
 * Error
 * SQL query:
 * # # Table structure of table `wp_comments` # CREATE TABLE `wp_comments` ( `comment_ID`
   bigint(20) unsigned NOT NULL auto_increment, `comment_post_ID` bigint(20) unsigned
   NOT NULL default ‘0’, `comment_author` tinytext NOT NULL, `comment_author_email`
   varchar(100) NOT NULL default ”, `comment_author_url` varchar(200) NOT NULL default”,`
   comment_author_IP` varchar(100) NOT NULL default ”, `comment_date` datetime NOT
   NULL default ‘0000-00-00 00:00:00’, `comment_date_gmt` datetime NOT NULL default‘
   0000-00-00 00:00:00’, `comment_content` text NOT NULL, `comment_karma` int(11)
   NOT NULL default ‘0’, `comment_approved` varchar(20) NOT NULL default ‘1’, `comment_agent`
   varchar(255) NOT NULL default ”, `comment_type` varchar(20) NOT NULL default ”,`
   comment_parent` bigint(20) unsigned NOT NULL default ‘0’, `user_id` bigint(20)
   unsigned NOT NULL default ‘0’, PRIMARY KEY (`comment_ID`), KEY `comment_approved`(`
   comment_approved`(1)), KEY `comment_pos[…]
 * MySQL said: Documentation
    #1067 – Invalid default value for ‘comment_date’

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

 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/database-restore-error/#post-1520581)
 * Are you restoring via either of these methods?
 * [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup)
 *  Thread Starter [judgemental](https://wordpress.org/support/users/judgemental/)
 * (@judgemental)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/database-restore-error/#post-1520682)
 * yes. i’m using phpmyadmin.

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

The topic ‘Database Restore Error’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [judgemental](https://wordpress.org/support/users/judgemental/)
 * Last activity: [15 years, 11 months ago](https://wordpress.org/support/topic/database-restore-error/#post-1520682)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics