Title: Move database, import problem
Last modified: August 18, 2016

---

# Move database, import problem

 *  [MilleSabords](https://wordpress.org/support/users/millesabords/)
 * (@millesabords)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/move-database-import-problem/)
 * I’m trying to move my blog. Export seems OK. Unable to import to the new MySQL
   database. Here is the error :
    CREATE TABLE `wp_categories` ( `cat_ID` bigint(
   20) NOT NULL auto_increment, `cat_name` varchar(55) collate latin1_general_ci
   NOT NULL default ”, `category_nicename` varchar(200) collate latin1_general_ci
   NOT NULL default ”, `category_description` longtext collate latin1_general_ci
   NOT NULL, `category_parent` int(4) NOT NULL default ‘0’, PRIMARY KEY (`cat_ID`),
   KEY `category_nicename` (`category_nicename`) ) ENGINE=MyISAM DEFAULT CHARSET
   =latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6
 * MySQL a répondu:
 * 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 ‘collate latin1_general_ci
   NOT NULL default ”,
    `category_nic
 * Can someone help me?Thanks

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/move-database-import-problem/#post-245218)
 * _DEFAULT CHARSET=latin1 COLLATE=latin1\_general\_ci_
 * Do a search/replace on the whole sql file and replace the above with nothing.
   Just delete that line and all will be good.
 *  Thread Starter [MilleSabords](https://wordpress.org/support/users/millesabords/)
 * (@millesabords)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/move-database-import-problem/#post-245255)
 * I get exactly the same error
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/move-database-import-problem/#post-245267)
 * collate latin1_general_ci
 * Check that line is nowhere ?

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

The topic ‘Move database, import problem’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Mark (podz)](https://wordpress.org/support/users/podz/)
 * Last activity: [20 years, 10 months ago](https://wordpress.org/support/topic/move-database-import-problem/#post-245267)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics