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
    # https://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 table wp_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 TABLE wp_categories (

    cat_ID int( 4 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) NOT NULL default ”,
    category_nicename varchar( 200 ) NOT NULL default ”,
    category_description text NOT NULL ,
    category_parent int( 4 ) NOT NULL default ‘0’,
    PRIMARY KEY ( cat_ID ) ,
    UNIQUE KEY cat_name ( cat_name ) ,
    KEY category_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
    # https://www.phpmyadmin.net
    #
    #’ at line 1

    Thanks. Would really appreciate some help on this!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter idyllopus

    (@idyllopus)

    Never mind. I switched to another text editor and it did fine. I had used Notepad at first and that was a wrong choice.

    Thanks.

    hi idyllopus,

    I am having exactly the same problem. Why is Notepad a bad choice?

    Mind you I will try a different txt editor when I get home and I hope you are right about this !!!

    you were right ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Import database MySQL error with XAMPP’ is closed to new replies.