Saturday 15 January 2011

wordpress - MySQL Script 1064 Error -


I had a WordPress site running on a VPS server and now it will have to migrate to another VPS so I EMS MySql Manager ( Mymanager) that has run an export script from all the tables and exporting data as a script.

Ive then ended up on your new server with the same version of MySQL and MySQL, Manager installed, and try to run the script

However, the script following Continues on the section:.

  table create `wp_commentmeta` (` meta_id` BIGINT (20) Ansnaid tap Attongrement, `Kment_aidi` Bigint (20) Anjinded null default 0,` Meta_ki` VARCHAR (255) Collet Utif 8_jijeriyl dB default nULL, `Meta_vlyue`, Longtekt Collet Utif 8_jiji_abian, primarily key used in Bitry (` Meta_aidi`) cOMMENT '' index using `comment_id` BTREE (` comment_id`) comment 'index using `meta_key` BTREE (`Meta_key`) comment '') engine = InnoDB AUTO_INCREMENT = 7 AVG_ROW_LENGTH = 16384 character set UTF8 = Affirmation utf8_general_ci comment = '';   

with this error (usually):

Error code: 1064. There is an error in your SQL syntax; Manual as sentences using the composition has "note" to "index comment_id using BTREE ( comment_id ) Comment 'corresponds to your MySQL server version for" in 'checking line 6

is to how to solve it and why the original dB works fine and export the script, even though there is a problem trying to run it when the resulting script is. ??? Any ideas as to

What do I tell you on the comment can not contain, but it may vary depending on MySQL version. Anyway, if the comments are still going to be empty, you do not even need them. Just remove

  COMMENT ''   

from your DDL.

No comments:

Post a Comment