Local instal does not import posts and content

  • Resolved iamhidari

    (@iamhidari)


    4 years, 4 months ago

    Hello,

    I am trying to re-activate an old blog of mine locally.
    I have database backups as .zip files and the content of the public.html folder from my previous host downloaded to my harddisk.

    I first created a new database using phpmyadmin in Mamp and imported my database backup to this. Looking at the databases post tables I can see all the posts from the old blog.

    Then, I move the contents from the public.html folder to the new folder for wordpress installtions that I specified in Mamp.

    I change the wp-config.php so that it reflects the new database name, user and password are set to root and host to localhost.

    When opening https://localhost:8888/name_of_my_site/wp-admin I get into the install process as usual. The site installs and it has all the plugins and themes I had installed previously.

    But it misses all the content: no posts, no media, no nothing, just the clean site using the default theme.

    Where did I go wrong? Thank you very much for your help!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Do you have the $table_prefix variable in wp-config.php set correctly? Is it pointing to the tables you imported?

    Thread Starter iamhidari

    (@iamhidari)

    The wp-config.php currently states: $table_prefix = ‘HsQAddNs’
    Unfortunately, I have no idea what this means or how to correctly point it towards the tables in my database.
    I have been following tutorial on how to use local instals but otherwise I am complete newbie to wordpress.
    Thank you!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Look at the tables in your database. What are the one(s) ending with “post” named?

    Thread Starter iamhidari

    (@iamhidari)

    The post table is under ‘HsQAddNsposts”, other tables show this prefix as well.

    Thread Starter iamhidari

    (@iamhidari)

    Oh, and further down there is “wp_posts” but the actual posts seem to be listed under “HsQAddNsposts”

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Hmmm…. in that case, you should be seeing your posts!

    Thread Starter iamhidari

    (@iamhidari)

    Hello Steven,
    thank you very much for your repiles. I fixed it thanks to your suggestion with the table_prefix: I deleted all the tables from the database that had wp_ as a prefix so that only the ones with the HsQAddN prefix were left. Then it suddenly worked.
    Thank you very much again for your help!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Local instal does not import posts and content’ is closed to new replies.