WordPress.org

Ready to get started?Download WordPress

Forums

Mysql Dump not importing (6 posts)

  1. JGrissom
    Member
    Posted 1 year ago #

    Hello, I am trying to import a MySQL Dump I created from a previous domain to my new domain, I have done this about 20 times as I do this for my job. I have not ran into this problem ever.

    when I try to import my MySQL Dump file I get this error in PHPMyAdmin
    #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 'll want "bleeding edge nightlies"). Or you can <a href="http://wordpress.org/wo' at line 2

    now I know the problem is being caused by a '

    how do I fix this problem? This website is supposed to go live tonight but it seems I will not be able to make it go live. It will take me weeks to get this website back to the way it was.

  2. Tara
    Member
    Posted 1 year ago #

    have you contacted your hosting provider?

  3. Peter Wooster
    Member
    Posted 1 year ago #

    Did you dump in sql format or delimited format. If you used delimited format, you needed to specify an escape character, without that you will have a hard time restoring form that. I usually use the wp-migrate-db plugin to export WordPress databases as it dumps in sql format and it adjusts embedded urls.

  4. JGrissom
    Member
    Posted 1 year ago #

    I just did a default MySQL Export I did not set anything.

  5. Peter Wooster
    Member
    Posted 1 year ago #

    What does the dump look like? Is it SQL or is it a CSV?

  6. JGrissom
    Member
    Posted 1 year ago #

    It is a SQL Dump

    -- phpMyAdmin SQL Dump
    -- version 3.3.10.4
    -- http://www.phpmyadmin.net
    --
    -- Host: **
    -- Generation Time: Nov 27, 2012 at 12:14 PM
    -- Server version: 5.1.56
    -- PHP Version: 5.3.13
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    
    --
    -- Database: <code>**</code>
    --
    
    -- --------------------------------------------------------

Topic Closed

This topic has been closed to new replies.

About this Topic