• I am getting an error report when trying to import a database in my new host for the web site:
    http://nurseanesthetist.org

    here is the error report:

    SQL-query:

    # phpMyAdmin SQL Dump
    # version 2.5.2-pl1
    # 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.