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’