CODEWITHSUNDEEP
mysqldatabase
p27
p27

Reputation: 2222

move table from one schema to another schema ?

I want to move table from one schema to another schema in mysql , can anybody tell me how can I do this .

Upvotes: 67

Views: 57887

Answers (3)

jaiveeru
jaiveeru

Reputation: 91

Moving fooTable from old_db_schema to new_db_schema will be a 2 step process:

Step 1:

CREATE SCHEMA new_db_schema --Assuming you do not have new schema
GO

Step 2:

ALTER SCHEMA new_db_schema
TRANSFER old_db_schema.fooTable 
GO

Upvotes: -2

Kruti Mehta
Kruti Mehta

Reputation: 61

Moving tables with space characters in between should be enclosed.

Example:

ALTER TABLE `schema1`.`tbl somename` 
RENAME TO  `schema2`.`tbl somename` ;

Upvotes: 6

Harry Joy
Harry Joy

Reputation: 59660

If both schema is on same server then Alter table can be used to move tables from one db to another. 

alter table old_db.fooTable rename new_db.fooTable

Upvotes: 115

Related Questions