What is the fastest way to restore a mysqldumped table?

mailing.database.mysql - MySQL database issues discussed in this best MySQL group in USENET 

Subject Author Date What is the fastest way to restore a mysqldumped table? noreply 10-31-2005  Re: What is the fastest way to restore a mysqldump... noreply 11-02-2005

Posted by noreply on October 31, 2005, 8:12 pm Please log in for more thread options I have a backed up table and need to restore it. It is quite large (120 Million Rows) and I am using a file created by mysqldump to restore it (and it is taking forever). I am checking out the various tips on the mysql site about optimizing performance, but am only getting about 1k inserts per second which is way to slow. I am hoping I am missing something really simple that would speed things up, any suggestions are welcome! Thanks, Scott Posted by noreply on November 2, 2005, 4:28 am Please log in for more thread options Well I will add my own 2 cents worth. Our table has a very large and complex key associated with it. So I dropped that index and then ran the restore... got 12k records per second, quite an improvement. Took about 4 hours to do 120 million records. I am reindexing now and am guessing I'll be days ahead as long as the new index takes less than 12 hours. Just goes to show ya ... it's always somethin' :-) Similar Threads Posted Fastest Way to Create a Replica January 19, 2006, 12:47 am Restore db from 4.1.12 to 3.23 July 13, 2005, 11:21 am Restore Your Account August 11, 2005, 1:45 am slow restore March 7, 2006, 12:41 pm cannot restore 3.23.58 db to MySQL 4.0.22-debug November 29, 2005, 3:42 pm mysql backup and restore for 4.1.x April 16, 2006, 12:22 am mysqldump restore db syntax April 29, 2006, 4:38 pm Quality of Backup and Restore June 2, 2006, 3:38 am backup and restore of var lib mysq February 12, 2009, 2:12 pm Database Restore / MySQL 4.1 -- InnoDB May 1, 2006, 12:11 pm