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

Samuel commented, July 24, 2023 15:22
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
Samuel commented, July 24, 2023 15:02
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
Samuel commented, 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
Samuel commented, July 13, 2023 22:02
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
Samuel created a post, July 13, 2023 16:36
Completed

Duplicate entry '0' for key 'PRIMARY' after import

Hello, I'm a web developer so exporting remote databases and importing them locally is quite a common task for me. After importing, I am getting the following error when trying to create a new post...
1. Community
2. DataGrip
- 2 followers
- 6 comments
- 0 votes