Import database MySQL error with XAMPP
-
Hi,
Hopefully someone can help me out here. Importing my database file into XAMPP I get the following:
# phpMyAdmin SQL Dump
# version 2.5.2-pl1
# http://www.phpmyadmin.net
#
# Host: 127.0.0.1
# Generation Time: Feb 27, 2005 at 08:25 PM
# Server version: 4.0.20
# PHP Version: 4.3.10
#
# Database :etcetera
#
# ——————————————————–
#
# Table structure for tablewp_categories
#
# Creation: Feb 12, 2005 at 08:11 PM
# Last update: Feb 12, 2005 at 08:11 PM
# Last check: Feb 27, 2005 at 04:51 AM
#
CREATE TABLEwp_categories(cat_IDint( 4 ) NOT NULL AUTO_INCREMENT ,
cat_namevarchar( 55 ) NOT NULL default ”,
category_nicenamevarchar( 200 ) NOT NULL default ”,
category_descriptiontext NOT NULL ,
category_parentint( 4 ) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID) ,
UNIQUE KEYcat_name(cat_name) ,
KEYcategory_nicename(category_nicename)
) TYPE = MYISAM AUTO_INCREMENT =2
MySQL said:#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 ‘# phpMyAdmin SQL Dump
# version 2.5.2-pl1
# http://www.phpmyadmin.net
#
#’ at line 1Thanks. Would really appreciate some help on this!
The topic ‘Import database MySQL error with XAMPP’ is closed to new replies.