Importing WP blog from host to localhost for editing using MAMP

  • OrquiAH

    (@orquiah)


    11 years, 2 months ago

    I exported my live blog site files (using Dashboard Export option) and ended up with an .xml file that I tried to import using MAMP phpMyAdmin:
    1. Choose file
    2. Character set: utf-8
    3. Partial Import: checked allow interruption
    4. Format: SQL
    5. Format specific options: SQL compatibility set to none and checked “Do not use auto_increment for zero values”

    When I click on the Go button, I get the following error message:
    #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 ‘DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1.
    I’m new to all of this and all I want to do is copy my live site so I can work on it on my Mac without messing with traffic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    11 years, 2 months ago

    How did you create this .xml file?

    Thread Starter OrquiAH

    (@orquiah)

    11 years, 2 months ago

    I went to my live blog WordPress Dashboard and used the Export option under Tools. I selected to export all and save the xml file to my desktop.

    esmi

    (@esmi)

    11 years, 2 months ago

    Then try importing it via Tools -> Import and not Phpmyadmin.

    pasjk

    (@pasjk)

    11 years, 2 months ago

    I have a live site designed with IWeb. I already have most of it redone in WordPress on my Imac using MAMP… not at all difficult plus used a url add on to change all our irks already before we go live. Our websites blog page linked to a WordPress blog hosted on our server. I have downloaded the blog folder. We are changing our site domain soon. Before I go active I would like to incorporate the blog into the rest of the website rather than having to reconstruct via cut and paste etc. I am not sure how to link this. Also how would I delete a database in php admin page on MAMP?
    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Importing WP blog from host to localhost for editing using MAMP’ is closed to new replies.