restoring database

  • I am doing this

    Moving WordPress to a New Server with Fantastico

    Some webhosts use a service called Fantastico, which can install a vanilla WordPress web with just a few clicks. You can transfer your blog to one of these webs, but the steps are slightly different.

    Begin by backing up your data. This includes backing up your WordPress database as well as all the core files, images, plugins, and other files on your site. See WordPress Backups and Backing Up Your Database for more details.

    Make a copy of your database. You will need to edit the .sql file, and in case of errors, it is important that you work on a copy.

    Begin the process of working from copies of your backups.

    If you have changed domain, edit the backed up database file to reflect this. A simple way to do this is:
    Using a text editor, open a copy of the .sql database file.
    Using the search and replace function, find all instances of the blog’s old URL and replace it with the new URL.
    Repeat the process with your old email address. (For example, replacing [email protected] with [email protected])
    Save your changes.
    Upload your plugins and themes from your old site to the new one.
    Drop (delete) the database tables of the pre-installed Fantastico web.
    Restore the database.
    When you are ready to check your site, make sure to clear your cache and cookies so you will see the changes in your web browser.

    I have got error when restoring database from old host zymic to x10hosting

    Error
    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unknown Punctuation String @ 5
    STR: ://
    SQL: https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump
    — version 2.11.4
    — https://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jul 14, 2008 at 04:02 PM
    — Server version: 5.0.27
    — PHP Version: 4.3.10-16

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

    SQL query:

    https://shyguy.x10hosting.com/blg– phpMyAdmin SQL Dump — version 2.11.4 — https://www.phpmyadmin.net — — Host: localhost — Generation Time: Jul 14, 2008 at 04:02 PM — Server version: 5.0.27 — PHP Version: 4.3.10-16 SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

    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 ‘https://shyguy.x10hosting.com/blg
    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”‘ at line 1

Viewing 2 replies - 1 through 2 (of 2 total)

  • Oh come on, someone has a clue. I’ve checked the manual and I can’t find it. I know it has to do with dis-similar databases, but where is it in the manual?

    first of all find out the version of mysql running on your old host versus your new host.

    Im pretty sure you are probably trying to put a new version of mysql coding into an older mysql system .

    you can try opening up your sql file in word pad and do a search on SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; and replace with a space to try to remove all that code in one shot, and do this for all errors you encounter. or you can just request to your host what version of mysql you will be needing, but if this is a shared host account you will prolly not get any help with that.

    try what i said .. remove the code that is giving you errors

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘restoring database’ is closed to new replies.