Title: mysql import error
Last modified: August 18, 2016

---

# mysql import error

 *  Resolved [janemaraid](https://wordpress.org/support/users/janemaraid/)
 * (@janemaraid)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/mysql-import-error/)
 * Hi there
 * I have exported a mysql database from my local server and I am trying to import
   it to my remote server using php admin. After I try to import it I get this error
 * #1064 – You have an error in your SQL syntax.
 * it points me to the last line of this piece of code
 * CREATE TABLE `wp_categories` (
    `cat_ID` bigint(20) NOT NULL auto_increment, `
   cat_name` varchar(55) NOT NULL default ”, `category_nicename` varchar(200) NOT
   NULL default ”, `category_description` longtext NOT NULL, `category_parent` bigint(
   20) NOT NULL default ‘0’, `category_count` bigint(20) NOT NULL default ‘0’, PRIMARY
   KEY (`cat_ID`), KEY `category_nicename` (`category_nicename`) ) ENGINE=MyISAM
   AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
 * I realise I can open it in a code editor but I have no idea what I am looking
   at and why it is wrong.
 * Any help would be greatly appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [drmike](https://wordpress.org/support/users/drmike/)
 * (@drmike)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/mysql-import-error/#post-499907)
 * What versions of MySQL are you running at home and on your new server? I’m looking
   at the charset statement since that was a change in IIRC 4.1. I run into it on
   occasion.
 *  Thread Starter [janemaraid](https://wordpress.org/support/users/janemaraid/)
 * (@janemaraid)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/mysql-import-error/#post-499932)
 * Hi drmike
 * I am running version 5.0.27 at home and 4.1.13 on the new server. I entered ‘
   none’ in the SQL export compatibility box during export.
 *  Thread Starter [janemaraid](https://wordpress.org/support/users/janemaraid/)
 * (@janemaraid)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/mysql-import-error/#post-499963)
 * I got my SQL database imported through a suggestion from a friend. changed the
   code to
 * CREATE TABLE wp_categories (
    cat_ID bigint(20) NOT NULL auto_increment, cat_name
   varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default”,
   category_description longtext NOT NULL, category_parent bigint(20) NOT NULL default‘
   0’, category_count bigint(20) NOT NULL default ‘0’, PRIMARY KEY (cat_ID), KEY
   category_nicename (category_nicename) ) AUTO_INCREMENT=6 ;
 * I did this for all the tables.
 * I still don’t have my blog up and running (due to other issues completely) and
   I don’t know what changes I made to the content – if any. But it did import.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘mysql import error’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [janemaraid](https://wordpress.org/support/users/janemaraid/)
 * Last activity: [19 years, 2 months ago](https://wordpress.org/support/topic/mysql-import-error/#post-499963)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics