MySQL error when trying to import backup into new database
-
I am in the process of moving to a new domain, which includes my WordPress blog (http://chocolatedream.net/blog). I updated it to WP 2.01, created a database back up and edited it according to the Moving WordPress Codex post (http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_to_a_New_Server).
But when I try to import the sql dump into the new database, I get the following error:
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—-
eNqlU8tymzAUdbesOt10exeZsT0DBIidpprJgjiy4yng1OBMuzIClJgprwiRxMv2I7ro1/Qv+ju9
SuIk0+mq1SAhzj1X9+hI0OVysSQwsWHigEcDAhbY8G58pIUR4j1Nm1yEBPbmGYH2umiYaLkwizwx
m02j34BjHhyCY1njfesIH5wSxyG2DQUv3wO9a2BP87fhR4/A2LRM+8hoJasyJjKjqK+0VbiERaiD
O6NBpMMFxZo+S2FOke4caOe+S7DGoTkymgI/z84VR1+gpJE5MlFyXnV3mucGMwK8Mjp5aaB0Va73
Jt3UaV0wyY0Ea5kov/ef7fWvRL1+vv3+Q3Wclifz4E/Wt6/uq17PMAAt8rduVuYVoCQ47cpGQ/iG
izavqxf7QnAjZUP2929vb5Wz5ZapNLPiUgVVP6tbSaDc4jYc82lrmeCs3NFmvOKCSbV2lJecwJQn
YI90dUCHwCRYY2LZ4PqKHHKBQnZilJ+2aY9V5N7lZxht3mk4ZZIlrMWV4ycFa2VufM9Qg/GPTdvV
iFhScGil6FLZCQ6XtQB5j8VJwdIvRd7Kx3KTJXUjCpF74tGXURhoAHGexZBXcmDbQwgWEQQrzwPW
yXqdV6ngJa+krniCX/G7GG6YSDdMDNCrF/yMX7KukNDvP3PXctvwGK9bVw76edPX+50o+n9LUrjK
+0A/P+gZqHGooCkSI/opeog9ahg8TobaEGgwmwf02N/OQ9eHUzp1V14EkzN3GdLoGJ3PKzzKVbRY
zwM0wscf6PjAHo3gN/WU/QU=
—-END CUT—-
—-BEGIN RAW—-ERROR: C1 C2 LEN: 0 1 758
STR:CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 5.0.18-standard-log
USR OS, AGENT, VER: Mac IE 5.23
PMA: 2.6.4-pl3
PHP VER,OS: 4.4.2 Linux
LANG: en-utf-8
SQL: chocolate-blog.sql?b??????mBIN??A– phpMyAdmin SQL Dump
— version 2.6.4-pl3
— http://www.phpmyadmin.net
—
— Host: mysql2.chocolatedream.net
— Generation Time: Feb 14, 2006 at 05:01 AM
— Server version: 4.1.15
— PHP Version: 4.4.2
—
— Database:chocolate_blog
—— ——————————————————–
—
— Table structure for tableblacklist
—CREATE TABLE
blacklist
(
id
int(11) NOT NULL auto_increment,
regex
varchar(200) NOT NULL default ”,
regex_type
enum(‘ip’,’url’) NOT NULL default ‘url’,
KEYid
(id
),
FULLTEXT KEYregex
(regex
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3144
—-END RAW—-Since I don’t know anything about mysql I have no idea what the problem is and how to fix it. Any help would be greatly appreciated!
- The topic ‘MySQL error when trying to import backup into new database’ is closed to new replies.