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.orghere 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 tablewp_categories
#
# Creation: Jan 09, 2006 at 05:46 PM
#
CREATE TABLEwp_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
) ,
KEYcategory_nicename
(category_nicename
)
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =4MySQL 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.