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

---

# MySQL import error

 *  [harold](https://wordpress.org/support/users/harold/)
 * (@harold)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/mysql-import-error-1/)
 * I’m migrating from one hosting service (Dreamhost) to another (1and1 Internet).
   Every time I try to import my database using phpMyAdmin, I receive the following
   error. Anyone know what I need to fix in order to get the database properly imported?
   Thanks!
 * ERROR:
 *  SQL query:
 * 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’, `link_count` bigint( 20 ) NOT NULL default ‘0’, `posts_private` tinyint( 
   1 ) NOT NULL default ‘0’, `links_private` tinyint( 1 ) NOT NULL default ‘0’, 
   PRIMARY KEY ( `cat_ID` ) , KEY `category_nicename` ( `category_nicename` ) ) 
   ENGINE = MYISAM AUTO_INCREMENT =24DEFAULT CHARSET = latin1 AUTO_INCREMENT =24
 * MySQL said: Documentation
    #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 ‘DEFAULT CHARSET=latin1 AUTO_INCREMENT=24’ at line 13

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

 *  [drmike](https://wordpress.org/support/users/drmike/)
 * (@drmike)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/mysql-import-error-1/#post-528283)
 * What versions of MySQL are you coming from and going to? I know I’ve had issues
   with the default characterset in the past. I’m wondering if this is another case
   of it.
 *  [omgitztrey](https://wordpress.org/support/users/omgitztrey/)
 * (@omgitztrey)
 * [18 years, 8 months ago](https://wordpress.org/support/topic/mysql-import-error-1/#post-528481)
 * I need help with this too. Some brave soul please solve this before I rip someones
   head off at 1and1.
 *  [ccoupe](https://wordpress.org/support/users/ccoupe/)
 * (@ccoupe)
 * [18 years, 8 months ago](https://wordpress.org/support/topic/mysql-import-error-1/#post-528482)
 * Been there. It’s a downgrading problem. Your new host has an older version of
   mysql, charset handling changed from V3, V4, and V5 and are not downgradable.
   While it is possible to fix the syntax after a lot of mysql RTFM and get it to
   load, it’s going to have broken characters and can’t really be undone if you 
   do that. Trust me.Just don’t do it.
 * Ask your new host to updgrade their mysql version or find a different host.

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

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

## Tags

 * [1and1](https://wordpress.org/support/topic-tag/1and1/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [dreamhost](https://wordpress.org/support/topic-tag/dreamhost/)
 * [importing](https://wordpress.org/support/topic-tag/importing/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 4 participants
 * Last reply from: [ccoupe](https://wordpress.org/support/users/ccoupe/)
 * Last activity: [18 years, 8 months ago](https://wordpress.org/support/topic/mysql-import-error-1/#post-528482)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics