a10coker on "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 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

WordPress ...
ما را در سایت WordPress دنبال می کنید

برچسب : نویسنده : استخدام کار wpss بازدید : 307 تاريخ : پنجشنبه 14 مرداد 1395 ساعت: 10:37