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.
-- -- 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`)
#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?