Title: Error when restoring database with phpmyadmin
Last modified: September 1, 2016

---

# Error when restoring database with phpmyadmin

 *  [a10coker](https://wordpress.org/support/users/a10coker/)
 * (@a10coker)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/error-when-restoring-database-with-phpmyadmin-1/)
 * 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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [recovery](https://wordpress.org/support/topic-tag/recovery/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [a10coker](https://wordpress.org/support/users/a10coker/)
 * Last activity: [9 years, 9 months ago](https://wordpress.org/support/topic/error-when-restoring-database-with-phpmyadmin-1/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics