From: Claudio Nanni Date: December 1 2011 10:24pm Subject: Re: best way to copy a innodb table List-Archive: http://lists.mysql.com/mysql/226416 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=485b397dcd29dae58404b30f4fa0 --485b397dcd29dae58404b30f4fa0 Content-Type: text/plain; charset=ISO-8859-1 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 > 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 --485b397dcd29dae58404b30f4fa0--