Menu
▾
▴
#1016 (ok 3.1.1) copy: check "Add AUTO_INCREMENT value" by default
database->operations->copy:
i think "Add AUTO_INCREMENT value" should be checked by default (as "Structure and data" already is). Otherwise one gets into trouble when trying to insert a new rows into the copied db (the least is a "Warning (1366): Incorrect integer value..." if that value already exists)
Logged In: YES
user_id=1383652
Originator: YES
... in copy table as well of course.
Logged In: YES
user_id=326580
Originator: NO
next auto_increment value is determined at runtime if not set - it is only required to set if it is different from MAX(PK)+1,
what type of engine did you tried?
what mysql version?
there should not come such an error, IMHO
Logged In: YES
user_id=1383652
Originator: YES
As usual i used pma.cihar.com ;)
If one wants to copy a db he usually wants a as exact copy as possible.
In "move" it is checked by default for the same reason.
If you copy the strucure only it's better unchecked.
Logged In: YES
user_id=192186
Originator: NO
I also thing that copy should default to exact copy.
Implemented in SVN (no idea why I forgot about this issue).