WordPress.org

Ready to get started?Download WordPress

Forums

Trouble Restoring Database (2 posts)

  1. katia
    Member
    Posted 9 years ago #

    Hi. Moving to a new server, and I'm having a bit of trouble restoring the databases! Followed instructions, but got 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----
    eNqdkE1u2zAQhfc8xSyylGhSsVqbO9VWHQOSpYpKWnQT0xZbC9UPQ1FRfLYseqReoaQRI0CXJUCC
    ePP4Ps7ERZEVDFYUVgEk8Y4BhQBuFyHipdVfEVo9cAY324rB8NQooQepcVMfsDop7xkCHHyEgJD5
    jNIZCYEQNqcsDKGR7RLiFwU3KD3zLwmDOSY4CPzBiK4SukL3vICMexBt4l3pwUNseV/rDtLs+zZJ
    IggxQXkaMcv4gKmvmgDld7nzeRl3cbeYEkjqbnxBSbTbMJCdXw+9v1iES5+iC/TP62/fB/vX9BxV
    rU23KqzHViErP0s91H33BtBH6sSTMYrNZtM0uRbbs3DPcCeNK7p91w+GQdMfRXOyVydtZCe1MC6r
    rFvJIBUaKPXcZEIQBsiShQTy1Jm51BZ8hV/n4iqX9t5l198VuhZGHMRgo/eVbPuufhofJ/XLMsX+
    4nGH/58LXSmlODQSBqPHoxm1hB+9BnPR9pN6PAojf/a6lsMbcl1kOZTRpySG7WeIv215yf91/gWf
    F6fa
    ----END CUT----
    ----BEGIN RAW----

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

    CVS: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
    MySQL: 4.0.22-standard
    USR OS, AGENT, VER: Win MOZILLA 5.0
    PMA: 2.6.1-pl2
    PHP VER,OS: 4.3.10 Linux
    LANG: en-iso-8859-1
    SQL: -- phpMyAdmin SQL Dump
    -- version 2.6.1-rc1
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Mar 11, 2005 at 09:50 PM
    -- Server version: 4.0.22
    -- PHP Version: 4.3.10
    --
    -- Database: demoniqu_wpkatia
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table wp_categories
    --

    DROP TABLE IF EXISTS wp_categories

    ----END RAW----

    SQL-query:

    -- phpMyAdmin SQL Dump -- version 2.6.1-rc1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 11, 2005 at 09:50 PM -- Server version: 4.0.22 -- PHP Version: 4.3.10 -- -- Database: demoniqu_wpkatia -- -- -------------------------------------------------------- -- -- Table structure for table wp_categories -- DROP TABLE IF EXISTS wp_categories

    MySQL said: Documentation
    #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.6.1-rc1
    -- http://www.ph

    I'd appreciate any help I could get!

  2. katia
    Member
    Posted 9 years ago #

    Nevermind. After three different downloads and attempts, it finally, somehow worked. Yay!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.