Mysql Dump not importing (6 posts)

  1. JGrissom
    Posted 3 years 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
    Volunteer Moderator
    Posted 3 years ago #

    have you contacted your hosting provider?

  3. Peter Wooster
    Posted 3 years 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
    Posted 3 years ago #

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

  5. Peter Wooster
    Posted 3 years ago #

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

  6. JGrissom
    Posted 3 years ago #

    It is a SQL Dump

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

Topic Closed

This topic has been closed to new replies.

About this Topic