Errors importing wp_options table: #1062 - Duplicate entry 'XXXXXXXX' for key 'PRIMARY'


#1

So i tried like a hundred of times, and i keep getting this error when trying to import the wp_options table in phpmyadmin for my WP multisite. I am importing a database that was created on EE v3 and trying to import on a EE v4 setup.

SQL query:

--
-- Indexes for dumped tables
--

--
-- Indexes for table `wp_options`
--
ALTER TABLE `wp_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`)

MySQL said:

#1062 - Duplicate entry '13770809' for key 'PRIMARY'

I would ignore this but this makes it impossible to add new posts in my WP admin. How do i fix this, how do i force the table to import?


Weird error! Cannot add new posts while i can edit old posts? (After move from v3 to v4)
#2

I am not sure if this is the issue, but option_id in my wp_options tables start from number 3 and not number 1.

Screenshot_22