Sure you can, and you should. but in case you also update/delete rows from the first table you have to set up trigger to log changes. if you are lucky (only inserts) then its easier.
Cheers Claudio 2011/12/1 Angela liu <yyll2...@yahoo.com> > Hi, folks: > > > I have a situation: > > A large innodb table t1 with 45 million rows, need to have a new table t2 > exactly the same as t1, to copy the data from t1 to t2, I have the > following query: > > create table t2 like t1; > > insert into t2 select * from t1; > > > but the above insert may run long time , that can interface with > performance, is there a way to chunk the insert into the new table? like > breaking it down into chunks of 100,000 rows ? > > > Thanks -- Claudio
