Error when restoring database with phpmyadmin
-
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 tablewp_commentmeta
—
CREATE TABLEwp_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
- The topic ‘Error when restoring database with phpmyadmin’ is closed to new replies.