• 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
    ——————————————–

  • The topic ‘oh no! import mysql database error’ is closed to new replies.