Mysql Dump not importing

  • JGrissom

    (@jgrissom)


    13 years, 6 months 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://ww.wp.xz.cn/wo&#8217; 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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    13 years, 6 months ago

    have you contacted your hosting provider?

    Peter Wooster

    (@pkwooster)

    13 years, 6 months 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.

    Thread Starter JGrissom

    (@jgrissom)

    13 years, 6 months ago

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

    Peter Wooster

    (@pkwooster)

    13 years, 6 months ago

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

    Thread Starter JGrissom

    (@jgrissom)

    13 years, 6 months 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>
--

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

The topic ‘Mysql Dump not importing’ is closed to new replies.