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

Error on database rename

User, date Message
Written by sergtop
4 years ago
Category: General
55 posts since Mon, 23 Nov 09
When I rename an active DB (edit on DB name) sql like
RENAME TABL;
executed. that is not the correct one. Maybe it is easier to add a menu item - rename instead of edit as Edit copies DB entirely
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Which revision of heidisql.exe did you use? I cannot reproduce that using the latest build.
Written by sergtop
4 years ago
55 posts since Mon, 23 Nov 09
rev2820
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Ok, that's a newer build.

You say there that this gets executed:

RENAME TABL;


Is that really true or was that a typo? It should be

RENAME TABLE xyz;

Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Eh, sorry, it should have been

RENAME TABLE `xyz` `newdb`.`xyz`;

Written by sergtop
4 years ago
55 posts since Mon, 23 Nov 09
there was exactly
RENAME TABL;
in the bottom window
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Fixed in r2858
 

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