• 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 table blacklist

    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’,
    KEY id (id),
    FULLTEXT KEY regex (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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • In the normal, such errors never should be seen by end user. I suggest you to reinstall MySQL 4.1 branch, this is more stable and more tested. You are using 5.0 version that rather new

    Open the .sql file in WordPad or a plain text-editor
    Check that the VERY first thing is
    -- phpMyAdmin SQL Dump

    There must be absolutely nothing at all before that.
    If there is, remove it
    Save the file
    Retry

    Do not use anything other than a plain text-editor for this.

    Thread Starter shirasade

    (@shirasade)

    Thanks for the help – since there’s nothing before that first line in the sql file, I guess I’ll get in touch with my webhost about the error.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL error when trying to import backup into new database’ is closed to new replies.