Title: Errors when importing SQL
Last modified: August 21, 2016

---

# Errors when importing SQL

 *  [j4ze](https://wordpress.org/support/users/j4ze/)
 * (@j4ze)
 * [12 years ago](https://wordpress.org/support/topic/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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [j4ze](https://wordpress.org/support/users/j4ze/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/errors-when-importing-sql/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics