Low priority copy?

[Brian Dunning]

I have a very busy 14,000,000 record table. I made a new version of  
the table, that's more efficient, and now I just need to copy over  
the data. Just about anything I try swamps the machine and locks up  
MySQL with "too many connections" because it's so damn busy. Can  
anyone suggest the most efficient way to copy over all the data to  
the new table with low priority so I don't kill the machine? It's OK  
if it takes up to around 10 minutes. Thanks...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]