Error on database rename

[expired user #4516]'s profile image [expired user #4516] posted 14 years ago in General Permalink
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
ansgar's profile image ansgar posted 14 years ago Permalink
Which revision of heidisql.exe did you use? I cannot reproduce that using the latest build.
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
rev2820
ansgar's profile image ansgar posted 14 years ago Permalink
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;
ansgar's profile image ansgar posted 14 years ago Permalink
Eh, sorry, it should have been
RENAME TABLE `xyz` `newdb`.`xyz`;
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
there was exactly
RENAME TABL;
in the bottom window
ansgar's profile image ansgar posted 14 years ago Permalink
Fixed in r2858

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