restoring content from the database

  • I managed to break a site with several years worth of content. The database, however, was not harmed so I reinstalled WP and set it to use the same database but it created a new database user so now all my old content is invisible to the new site. Reading around, I see that I screwed up, but I’m not quite sure how to proceed. How can I get a new WP to read the old database?

    peace, love and macadamia biscuits,
    -rjs.

    PS. this is being hosted by dreamhost if that’s important at all.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter lugubriousfandango

    (@lugubriousfandango)

    Reading a bit more I tried putting in the database username and password from my old site into wp-config for the new one, but that doesn’t seem to have changed anything. It’s still acting as a virgin WP site.

    Thread Starter lugubriousfandango

    (@lugubriousfandango)

    Sorry, I didn’t fill in all the details correctly. It worked. Sort of.

    Unfortunately, I am now back to the same position I was to begin with. My blog is at robinshannon.net but WP thinks that everything is at lf.www.robinshannon.net so it shows only the text above the fold. No theme no nothing. And if you try to go to a full article it sends you to a non-existent page.

    you could fix that via phpmyadmin.. login to your web host and open phpmyadmin. click the database of your wp installation.

    do a search for lf.www.robinshannon.net in the wp_options table (wp_ may be different depending on the prefix you used in the installation)

    search results will appear which then you click browse.. click the edit button and change the value to

    https://robinshannon.net

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘restoring content from the database’ is closed to new replies.