Error on database rename
| User, date | Message |
|---|---|
|
Written by sergtop
3 years ago Category: General 50 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
3 years ago 3966 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
3 years ago 50 posts since Mon, 23 Nov 09 |
rev2820 |
|
Written by ansgar
3 years ago 3966 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
3 years ago 3966 posts since Fri, 07 Apr 06 |
Eh, sorry, it should have been RENAME TABLE `xyz` `newdb`.`xyz`; |
|
Written by sergtop
3 years ago 50 posts since Mon, 23 Nov 09 |
there was exactly RENAME TABL; in the bottom window |
|
Written by ansgar
3 years ago 3966 posts since Fri, 07 Apr 06 |
Fixed in r2858 |
|
Please login to leave a reply, or register at first. |