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?
----------------------------------------
Error
SQL 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 table wp_categories
--
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 )
) 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_ID bigint(20) NOT NULL auto_increment,cat_name` varchar(55) NOT NULL de' at line 1
--------------------------------------------
