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?