msql database
-
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 TABLEkgcategories
(
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 KEYcat_name
(cat_name
),
KEYcategory_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 KEYcat_name
(cat_name
),
KEYcategory_nicename
(category_nicename
)
) TYPE=MyISAM AUTO_INCREMENT=15MySQL 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 autWhen 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?
- The topic ‘msql database’ is closed to new replies.