IDEs Support (IntelliJ Platform) | JetBrains

Samuel

Total activity 6
Last activity July 24, 2023 15:26
Member since July 13, 2023 16:36
Following 0 users
Followed by 0 users
Votes 0
Subscriptions 1

Edited July 24, 2023 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 vote
Edited July 24, 2023 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 votes
Created July 17, 2023 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 votes
Edited July 13, 2023 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 votes