• 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

  • The topic ‘Error when restoring database with phpmyadmin’ is closed to new replies.