Bug #23380 copy table

• Submitted: 17 Oct 2006 16:07
• Modified: 29 Mar 2011 18:43
• Reporter: Roberto Spadim (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: all
• OS: Any (all)
• CPU Architecture: Any
• Tags: feature

[17 Oct 2006 16:07] Roberto Spadim

Description:
how can i copy table?
with myisam i can copy files
with innodb no :(
i can make
create table new_table select * from another_table

but index are not copied

can i clone ??
something like

clone table new table like another_table??

How to repeat:
clone table new table like another_table??

[17 Oct 2006 16:17] Andrey Hristov

use
CREATE TABLE xyz_copy LIKE xyz;
INSERT INTO xyz_copy SELECT * FROM xyz;

[29 Mar 2011 18:43] Roberto Spadim

ok closed