Title: Data Base import Error
Last modified: August 18, 2016

---

# Data Base import Error

 *  [metaltiger](https://wordpress.org/support/users/metaltiger/)
 * (@metaltiger)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/data-base-import-error/)
 * I am getting an error report when trying to import a database in my new host 
   for the web site:
    [http://nurseanesthetist.org](http://nurseanesthetist.org)
 * here is the error report:
 *  SQL-query:
 * # phpMyAdmin SQL Dump
    # version 2.5.2-pl1 # [http://www.phpmyadmin.net](http://www.phpmyadmin.net)##
   Host: localhost # Generation Time: Jan 15, 2006 at 02:55 PM # Server version:
   4.1.11 # PHP Version: 4.3.6 # # Database : `anesthetist` # # ——————————————————–##
   Table structure for table `wp_categories` # # Creation: Jan 09, 2006 at 05:46
   PM # 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 = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =4
 * 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=4’ at line 30
 * *********************************************************
    So how do I fix this
   and get my web site data base moved? frustrated because I have been working on
   this for the past week. Thanks in advance. david

The topic ‘Data Base import Error’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [metaltiger](https://wordpress.org/support/users/metaltiger/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/data-base-import-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics