• 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.