Change TYPE=InnoDB to ENGINE=InnoDB everywhere it exists in the database dump.
Backup your database first.
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/’, ”, ‘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
(@crater2131)
10 years, 1 month ago
[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_idbigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,comment_idbigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,meta_keyvarchar( 255 ) DEFAULT NULL ,meta_valuelongtext,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