Title: Phpmyadmin Problem
Last modified: August 31, 2016

---

# Phpmyadmin Problem

 *  [crater2131](https://wordpress.org/support/users/crater2131/)
 * (@crater2131)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/pleasee-i-need-help-php-admin-problem/)
 * **_[De-capitalized; please do not shout at us]_**
 * Please y tried to import a sql file in a new database and says the next error:
 * — Table structure for table `wp_commentmeta`
    — CREATE TABLE IF NOT EXISTS `wp_commentmeta`(`
   meta_id` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT , `comment_id` bigint(
   20 ) unsigned NOT NULL DEFAULT ‘0’, `meta_key` varchar( 255 ) DEFAULT NULL , `
   meta_value` longtext, PRIMARY KEY ( `meta_id` ) , KEY `comment_id` ( `comment_id`),
   KEY `meta_key` ( `meta_key` ( 191 ) ) ) TYPE = InnoDB AUTO_INCREMENT =1;
 * MySQL said: Documentation
    #1064 – You have an error in your SQL syntax; check
   the manual that corresponds to your MySQL server version for the right syntax
   to use near ‘TYPE=InnoDB AUTO_INCREMENT=1’ at line 19
 * WHAT SHOULD I DO TO FIX THIS?, THANK YOU

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Mark Ratledge](https://wordpress.org/support/users/songdogtech/)
 * (@songdogtech)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/pleasee-i-need-help-php-admin-problem/#post-7289062)
 * Change `TYPE=InnoDB` to `ENGINE=InnoDB` everywhere it exists in the database 
   dump.
 * **Backup your database first.**
 *  Thread Starter [crater2131](https://wordpress.org/support/users/crater2131/)
 * (@crater2131)
 * [10 years ago](https://wordpress.org/support/topic/pleasee-i-need-help-php-admin-problem/#post-7289221)
 * hi when i wnat to import database says the next error:
 * Error
 * SQL query:
 * —
    — Dumping data for table wp_comments — INSERT INTO wp_comments ( comment_ID,
   comment_post_ID , comment_author , comment_author_email , comment_author_url ,
   comment_author_IP , comment_date , comment_date_gmt , comment_content , comment_karma,
   comment_approved , comment_agent , comment_type , comment_parent , user_id ) 
   VALUES ( 1, 1, ‘Sr WordPress’, ”, ‘[https://wordpress.org/&#8217](https://wordpress.org/&#8217);,”,‘
   2016-03-05 18:59:12’, ‘2016-03-06 00:59:12’, ‘Hola, esto es un comentario.\nPara
   borrar un comentario simplemente accede y revisa los comentarios de la entrada.
   Ahí tendrás la opción de editarlo o borrarlo.’, 0, ‘post-trashed’, ”, ”, 0, 0);
 * MySQL said: Documentation
    #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
 * what should i do to fix it?, thank u
 *  [Mark Ratledge](https://wordpress.org/support/users/songdogtech/)
 * (@songdogtech)
 * [10 years ago](https://wordpress.org/support/topic/pleasee-i-need-help-php-admin-problem/#post-7289222)
 * You need to drop the tables first. Read [http://stackoverflow.com/questions/18021080/1062-duplicate-entry-1-for-key-primary](http://stackoverflow.com/questions/18021080/1062-duplicate-entry-1-for-key-primary)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Phpmyadmin Problem’ is closed to new replies.

## Tags

 * [comment](https://wordpress.org/support/topic-tag/comment/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Mark Ratledge](https://wordpress.org/support/users/songdogtech/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/pleasee-i-need-help-php-admin-problem/#post-7289222)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics