Errors when importing SQL
-
I have created a wp site locally on my mac using MAMP. Now i want to upload it to the internet, but I’m having some trouble with the database.
I have uploaded all files using ftp, and then i log in to myPHP and import the database, but i keep getting this error#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 '\'0\', <code>meta_key</code> varchar(255) DEFAULT NULL, <code>meta_value</code> longtext, PRI' at line 3
This is my code:
CREATE TABLE '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') ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
can someone please help me?
- The topic ‘Errors when importing SQL’ is closed to new replies.