oh no! import mysql database error
-
i have a new (mt) server and i want to move my wordpress database. so i import it with php admin and now i get this error. how can i fix this different server, different MySQL Versions switch with no fustration?
—————————————-
ErrorSQL query:
— phpMyAdmin SQL Dump
— version 2.6.0-pl3
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Feb 03, 2007 at 06:47 AM
— Server version: 3.23.58
— PHP Version: 4.4.1
—
— Database:myname_de_-_superfun
—
— ——————————————————–
—
— Table structure for tablewp_categories
—
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
)
) TYPE = MYISAM AUTO_INCREMENT =2;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 ‘cat_IDbigint(20) NOT NULL auto_increment,
cat_name` varchar(55) NOT NULL de’ at line 1
——————————————–
- The topic ‘oh no! import mysql database error’ is closed to new replies.