Need Help Restoring Database

[3dColor]

I am trying to restore a MySQL 5 backup using HeidiSQL. I have tried running it both ways but it starts out very fast and then slows down to about 1 line per second which could take it severals days to complete.

The way it reads in the editor:

DROP TABLE IF EXISTS `wp_comments`;

#
# Table structure of table `wp_comments`
#

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,
  `comment_post_ID` int(11) 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` enum('0','1','spam') NOT NULL default '1',
  `comment_agent` varchar(255) NOT NULL default '',
  `comment_type` varchar(20) NOT NULL default '',
  `comment_parent` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  `comment_enclosure` text,
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=36511 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC ;

#
# Data contents of table `wp_comments`
#
 
INSERT INTO

I need to speed up the process, anyone have any ideas?

 

[DonQuichote]

Do it in a transaction? That might help, as the table does not have to be locked for each INSERT.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)