Copying MySQL table data to another table

I want to copy the data from one MySQL table to another table. The source table contains 30 mill开发者_JS百科ion records. the SQL connection gets lost when I tried to copy the data using the SQL query

INSERT table2 SELECT * FROM table1

Is there any external tool avaliable to do this job from the shell

Thanks

Sree

---

The mysql command line tool should be able to handle this just fine.