Home>

i can no longer import with phpmyadmin

If i try to export the test environment DB and import the same on a website that has a test environment and a production environment, an internal server error will be displayed.

I tried importing with Bigdump, but I get the following error.

Error at the line 36:) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci;
Query:-
-
-
-
CREATE TABLE `wp_commentmeta` (
`meta_id` bigint (20) UNSIGNED NOT NULL,
`comment_id` bigint (20) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` varchar (255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci
MySQL: Table 'wp_commentmeta' already exists

A similar error occurs when you back up.
So far, I was able to import with Bigdump without any problems, and I couldn't find a similar phenomenon even after examining the Internet.

phpmyadmin
  • Answer # 1

    It was caused by trying to import what was exported with http to https.
    It was confused because of the common screen, but even the same DB was not compatible with http and https ...
    What we didn't intend to do redirect settings overlapped with the cookie problem.

    I'm sorry for rudimentary.

  • Answer # 2

      

    MySQL: Table 'wp_commentmeta' already exists

    I'm told you can't import because a table with the same name already exists.
    Since translation sites are also in use, be sure to read simple error messages.

Related articles