distal-attribute
distal-attribute
distal-attribute
distal-attribute

Change table's database

User, date Message
Written by AntonioCS
6 years ago
Category: General
11 posts since Sun, 13 Apr 08
Is there no option to change a table via the gui to another database? I tried drag and drop but it just won't work :(
Written by ansgar
6 years ago
4801 posts since Fri, 07 Apr 06
You cannot move it, but copy it. Just rightclick the table in "Database" tab, and click "Create table copy" from the context menu.
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07
You can also move a table manually with the following SQL command:

ALTER TABLE `from_db`.`table1` RENAME TO `to_db`.`table1`;

A drag-n-drop solution would be harmful to more people than it would help: the underlying ALTER TABLE operations usually work by creating a new table and then dumping the old one, consuming significant resources. Accidental drag/drops are commonplace, and each one would result in tables being locked and massive server resources being used, plus the risk of the operation failing.
 

Please login to leave a reply, or register at first.