WordPress.org

Ready to get started?Download WordPress

Forums

database restoration problems (4 posts)

  1. xtheunderdog
    Member
    Posted 9 years ago #

    so, i've followed all the directions perfectly for moving wp databases from one server to another. twice. the third time it's not working. the other two worked perfectly, but this one refuses to. i've tried editing and reuploading the sql file about five times.

    i keep getting this:
    "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----
    eNqdkM2O2yAUhfc8xV3M0iZA4jTDzk3cTCTnp8addjchMdNY8g8FMp482yzmkfoKhahRqy6LBELn
    Hs7HvVlRbAsOcwpzBnm24UCBwXg2RqL0+htC80fB4W5VcbA/Gi2NVQY39QHrk45egGH2ARghkxGl
    I5IAIXxCeZJAo9p7yF413KH1RXzOOUwwwYzF1smukqZCX0QBWxFBusw2ZQSPmed9rTtYZTDFBO3W
    KffxU0xj3TC0e9gFS7QVIWmMKYG87s6vKE83Sw6qi2vbx7NZch9TdOX9fHuPY/DfXF/SqvXBXoXF
    udXIyy/K2Lrv/gJ48eSc5qPRMAyhu/YiwzPcKReKYT/01nFo+qNsTv4apKXqlJEuZJV1qzik2gCb
    RGEoCUgHhHIyhXQdzEIZD77BbyMJlWt7f+TQ3w26kE4epPXRe9c8Pw29qbRR1rL91RGO+D8XujFK
    eWgUWGfOR3c2Cp57A+6q7Qf9dJROfe9Nrexv5KLY7qBMP+YZrD5B9m0lSvGv8xeEG6VW
    ----END CUT----
    ----BEGIN RAW----

    ERROR: C1 C2 LEN: 1 2 383
    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 IE 6.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-pl2
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Apr 24, 2005 at 01:06 AM
    -- Server version: 4.0.22
    -- PHP Version: 4.3.10
    --
    -- Database: tlf_wordpress2
    --

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

    --
    -- Table structure for table wp_categories
    --

    DROP TABLE IF EXISTS wp_categories
    ----END RAW----
    SQL-query:

    -- phpMyAdmin SQL Dump -- version 2.6.1-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 24, 2005 at 01:06 AM -- Server version: 4.0.22 -- PHP Version: 4.3.10 -- -- Database: tlf_wordpress2 -- -- -------------------------------------------------------- -- -- Table structure for table wp_categories -- DROP TABLE IF EXISTS wp_categories
    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 '-- phpMyAdmin SQL Dump
    -- version 2.6.1-pl2
    -- http://www.ph "

    help?

  2. Mark (podz)
    Support Maven
    Posted 9 years ago #

    I'll probably be able to fix it, but trying to describe what I do is really hard because what I do depends on various things.
    If you want to email me the .sql file or upload it to your webspace and provide me with a download link I'll sort it out and let you know what the solution is ?

    Your data is safe and I'll delete it once you have it all happily back with you.

    tamba2 at gmail dot com

  3. xtheunderdog
    Member
    Posted 9 years ago #

    emailed it-- thank you sooo much.

  4. Mark (podz)
    Support Maven
    Posted 9 years ago #

    Back at you :)

Topic Closed

This topic has been closed to new replies.

About this Topic