WordPress.org

Support

Support » How-To and Troubleshooting » Mysql Dump not importing

Mysql Dump not importing

  • 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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • have you contacted your hosting provider?

    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.

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

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

    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.