WordPress.org

Ready to get started?Download WordPress

Forums

Problems With Switching Between Servers (Search + Replace URLs) (3 posts)

  1. joshspazjosh
    Member
    Posted 8 years ago #

    So I'm following the instructions in the Codex, doing what it says and everything, and it says to replace the name of your old blog URL with your new one. So I go into Notepad and do:

    "FIND: http://www.joshspazjosh.com/project-am/main

    REPLACE: http://www.project-am.info/blog"

    When I'm done and saved and try to restore with phpmyadmin I get 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----
    eNqdU8uOm0AQvM9X9GGltSWDAT/iHWkPxEZeK4AJ4I18MmOYtYlgIMP49W172E/KL2QGxUk28iEK
    EghVV3V19YAThssQw9SEqQWu42MwwYIP1hBFscRfEZo+RxjuFhmG5ltRE95Qrhf5Vq/3de8Ilj4Y
    6pYuRYYx6hvj/sAAc4xHE2yaUNDyAZxzDXfIu0SfXQxD3dCtkdYIwjLCM7SKQlhGPbDnjh/34NmR
    nl9yBgsHxrqBAs/G0mKsD7S6MFHwFChKbxmpTgNdWrg5O5yRa/tzDJRpeVNpk8noQTNR6/f99U3T
    QI7qXeyslI0lCrNDWSMJHylv8oq1BkNpYClwL0SN+/3T6aQSlheiZDqjQhXV/VQ1AkNRpaTYy1cF
    zSmjnAjVK85LisGv5GYGvXYpQASYFjbHEHiKHFEuja/mKoipm0NVaeP9hlW+q+mMCLIljWydfK2a
    fVOTzbaodklbVw/tPy90dYjJtqDQCH5IxYFTeKk4iBZLTvUmJYLuKp7T5qflNHTs2IHY/ug6fzOg
    gwASCWwWswS2+S5nomMZXfCXMfgr1wVyENUmZymnJWWid6UzUtIEjoSne8I7o9Efioy+kEMh4P7+
    ylZulw3LU/peJnf+D7qMNinPa3VmiTxMthP0LH7J3nPlRy+nTEDFGN7qbbTNg3Dh2eEaPjlrgM41
    f1eVFHRr5s4NsIu6EK8D59G7LCLbA3sVLzcLXy7ck//IowU/ANvxEuA=
    ----END CUT----
    ----BEGIN RAW----

    ERROR: C1 C2 LEN: 1 2 724
    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: -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Nov 23, 2005 at 12:16 PM
    -- Server version: 4.1.14
    -- PHP Version: 4.3.11
    --
    -- Database: joshspa_blog
    --

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

    --
    -- Table structure for table wp_categories
    --

    CREATE TABLE wp_categories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
    category_description longtext NOT NULL,
    category_parent int(4) NOT NULL default '0',
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename)
    ) TYPE=MyISAM AUTO_INCREMENT=2
    ----END RAW----
    SQL query:

    -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 23, 2005 at 12:16 PM -- Server version: 4.1.14 -- PHP Version: 4.3.11 -- -- Database: joshspa_blog -- -- -------------------------------------------------------- -- -- Table structure for table wp_categories -- CREATE TABLE wp_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default '', category_nicename varchar(200) NOT NULL default '', category_description longtext NOT NULL, category_parent int(4) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) ) TYPE=MyISAM AUTO_INCREMENT=2
    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.4-pl2
    -- http://www.ph

    -------

    I've uploaded the backup without changing the filenames. When I do this, everything works fine, except when I try to log in I get redirected to my old server. So I know that the problem has to do with what happens when I change the filenames. Can anyone help?

    -Josh

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

    

    That's what is breaking it, and whatever editor you used to open the sql file is adding it.

    They are the very first characters in the sql file, and notepad++ is a good editor for the job.

  3. joshspazjosh
    Member
    Posted 8 years ago #

    I can't find those three characters in the file in Notepad or Notepad++.

    Could phpmyadmin be doing it? I have an old version on my new server, it only accepts MySQL v4.0. . .

    EDIT: Fixed. Cut and pasted the database into the input box and pressed "Query". Everything's fine now, I think. . .

Topic Closed

This topic has been closed to new replies.

About this Topic