IDEs Support (IntelliJ Platform) | JetBrains

Samuel

活动总数 6
最后的活动 2023年07月24日 15:26
成员加入日期 2023年07月13日 16:36
关注 0 名用户
关注者数 0 名用户
投票数 0
订阅数 1

已编辑于 2023年07月24日 15:26

I think I've just solved it. The export option 'MySQL create table options' wasn't selected and that seems to control the AUTO_INCREMENT insertion. Hopefully this will be helpful to anyone else ha...
- 1 票
已编辑于 2023年07月24日 15:22

Hi Aleksandr, I'm not an expert with SQL so forgive me if I'm wrong on any of this. That bug report says that "mysqldump now includes AUTO_INCREMENT=xxx in the table definition, even when you speci...
- 0 票
创建于 2023年07月17日 12:14

Hi Aleksandr, I'm right-clicking the database in the Explorer window, then to Import/Export and then the 2 options at the bottom - export and restore, using the paths I mentioned in my first post.
- 0 票
已编辑于 2023年07月13日 22:12

Turns out the primary key is not set to auto-increment on the imported database, but it is on the server. If this is the same issue as https://youtrack.jetbrains.com/issue/DBE-16803/Lose-comment-an...
- 0 票