A better REPAIR TABLE for myisam tables (or for upgrading tables)

2010-12-17 Thread Hank
I've posted a similar post in the past -- but there I was mucking around with blank index files and frm files to fool myisamchk into repairing a table. But now I think I've come across a much better and more efficient way to do a REPAIR Table in order to upgrade my database tables from Mysql

Re: A better REPAIR TABLE for myisam tables (or for upgrading tables)

2010-12-17 Thread Hank
Sorry... One small correction to my above post.. 'FLUSH TABLES' should be issued between steps 8 and 9. My 200+ million record table completed in 71 minutes. -Hank mysql; query;