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

    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----
    ----END CUT----
    ----BEGIN RAW----

    ERROR: C1 C2 LEN: 1 2 225

    CVS: $Id: sqlparser.lib.php,v 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

    ----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?
    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
    What is the sql query it was trying to run?
    AIM: GopherDesign
    ICQ: 39 401 865

  3. #3
    Join Date
    May 2003
    Heartland, USA
    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


Posting Permissions

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