I made a backup .sql file of my wordpress database. When I use phpmyadmin to try and import the database file, I get the error message below.
Error
SQL query:
--
-- Database: wordpress
--
-- --------------------------------------------------------
--
-- Table structure for table wp_commentmeta
--
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_ci DEFAULT NULL ,meta_value LONGTEXT COLLATE utf8mb4_unicode_ci
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
The settings used for the phpmyadmin import:
character set of the file: utf-8
Allow the interruption of an import in case the script detects it is close to the PHP timeout limit.: yes
Number of rows to skip, starting from the first row: 0
Format: SQL
SQL compatibility mode: none
Do not use AUTO_INCREMENT for zero values: yes
برچسب:
نویسنده: استخدام کار