My first import seems to have failed

  • Resolved larsmon

    (@larsmon)


    8 years, 8 months ago

    I am a berliner..no..I am a beginner.
    I cannot make an import to work.

    I have just installed my first WP site locally (‘VHK’).
    I have got a Welcome site and have done nothing more there.
    We have another site (‘Hammarkullen.com’, under construction but published) which I would like to import to ‘VHK’.
    This site uses no MySql database, but have some pages.
    We have made an export file ‘ hammarkullencom.wordpress.2016-06-22 .xml’.
    To make the import I go to phpMyAdmin, in the left column I mark ‘VHK’ and choose ‘Import’, find the xml file in Browse and click ‘Go’.

    A green marked message says:
    “Import has been successfully finished, 0 queries executed.
    The following structures have either been created or altered. Here you can:
    ? View a structure’s contents by clicking on its name
    ? Change any of its settings by clicking the corresponding “Options” link
    ? Edit structure by following the “Structure” link
    ? vhk (Options)
    (hammarkullencom.wordpress.2016-06-22.xml”

    But I cannot find any sign of the import in ‘VHK’.
    How can I make the imported site visible in my localhost?

    TIA

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

  • Hi @larsmon,
    you are trying to import in a MySQL database a file that doesn’t contain any SQL statement.
    That is why the output message states “0 queries executed”.
    What you can import through phpMyAdmin are SQL statements written by you or an export of another MySQL database, that usually has a .sql extension.
    How did you create the export file ?

    Thread Starter larsmon

    (@larsmon)

    Hi Giancario,

    in the WP site Hammarkullen.com there was a button ‘Export’ that we used, and produced the xml file.
    We want to copy the whole site to a localhost site for development and testing.

    Hi @larsmon,
    first you have to install in your local site the same theme and plugins as your online site.
    Then you can import what you exported in the xml file by executing the following steps:
    1) go to the same WordPress menu where you found Export (Tools menu), click Import
    2) Click WordPress and install the suggested plugin (if not already installed), then activate it
    3) Select your xml file and click Import.

    Please keep in mind that the export procedure only exports the contents of the site (posts, pages, media, custom post types, categories, tags, etc.), but it does not export e.g. the site settings, so you’ll have to set them again in your local installation.

    A possible alternative to the export / import procedure is using a site cloner plugin. You can find them in WordPress plugin directory by using as search terms e.g. “duplicator” or “clone”.

    I hope this will solve your problem.

    Giancarlo

    Thread Starter larsmon

    (@larsmon)

    Hi @giancarlo,

    Thank you very much for clarifying this!!!

    I will follow your instructions and try it again.

    Lars

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘My first import seems to have failed’ is closed to new replies.