• I am trying to upload my all my wordpress stuff to my new host.
    I suceeded in the FTP of .php files but I am having problems with the MSQL database.

    When I try upload it I get this error:

    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
    —-BEGIN CUT—-
    eNqNUctum0AU3c9XnEWkYAkIYLASpCyoO0pReTg8EjkbQ/HUGRUPFHBkf1sW/aT+QgdLTpM2i+yu
    zj3n3nvuoUkSJy7mJuYWAhq5MGHBNi2SZhJ/JmR+l7o489cu+p91W3Y96/Saf9Pbx1Z9gqnPLFiG
    Mb0wrAtzBtN0jZlrz1Cz7RXovsUZCQ/pbeDC1g3dmmrbcq/VzYbkaYI4VeHd0ChTcUflunsuEMYP
    fhB4cHSDLELPhaXbY/llMXLUOB0nTXV5LRe7PQm86MYFExrvG+3y0rnSTHJc9/v51zyhXkaReZ8C
    iuLHpioHtmk6zvoCCgEKCaz8zwW4GBR7gijOEOVBgHI3NCsuqo5tmRjUE1WUW1bgqeyqx7JTHOeV
    Ys2+l7t6wPn5iT1uOqwEr9hbmXzWB3Rr1lcdbwfeiAID2w8vkrc8GYi88H8HL3ON4+BF4odessRX
    ugSUk+/J2Moj/zanx84rk8rf+sg6tf91pbwDTsgE2XJBr8ODn3ohvDyLV34k0whl1Nemgz+b9Lur
    —-END CUT—-
    —-BEGIN RAW—-

    ERROR: C1 C2 LEN: 1 2 412
    STR: »

    CVS: $Id: sqlparser.lib.php,v 1.62 2003/02/16 11:06:46 lem9 Exp $
    MySQL: 4.0.23-max-log
    USR OS, AGENT, VER: Win MOZILLA 5.0
    PMA: 2.4.0
    PHP VER,OS: 4.3.2 Linux
    LANG: en-iso-8859-1
    SQL: CREATE TABLE kgcategories (
    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=15

    —-END RAW—-

    Error

    SQL-query :

    CREATE TABLE kgcategories (
    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=15

    MySQL said:

    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 ‘CREATE TABLE kgcategories (
    cat_ID int(4) NOT NULL aut

    When I go to my site; kgeiger.net, it says

    Error establishing a database connection! This probably means that the connection information in your wp-config.php file is incorrect. Double check it and try again.

    * Are you sure you have the correct user/password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    I went to http://www.tamba2.org.uk/wordpress/move/ and followed the directions in the wp-config section.

    Does anyone see something wrong with the MSQL coding?

    When I logged into my database it says the host name is

    mysql25.secureserver.net

    Do I need to change the hostname in the config from localhost to that?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘msql database’ is closed to new replies.