Change table's database
| User, date | Message |
|---|---|
|
Written by AntonioCS
5 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
5 years ago 3950 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
5 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. |