Cloning live table on a production

Asked Aug 01 '16 at 17:05

Active Aug 01 '16 at 17:05

Viewed 52 times

I have an online store with table 'Orders' and I want to clone/copy this table with every record to a new one - but the problem is that each moment table 'Orders' is being updated by customers... so simplest solution 'INSERT (...) SELECT (...)' wont work (cause during this time, new records will be added)

Has anyone ever tried it ? Does anyone have any idea how to achieve it ?

asked Aug 01 '16 at 17:05

user6664335

What do you mean by "won't work"? Do you get an error? – wallyk Aug 01 '16 at 17:07
How big is the DB? How often does this DB get insertions to the table? Have you taken a look at [this question](http://stackoverflow.com/a/3280042/1305745)? – cavpollo Aug 01 '16 at 17:16
@wallyk : - nope. Read carefully - "during this time, new records will be added" – user6664335 Aug 01 '16 at 17:39
@ cavpollo : really huge, so avery second multiple record are added - thats why my problem exists – user6664335 Aug 01 '16 at 17:40
seems like a duplicate of this question: http://stackoverflow.com/questions/917640/any-way-to-select-without-causing-locking-in-mysql – David Cram Aug 01 '16 at 18:06
@ David Cram: show me where cause what u have posted is completely out of my question – user6664335 Aug 01 '16 at 19:50

Cloning live table on a production

0 Answers0