Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Somerset, UK
    Posts
    162

    mysql error when restoring db

    When restoring a database via the SQL command in phpMyAdmin, The following error occurs:

    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----
    eNqdkM9qwkAQxs/dp5iCJ8ludvMPXSgY4qJCNGk2tccQm4DBmKRZFdtX89BH6it046WXnjrMwPDx
    zfyYEUkSJRwCBoEFodhwYGCBZblIplq/IRRsJYfRquCg3usu71XZk7rakW7fGRewiO0Qi+ghSl2T
    eqZNgXncnXDGoC6PUxDXDkZo/SGfQw4OocRysTrlTZH3BXqRCUTSAH8hNqkBW6GZr1UDKwEeoShe
    +1wjPGLjrmYoXsaDxYjksMkmGhFWzfmKQn+z4FA2uFItnkzcKWbozvu+fWEMdzgU52MHjJIpwlgn
    LFt14lC3b3m91y3omOenfJerksOhag6fmdq33WDF/4phUpb9pexBl6ra5sEhjDD7935kjh8dyigD
    KVKYReE8C5Z+4gepSDItZUG40p95ms3+kmFs/gBNr3VO
    ----END CUT----
    ----BEGIN RAW----

    ERROR: C1 C2 LEN: 1 2 225
    STR:

    CVS: $Id: sqlparser.lib.php,v 2.34.2.1 2005/06/30 16:58:11 lem9 Exp $
    MySQL: 4.0.25-standard
    USR OS, AGENT, VER: Win IE 6.0
    PMA: 2.6.3-pl1
    PHP VER,OS: 4.3.11 Linux
    LANG: en-iso-8859-1
    SQL: -- MySQL dump 10.9
    --
    -- Host: localhost Database: kinkz_shop
    -- ------------------------------------------------------
    -- Server version 4.1.13-standard

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
    ----END RAW----
    SQL query:

    -- MySQL dump 10.9 -- -- Host: localhost Database: kinkz_shop -- ------------------------------------------------------ -- Server version 4.1.13-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
    MySQL said:

    #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 '-- MySQL dump 10.9
    --
    -- Host: localhost Database: kink


    Can anyone help please?
    Youzo.co.uk
    http://www.youzo.co.uk
    Funky gifts, gadgets, clothing and homeware for him, for her, for the kids, for lovers, for the kids and for everything else!

  2. #2
    Join Date
    Sep 2003
    Location
    USA
    Posts
    64
    What is the sql query it was trying to run?
    AIM: GopherDesign
    ICQ: 39 401 865
    WWW: http://www.gopherdesign.com
    WWW: http://www.gopherwebhosting.com

  3. #3
    Join Date
    May 2003
    Location
    Heartland, USA
    Posts
    733
    How was the MySQL Back-Up created? Via a cPanel Full Back-Up? If so, then if the database is large there may be a possibility that the back-up is corrupt. I have had this happen on several occasions...

    "tail" your MySQL Dump File... Is the last SQL Command in there truncated off? If so... Its a bad back-up!
    You've got to accentuate the positive; Eliminate the negative
    Latch on to the affirmative; Don't mess with Mister In-Between

    -Bob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •